|
Server : LiteSpeed System : Linux terra.hostitbro.com 5.14.0-611.54.3.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu May 7 16:31:24 EDT 2026 x86_64 User : outerorb ( 1091) PHP Version : 8.1.34 Disable Function : mail Directory : /home2/outerorb/dev.outerorbittech.com/oot/admin/ | |
|
Path: /home2/outerorb/dev.outerorbittech.com/oot/admin/manage_clients.php
Size: 10.72 KB
Permissions: 0644
<?php
include_once("../include/main.inc.php");
check_session('MyCpanel','index.php');
################ Paging Starts From Here ##################
@extract($_REQUEST);
$start = (intval($start)<0 or $start=="")?0:$start;
$pagesize = intval($pagesize)==0?$pagesize=100:$pagesize;
$heading="Manage Clients";
$record_type="Clients";
$script_name="manage_clients.php";
$table_name="client_tbl";
####################################################
if($id=="add_record" && $_FILES['collar']['name']!="") {
if($_FILES['collar']['name']!="") {
$file_extension=strtolower(getExtension($_FILES['collar']['name']));
if($file_extension!="jpg" && $file_extension!="gif" && $file_extension!="jpeg" && $file_extension!="png") {
$form_check_alert .="<li>Please upload small image(.jpg,.gif,.png Format Only)</li>";
}
}
if(!strlen($form_check_alert)>0) {
if($_FILES['collar']['name']!="") {
$imgtitle = str_replace(" ", "-", $title);
$img_name="clients_".strtolower($imgtitle);
$img1=upload_file($img_name,"collar","uploaded-files/client-image");
}
// $maxRes=db_fetch_array(db_query("select max(order) from $table_name"));
// $order=$maxRes[0]+1;
$sql=db_query("insert into $table_name set name='$title',logo_image='$img1'");
$_SESSION['session_message']='New '.$record_type.' has been added successfully';
header("Location: ".SITE_ADMIN_URL."/".$script_name."?start=".$start."&pagesize=".$pagesize);
exit;
}
else {
$msg=html_head();
$msg.=$form_check_alert;
$msg.=html_foot();
}
}
if($action=="Update") {
while (list($key,$val)=each($_POST)) {
if (substr($key,0,6)=="order_") {
$key1 = substr($key,6,strlen($key)-6);
$qry1=mysqli_query($dbconn,"UPDATE `$table_name` SET `client_order`={$val} WHERE `id`={$key1}");
}
}
$_SESSION['session_message']=$record_type.' order has been updated successfully';
header("Location: ".SITE_ADMIN_URL."/".$script_name."?start=".$start."&parentID=".$parentID."&catID=".$catID."&pagesize=".$pagesize);
exit;
}
if($id=="update_record") {
if($_FILES['collar']['name']!="") {
$file_extension=strtolower(getExtension($_FILES['collar']['name']));
if($file_extension!="jpg" && $file_extension!="gif" && $file_extension!="jpeg" && $file_extension!="png") {
$form_check_alert .="<li>Please upload small image(.jpg,.gif,.png Format Only)</li>";
}
}
if(!strlen($form_check_alert)>0) {
if($_FILES['collar']['name']!="") {
$res1=getResult($table_name," where id='$recordID'");
$filenm1=SITE_DIR_PATH."/uploaded-files/client-image/".$res1['logo_image'];
if (file_exists($filenm1)) {
unlink($filenm1);
}
$imgtitle = str_replace(" ", "-", $title);
$img_name="clients_".strtolower($imgtitle);
$img1=upload_file($img_name,"collar","uploaded-files/client-image");
updateTable($table_name," logo_image='$img1' where id='$recordID'");
}
$bannerUrl=$bannerUrl;
mysqli_query($dbconn,$table_name," name='$name' where id='$recordID'");
$_SESSION['session_message']=$record_type.' has been updated successfully';
header("Location: ".SITE_ADMIN_URL."/".$script_name."?start=".$start."&pagesize=".$pagesize);
exit;
}
else {
$msg=html_head();
$msg.=$form_check_alert;
$msg.=html_foot();
}
}
if($id=="delete_record") {
mysqli_query($dbconn,"delete from $table_name where id='$recordID'");
$_SESSION['session_message']=$record_type.' has been deleted successfully';
header("Location: ".SITE_ADMIN_URL."/".$script_name."?start=".$start."&pagesize=".$pagesize);
exit;
}
admin_header("");
?>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0" valign="top">
<tr>
<td align="left" width="50%" class="myTitle"><?=$heading;?></td>
<td align="right">
<form name="pgimg_form" action="<?=$PHP_SELF?>" method="post" style="margin:0px;padding:0px;">
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" valign="top">
<tr>
<td align="right">Records Per Page:
<select name="pagesize" onChange="this.form.submit();">
<option value="0">--Select--</option>
<?php
foreach($_GLOBALS['pgsize_arr'] as $val) {
if(trim($pagesize)==trim($val)) {
echo '<option value="'.$val.'" selected>'.$val.'</option>';
}
else{
echo '<option value="'.$val.'">'.$val.'</option>';
}
}
?>
</select>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<hr size="2" width="99%" color="#DA251C">
<?php
$qry1= db_query("select * from $table_name where logo_image !=''");
$reccnt = NumRows($qry1);
$qry= db_query("select * from $table_name where logo_image!='' order by id desc limit $start, $pagesize");
echo pageNavigation($reccnt,$pagesize,$start);
print_message();
?>
<table width="99%" border="0" cellpadding="2" cellspacing="2" class="lightBorder table table-bordered table-hover">
<form action="" method="POST">
<?php
if($reccnt>0) {
?>
<thead>
<tr height="25" bgcolor="#EAEAEA">
<td width="10%" align="center"><strong>S.No.</strong></td>
<td width="20%" align="left"><strong>Name</strong></td>
<td width="40%" align="center"><strong>Image</strong></td>
<td width="15%" align="center"><strong>Order</strong></td>
<td width="15%" align="left"><strong>Options</strong></td>
</tr>
</thead>
<?php
$sl=$start+1;
while($arr=mysqli_fetch_array($qry)) {
// $arr=ms_htmlentities_decode($arr);
if($sl%2!=0) {
$color="#f9f9f9";
}
else{
$color="#f0f0f0";
}
?>
<tbody>
<tr bgcolor="<?=$color;?>">
<td align="center"><?=$sl;?></td>
<td align="left"><?=$arr['name'];?></td>
<td align="center">
<?php
if($arr['logo_image']!="") {
$filenm=SITE_DIR_PATH."/uploaded-files/client-image/".$arr['logo_image'];
if(file_exists($filenm)) {
$dimens=GetImageSize($filenm);
if($dimens[0]>130) {
$dimens[0]=$dimens[0]+50;
$dimens[1]=$dimens[1]+80;
}
else{
$dimens[0]=200;
$dimens[1]=200;
}
?>
<a href="javascript:void(0);" onClick="openwin('<?=SITE_ADMIN_URL;?>/popup_new.php?img=client-image/<?=$arr['logo_image'];?>', '<?=$dimens[0];?>', '<?=$dimens[1];?>')" class="linkgray fontbold"><strong>View <?=$record_type;?></strong></a>
<?php
}
}
else {
?>
<strong>No Image Uploaded</strong>
<?php
}
?>
</td>
<td align="center"><input name="order_<?=$arr['id'];?>" class="txtfieldadmin" type="text" size="2" value="<?=$arr['client_order'];?>"></td>
<td align="center"> <a href="<?=$script_name;?>?id=edit_record&start=<?=$start;?>&pagesize=<?=$pagesize?>&recordID=<?=$arr['id'];?>#bot"><img src="<?=SITE_ADMIN_URL?>/images/edit.gif" alt="Edit This <?=$record_type;?>" title="Edit This <?=$record_type;?>" border="0"></a> <a href="<?=$script_name;?>?id=delete_record&start=<?=$start;?>&pagesize=<?=$pagesize?>&recordID=<?=$arr['id'];?>" onClick="return confirm('Are you sure to delete this record...');"><img src="<?=SITE_ADMIN_URL?>/images/cancel.gif" alt="Delete This <?=$record_type;?>" border="0"></a></td>
</tr>
<?php
$sl++;
}?>
<?php }
else{
?>
<tr><td><b>No Record Found........</b></td></tr>
<?php
}
?>
</tbody>
</form>
</table><br />
<form name="bannerFrm" method=post action="" enctype="multipart/form-data" onSubmit="return validate('bannerFrm') && chk_valid_date();">
<?php
if($_GET['recordID']=="" || $id!="edit_record") {
?>
<h2 class="myTitle text-center">Add New <?=$record_type;?></h2>
<?php
}
else {
?>
<div class="text-left myTitle">Edit <?=$record_type;?></div>
<div class="text-right"><a href="<?=$script_name;?>" class="btn btn-primary text-light"><b>Add New <?=$record_type;?></b></a></div>
<?php
}
$res=getResult($table_name," where id='$_GET[recordID]'");
?>
<div class="form-group">
<label>Clients Logo Image <span>*</span></label>
<?php
if($res['logo_image']!="") {
?>
<input name="collar" type="file" size="40" class="form-control">
<?php
$banner=site_url."/uploaded-files/client-image/".$res['logo_image'];
if(file_exists($banner)) {
$dimens=GetImageSize($banner);
if($dimens[0]>130) {
$dimens[0]=$dimens[0]+50;
$dimens[1]=$dimens[1]+80;
}
else{
$dimens[0]=200;
$dimens[1]=200;
}
echo " <a href=\"javascript:void(0);\" onClick=\"openwin('".SITE_ADMIN_URL."/popup_new.php?img=client-image/".$res[logo_image]."', '$dimens[0]', '$dimens[1]')\" class=\"linkgray fontbold\"><b>View Image</b></a>";
}
}
else {
?>
<input name="collar" type="file" size="40" class="form-control" id="NOBLANK~Please upload image.~DM~">
<?php
}
?>
</div>
<div class="form-group">
<label>Name <span>*</span></label>
<input type="text" name="title" size="60" value="<?=$res['name'];?>" class="form-control" />
</div>
<div class="form-group"><?php
if($recordID !="") {
?>
<input type="submit" name="submit" value="Update <?=$record_type;?>" class="btn btn-success">
<input type="hidden" name="recordID" value="<?=$res['id'];?>">
<input type="hidden" name="id" value="update_record">
<?php
}
else{
?>
<input type="submit" name="submit" value="Add New <?=$record_type;?>" class="btn btn-success">
<input type="hidden" name="id" value="add_record">
<?php
}
?>
<input type="hidden" name="start" value="<?=$start;?>">
<input type="hidden" name="pagesize" value="<?=$pagesize;?>">
</div>
</form>
<script src="jquery.min.js"></script>
<script type="text/javascript">
$("#quickCity").change(function(){
var cityid = $('#quickCity').val();
$.ajax({
url: "ajax99.php", //The url where the server req would we made.
async: false,
type: "POST", //The type which you want to use: GET/POST
data: "cityid="+cityid, //The variables which are going.
dataType: "html", //Return data type (what we expect).
//This is the function which will be called if ajax call is successful.
success: function(data) {
//data is the html of the page where the request is made.
$('#locatity').html(data);
}
})
});
</script>
<iframe width=174 height=189 name="gToday:normal:agenda.js" id="gToday:normal:agenda.js" src="<?=site_url;?>/js/calendar/themes/Normal/ipopeng.htm" scrolling="no" frameborder="0" style="visibility:visible; z-index:999; position:absolute; top:-500px; left:-500px;">
</iframe>
<?php
admin_footer();
exit;
?>