';
$out .='';
while($result=mysql_fetch_array($res))
{
$out .='';
}
$out .= '';
echo $out;
}break;
case'GeneralDetails':
{
//print_r($_REQUEST);
$searchtext = mysql_real_escape_string($_REQUEST['searchtext']);
//$prtstatus = $_REQUEST['status'];
//$prtcat = $_REQUEST['instructions'];
$searchtext = trim($searchtext);
$where = '';
$fields = array('name','email','p.admin_type','designation_employee','email_designation');
if(!empty($searchtext))
{
foreach($fields as $field)
{
if($where=="")
$where = ' AND ( ';
else
$where .= ' OR ';
$where .= $field." LIKE '%".$searchtext."%' ";
}
$where .=')';
}
/*if($_REQUEST['s_mtype']<>"")
{
$where .= " and mtype='".$_REQUEST['s_mtype']."'";
}
if($_REQUEST['s_team']<>"")
{
$where .= " and team='".$_REQUEST['s_mtype']."'";
}
if($_REQUEST['s_se']>0)
{
$where .= " and sale_employee_code<=0 ";
}
if($_REQUEST['s_sale_employee_code']>0)
{
$where .= " and sale_employee_code='".$_REQUEST['s_sale_employee_code']."'";
}
if($_REQUEST['s_status_c']>0)
{
$where .= " and customer_calling_status='".$_REQUEST['s_status_c']."'";
}
if($_REQUEST['s_sms']<>"")
{
$where .= " and sms='".$_REQUEST['s_sms']."'";
}
*/
$q = "SELECT a.*,p.admin_type,if(a.is_sale=1,u.name,'') as report_name,l.name as location_name, branch.name as branch_name FROM ".TABLE_NAME." a
LEFT JOIN admin_user_type p ON a.user_type=p.admin_code
LEFT JOIN store_master l ON l.code=store_code
LEFT JOIN admin_users u ON a.designation_reporting=u.admin_id and u.is_sale=1
LEFT JOIN sale_employee_brm branch ON branch.code=u.branch
WHERE a.is_deleted=0 and a.panel_1=1 $where ";
//echo 'Query ===> '.$q;
$qr = mysql_query($q) or die('Error: '.mysql_error());
?>
| Emp Code |
Name |
Username |
Email |
Store |
Branch |
Mobile |
Designation |
Reporting To |
Role |
Payment |
Status |
|
>
| JS 3 ? '0'.$i : strlen((string)$i) > 2 ? '00'.$i : strlen((string)$i) > 1 ? '000'.$i : '0000'.$i )?> |
|
|
|
|
|
|
|
|
|
|
Enalbed':'Disabled'; ?> |
|
Pagination Finish
}
break;
case 'add_edit':
{
$i =3;
$key = array_keys($_REQUEST);
$n = count($_REQUEST);
while($i<=($n))
{
$s = $s."&".$key[$i]."=".$_REQUEST[$key[$i]]."";
$i++;
}
require_once("index.class.php");
$objpl=new General();
$objpl->add_edit(fetch_details(TABLE_NAME,'admin_id',$_REQUEST['id']),$_REQUEST);
}
break;
case 'save_key':
{
$data=$_POST;
// echo '1|0|';
//print_r($data);echo '
';
if($data['is_sale']==1)
{
if($data['designation']<=0)
{
echo '1|0|Error : Please select Sale Designation!!';
return;
}
if($data['designation']>1 and $data['designation_reporting']<=0)
{
echo '1|0|Error : Please select Sale Reporting Person!!';
return;
}
}else{
$data['designation'] = 0;
$data['designation_reporting'] = '0';
}
if($data['is_panel_access']<=0)
$data['is_panel_access'] = 0;
if($data['is_sale']<=0)
$data['is_sale'] = 0;
if(!check_duplicate(TABLE_NAME,'name',trim($data['name']),$data['id'],'admin_id'," and is_deleted=0 and panel_1=1"))
{
echo '1|0|Error : User already exist with this Name!!';
return;
}
if(!check_duplicate(TABLE_NAME,'email',trim($data['email']),$data['id'],'admin_id'," and is_deleted=0 and panel_1=1"))
{
echo '1|0|Error : Username already exist!!';
return;
}
if(!check_duplicate(TABLE_NAME,'email_address',trim($data['email_address']),$data['id'],'admin_id'," and is_deleted=0 and panel_1=1"))
{
echo '1|0|Error : Email Address already exist!!';
return;
}
$n = count($data);
$i = 1;
$key = array_keys($data);
$data['dob'] = date("Y-m-d",strtotime($data['dob']));
$data['doj'] = date("Y-m-d",strtotime($data['doj']));
$j=1;
while($i<=($n))
{
if($key[$i]<>"id" AND $key[$i]<>"photoimg" AND $key[$i]<>"id" AND $key[$i]<>"upload_pic" AND $key[$i]<>"task2" AND $key[$i]<>"task_n" AND $key[$i]<>"task" AND $key[$i]<>"picture" AND $key[$i]<>"status" AND $key[$i]<>"" AND $key[$i]<>"code" AND $key[$i]<>"group_specification" AND $key[$i]<>"menu_category" AND substr($key[$i],0,5)<>"cat__" AND substr($key[$i],0,4)<>"mce_")
{
if($j==1)
{ $s = " SET $key[$i] = '".trim($data[$key[$i]])."' ";
$j=2;
}
else
$s = $s.",$key[$i] = '".mysql_real_escape_string(trim($data[$key[$i]]))."' ";
}
$i++;
}
$s = $s." , panel_1='1' ";
if($data['task2']=="Add")
{
// $s = $s.",sort_id = '".(find_sort_id_max_gn("customers")+10)."' ";
//$data['password'] = md5('123456');
$s = "INSERT INTO ".TABLE_NAME." ".$s;
$cccode = md5("XX".time()."XX");
$s .= ",password = ''";
$s .= ",department_code = '0'";
$s .= ",confirm_email ='".$cccode."'";
}else{
$s = "UPDATE ".TABLE_NAME." ".$s;
$s = $s." WHERE admin_id='".$data['id']."'";
}
//echo '1|0|Error : '.$s;
//print_r(mysql_query($s));
if(mysql_query($s))
{
if($data['id']>0)
$id = $data['id'];
else
$data['id'] = mysql_insert_id();;
$response = create_log(TABLE_NAME,$data,'admin_id');
/*if($data['picture']<>"")
{
$sql = "Select * from raw_pictures where code = '".$data['picture']."'";
$res = mysql_query($sql);
$rows = mysql_fetch_assoc($res);
$pic = $rows['image'];
$iid = $rows['code'];
copy('../ajaximage/uploads/'.$pic,'../../../ref_doc/'.$pic);
unlink('../ajaximage/uploads/'.$pic);
$sql33 = " Update ".TABLE_NAME." SET ref_doc='".$pic."' where code = '".$id."' ";
mysql_query($sql33);
//echo $sql33;
$sql = "Delete FROM raw_pictures where code = '".$iid."' or date <= '".date("Y-m-d",strtotime("-2 Days"))."'";
mysql_query($sql);
$new_col[] = 'ref_doc';
$new_val[] = $pic;
}*/
if($data['task2']=="Add")
{
$sql2 = "select * from admin_users where admin_id='".$data['id']."' ";
$r = mysql_query($sql2);
$row = mysql_fetch_assoc($r);
//echo '1|1|'.$sql2;
$a = SITE_PATH_ADMIN.'index.php?task=confirm_email&code='.$row['confirm_email'].'';
$sql = "select * from sms_template where template_for='Employee Email Verification' ";
$r = mysql_query($sql);
$ro_4 = mysql_fetch_assoc($r);
if($ro_4['code']>0)
{
$ro_4['template'] = str_replace("[EMAIL]",$row['email_address'],$ro_4['template']);
$ro_4['template'] = str_replace("[NAME]",$row['name'],$ro_4['template']);
$ro_4['template'] = str_replace("[MOBILE]",$row['mobile'],$ro_4['template']);
$ro_4['template'] = str_replace("[DESIGNATION]",$row['designation_employee'],$ro_4['template']);
$ro_4['template'] = str_replace("[EMAIL_VERIFICATION_LINK]",$a,$ro_4['template']);
sms_jshine($row['admin_id'],$row['mobile'],$ro_4['template'],1,$ro_4['sender_id']);
$sql = "select * from email_template where template_for='Employee Email Verification' ";
$r = mysql_query($sql);
$ro_4 = mysql_fetch_assoc($r);
if($ro_4['code']>0)
{
$ro_4['template'] = str_replace("[EMAIL]",$row['email_address'],$ro_4['template']);
$ro_4['template'] = str_replace("[NAME]",$row['name'],$ro_4['template']);
$ro_4['template'] = str_replace("[MOBILE]",$row['mobile'],$ro_4['template']);
$ro_4['template'] = str_replace("[DESIGNATION]",$row['designation_employee'],$ro_4['template']);
$ro_4['template'] = str_replace("[EMAIL_VERIFICATION_LINK]",$a,$ro_4['template']);
auto_email($ro_4['subject'],$row['email_address'],$ro_4['template'],$ro_4['email_from'],$row['admin_id']);
}
}
echo '1|1|Record Inserted successfully!!';
}else{
echo '1|1|Record Updated successfully!!';
}
}else{
echo '1|0|Error : in Updation!!';
}
}
break;
case 'delete_row':
{
//print_r($_REQUEST);
if($_REQUEST['id']>0)
{
//if(isdelete('admin_users',"user_type",$_REQUEST['id'],$where=' and is_deleted=0 '))
//{
$sql = "update ".TABLE_NAME." SET is_deleted=1 WHERE admin_id='".$_REQUEST['id']."' ";
if(mysql_query($sql))
{
create_log(TABLE_NAME,$_REQUEST,'admin_id');
echo '1|1|Record Deleted';
return true;
}
else
{ echo '0|0|Error : while deleting this record!!';
return true;
}
//}
}
echo '0|0|Error : Can\'t Delete record!!';
}
break;
};
}
?>