| Server IP : 172.67.216.113 / Your IP : 104.23.243.33 [ Web Server : Apache System : Linux cpanel01wh.bkk1.cloud.z.com 2.6.32-954.3.5.lve1.4.59.el6.x86_64 #1 SMP Thu Dec 6 05:11:00 EST 2018 x86_64 User : cp648411 ( 1354) PHP Version : 7.2.34 Disable Function : NONE Domains : 0 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/cp648411/public_html/ilawasia.onnud20.com/class/ |
Upload File : |
<?php
/**
*
*/
class ManageUserClass extends ViewData
{
public function Index($request)
{
$Sorting = (@$request['Sorting']=='')?"CreatedAt":@$request['Sorting'];
$Email = @$request['Email'];
$Name = @$request['Name'];
$name_table = "t_system_users";
$count = "";
$search = "IsDeleted=0";
$order = '';
if(@$searchCaseName !=''){
$search = $search." AND EmailAddress LIKE '%".$Email."%'";
}
if(@$Name !=''){
$search = $search." AND Name = '".$Name."' OR Surname = '".$Name."' OR UserName = '".$Name."'";
}
if($request['OrderDirection']!=""){
$order = " ORDER BY ".$request['OrderBy']." ".$request['OrderDirection'];
}
$sql = array('table'=>$name_table,'where'=>$search,'order'=>$order);
if($request['PageSize']!=''){
$page_number = $request['PageNumber'] - 1;
$max_rows = $request['PageSize'];
$list_count = array('table'=>$name_table,'count'=>$count,'where'=>$search); //,'order' => 'ORDER BY `QuotationId` DESC '
$start_count = $page_number * $max_rows;
$view_count = $this->view($list_count);
$result_count = $this->q_re($view_count);
$respons_count = $this->q_nr($result_count);
$respons_count_num = mysqli_num_rows($result_count);
$respons_pages = ceil($respons_count/$max_rows)-1;
$data_c['page_number'] = $page_number;
$data_c['respons_pages'] = $respons_pages;
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search, 'limit'=> "$start_count,$max_rows",'order'=> $order);
}
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['CreationTime'] = $row['CreationTime'];
$data['Data'][$i]['CreatorUserId'] = $row['CreatorUserId'];
$data['Data'][$i]['EmailAddress'] = $row['EmailAddress'];
$data['Data'][$i]['Id'] = $row['Id'];
$data['Data'][$i]['IsDeleted'] = $row['IsDeleted'];
$data['Data'][$i]['LastUpdateBy'] = $row['LastUpdateBy'];
$data['Data'][$i]['LastUpdateDateTime'] = $row['LastUpdateDateTime'];
$data['Data'][$i]['MiddleName'] = $row['MiddleName'];
$data['Data'][$i]['Name'] = $row['Name'];
$data['Data'][$i]['StatusActive'] = $row['StatusActive'];
$data['Data'][$i]['Surname'] = $row['Surname'];
$data['Data'][$i]['Title'] = $row['Title'];
$data['Data'][$i]['UserName'] = $row['UserName'];
$i++;
}
$data['PageNumber'] = $request['PageNumber'];
$data['OrderBy'] = $request['OrderBy'];
$data['OrderDirection'] = $request['OrderDirection'];
$data['PageSize'] = $request['PageSize'];
$data['numrows'] = @$respons_count_num;
$data['TotalRecords'] = @$respons_count_num;
//$data['sql'] = @$view;
return $data;
}
public function LoadRole($userId)
{
$name_table = "ct_role";
$count = "";
$search = "Del='0'";
$order = "";
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search,'order'=> $order);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['RoleId'] = $row['RoleId'];
$data['Data'][$i]['Name'] = $row['Name'];
$i++;
}
//$data['sql'] = $view;
return $data;
}
public function LoadRoleUser($userId)
{
$name_table = "ct_role_user";
$count = "";
$search = "UserId='".@$userId."'";
$order = "";
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search,'order'=> $order);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['RoleId'] = $row['RoleId'];
$data['Data'][$i]['UserId'] = $row['UserId'];
$i++;
}
//$data['sql'] = $view;
return $data;
}
public function Edit($Id)
{
$name_table = "t_system_users";
$count = "";
$search = "Id='".@$Id."'";
$order = "";
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search,'order'=> $order);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['CreationTime'] = $row['CreationTime'];
$data['Data'][$i]['CreatorUserId'] = $row['CreatorUserId'];
$data['Data'][$i]['EmailAddress'] = $row['EmailAddress'];
$data['Data'][$i]['Id'] = $row['Id'];
$data['Data'][$i]['IsDeleted'] = $row['IsDeleted'];
$data['Data'][$i]['LastUpdateBy'] = $row['LastUpdateBy'];
$data['Data'][$i]['LastUpdateDateTime'] = $row['LastUpdateDateTime'];
$data['Data'][$i]['MiddleName'] = $row['MiddleName'];
$data['Data'][$i]['Name'] = $row['Name'];
$data['Data'][$i]['SupervisingId'] = $row['SupervisingId'];
$data['Data'][$i]['AssigneeId'] = $row['AssigneeId'];
$data['Data'][$i]['StatusActive'] = $row['StatusActive'];
$data['Data'][$i]['Surname'] = $row['Surname'];
$data['Data'][$i]['Title'] = $row['Title'];
$data['Data'][$i]['UserName'] = $row['UserName'];
$i++;
}
$sql = array('table'=>'ct_role_user','where'=>"UserId='".@$Id."'");
$view = $this->view($sql);
$result = $this->q_re($view);
$i2=1;
$i3=0;
while ($row = $this->q_ro($result)) {
$set[$i2] = $row['RoleId'];
//$data['Data'][0]['RoleId'][$i3] = (array_search($i2,$set)>0)?$set[array_search($i2,$set)]:'';
$i2++;
$i3++;
}
/*
*/
$data['Data'][0]['RoleId'][0] = (array_search(1,$set)>0)?$set[array_search(1,$set)]:'';
$data['Data'][0]['RoleId'][1] = (array_search(2,$set)>0)?$set[array_search(2,$set)]:'';
$data['Data'][0]['RoleId'][2] = (array_search(3,$set)>0)?$set[array_search(3,$set)]:'';
$data['Data'][0]['RoleId'][3] = (array_search(4,$set)>0)?$set[array_search(4,$set)]:'';
$data['Data'][0]['RoleId'][4] = (array_search(5,$set)>0)?$set[array_search(5,$set)]:'';
$data['Data'][0]['RoleId'][5] = (array_search(6,$set)>0)?$set[array_search(6,$set)]:'';
$data['Data'][0]['RoleId_set'] = $set;
//$data['sql'] = $view;
return $data;
}
public function LoadLanguagebilling()
{
$data['Data'] = array();
$order = '';
$count = "";
$name_table = "t_billing_currency_mas";
$search = "StatusActive = 1 AND Deleted = 0";
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search,'order'=>$order);
$view = $this->view($sql);
$result = $this->q_re($view);
$result_num = $this->q_nr($result);
$i=0;
if(@$result_num > 0){
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['BillingCurrencyId'] =$row['BillingCurrencyId'];
$data['Data'][$i]['BillingCurrencyCode'] =$row['BillingCurrencyCode'];
$data['Data'][$i]['BillingCurrencyName'] =$row['BillingCurrencyName'];
$data['Data'][$i]['StatusActive'] =$row['StatusActive'];
$data['Data'][$i]['CreateBy'] =$row['CreateBy'];
$data['Data'][$i]['LastUpdateBy'] =$row['LastUpdateBy'];
$data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];
$data['Data'][$i]['LastUpdateDateTime'] =$row['LastUpdateDateTime'];
$data['Data'][$i]['Deleted'] =$row['Deleted'];
$i++;
}
}
//$data['sql'] = $view;
return $data;
}
public function LoadOA($Id)
{
$data['Data'] = array();
$order = '';
$count = "";
$name_table = "ct_oattorney";
$search = "UserId = '".@$Id."'";
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search,'order'=>$order);
$view = $this->view($sql);
$result = $this->q_re($view);
$result_num = $this->q_nr($result);
$i=0;
if(@$result_num > 0){
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['UserId'] =$row['UserId'];
$data['Data'][$i]['HourlyRate'] =$row['HourlyRate'];
$data['Data'][$i]['Currency'] =$row['Currency'];
$data['Data'][$i]['CreateBy'] =$row['CreateBy'];
$data['Data'][$i]['LastUpdateBy'] =$row['LastUpdateBy'];
$data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];
$data['Data'][$i]['LastUpdateDateTime'] =$row['LastUpdateDateTime'];
$i++;
}
}
//$data['sql'] = $view;
return $data;
}
public function LoadSupervising($Id)
{
$data['Data'] = array();
$order = '';
$count = "";
$name_table = "ct_supervising";
$search = "Status = '1' AND Del = '0'";
if($Id!=''){
$search = $search." AND Id = '".$Id."'";
}
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search,'order'=>$order);
$view = $this->view($sql);
$result = $this->q_re($view);
$result_num = $this->q_nr($result);
$i=0;
if(@$result_num > 0){
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['Id'] =$row['Id'];
$data['Data'][$i]['Name'] =$row['Name'];
$data['Data'][$i]['HourlyRateTHB'] =$row['HourlyRateTHB'];
$data['Data'][$i]['HourlyRateUSD'] =$row['HourlyRateUSD'];
$data['Data'][$i]['CreateBy'] =$row['CreateBy'];
$data['Data'][$i]['LastUpdateBy'] =$row['LastUpdateBy'];
$data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];
$data['Data'][$i]['LastUpdateDateTime'] =$row['LastUpdateDateTime'];
$i++;
}
}
//$data['sql'] = $view;
return $data;
}
public function LoadAssignee($Id)
{
$data['Data'] = array();
$order = '';
$count = "";
$name_table = "ct_assignee";
$search = "Status = '1' AND Del = '0'";
if($Id!=''){
$search = $search." AND Id = '".$Id."'";
}
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search,'order'=>$order);
$view = $this->view($sql);
$result = $this->q_re($view);
$result_num = $this->q_nr($result);
$i=0;
if(@$result_num > 0){
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['Id'] =$row['Id'];
$data['Data'][$i]['Name'] =$row['Name'];
$data['Data'][$i]['HourlyRateTHB'] =$row['HourlyRateTHB'];
$data['Data'][$i]['HourlyRateUSD'] =$row['HourlyRateUSD'];
$data['Data'][$i]['CreateBy'] =$row['CreateBy'];
$data['Data'][$i]['LastUpdateBy'] =$row['LastUpdateBy'];
$data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];
$data['Data'][$i]['LastUpdateDateTime'] =$row['LastUpdateDateTime'];
$i++;
}
}
//$data['sql'] = $view;
return $data;
}
public function LoadRoleUserId($Id)
{
$name_table = "ct_role_user";
$count = "";
$search = "RoleId='6'";
if(@$Id != ''){
$search = $search. "AND UserId='".$Id."'";
}
$order = "";
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search,'order'=> $order);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['RoleId'] = $row['RoleId'];
$data['Data'][$i]['UserId'] = $row['UserId'];
$sql = array('table'=>'t_system_users','where'=>"Id='".@$row['UserId']."'");
$view = $this->view($sql);
$row2 = $this->q($view);
$data['Data'][$i]['CreationTime'] = $row2['CreationTime'];
$data['Data'][$i]['CreatorUserId'] = $row2['CreatorUserId'];
$data['Data'][$i]['EmailAddress'] = $row2['EmailAddress'];
$data['Data'][$i]['IsDeleted'] = $row2['IsDeleted'];
$data['Data'][$i]['LastUpdateBy'] = $row2['LastUpdateBy'];
$data['Data'][$i]['LastUpdateDateTime'] = $row2['LastUpdateDateTime'];
$data['Data'][$i]['MiddleName'] = $row2['MiddleName'];
$data['Data'][$i]['Name'] = $row2['Name'];
$data['Data'][$i]['HourlyRate'] = $row2['HourlyRate'];
$data['Data'][$i]['Currency'] = $row2['Currency'];
$data['Data'][$i]['StatusActive'] = $row2['StatusActive'];
$data['Data'][$i]['Surname'] = $row2['Surname'];
$data['Data'][$i]['Title'] = $row2['Title'];
$data['Data'][$i]['UserName'] = $row2['UserName'];
$i++;
}
//$data['sql'] = $view;
return $data;
}
public function LoadRoleUserFillter()
{
$name_table = "ct_role_user";
$count = "";
$search = "RoleId='6'";
if(@$Id != ''){
$search = $search. "AND UserId='".$Id."'";
}
$order = "";
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search,'order'=> $order);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['RoleId'] = $row['RoleId'];
$data['Data'][$i]['UserId'] = $row['UserId'];
$sql = array('table'=>'t_system_users','where'=>"Id='".@$row['UserId']."'");
$view = $this->view($sql);
$row2 = $this->q($view);
$data['Data'][$i]['CreationTime'] = $row2['CreationTime'];
$data['Data'][$i]['CreatorUserId'] = $row2['CreatorUserId'];
$data['Data'][$i]['EmailAddress'] = $row2['EmailAddress'];
$data['Data'][$i]['IsDeleted'] = $row2['IsDeleted'];
$data['Data'][$i]['LastUpdateBy'] = $row2['LastUpdateBy'];
$data['Data'][$i]['LastUpdateDateTime'] = $row2['LastUpdateDateTime'];
$data['Data'][$i]['MiddleName'] = $row2['MiddleName'];
$data['Data'][$i]['Name'] = $row2['Name'];
$data['Data'][$i]['HourlyRate'] = @$row2['HourlyRate'];
$data['Data'][$i]['Currency'] = @$row2['Currency'];
$data['Data'][$i]['StatusActive'] = $row2['StatusActive'];
$data['Data'][$i]['Surname'] = $row2['Surname'];
$data['Data'][$i]['Title'] = $row2['Title'];
$data['Data'][$i]['UserName'] = $row2['UserName'];
$i++;
}
//$data['sql'] = $view;
return $data;
}
public function LoadUserAutoCompleteRate($Keyword)
{
$name_table = "t_system_users";
$start_count = 0;
$max_rows = 10;
$secrch = "(Name Like '%".$Keyword."%' OR Surname Like '%".$Keyword."%') AND IsDeleted = '0'";
$count ='';
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$secrch, 'limit'=> "$start_count,$max_rows");
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$supervisingId = $this->LoadSupervising($row['SupervisingId']);
$assigneeId = $this->LoadAssignee($row['AssigneeId']);
$s_THB = $supervisingId['Data'][$i]['HourlyRateTHB'];
$s_USD = $supervisingId['Data'][$i]['HourlyRateUSD'];
$a_THB = $assigneeId['Data'][$i]['HourlyRateTHB'];
$a_USD = $assigneeId['Data'][$i]['HourlyRateUSD'];
$data[$i]['Id'] =$row['Id'];
$data[$i]['UserName'] =$row['UserName'];
$data[$i]['Name'] =$row['Name'];
$data[$i]['SurName'] =$row['Surname'];
$data[$i]['SupervisingTHB'] = $supervisingId['Data'][$i]['HourlyRateTHB'];
$data[$i]['SupervisingUSD'] = $supervisingId['Data'][$i]['HourlyRateUSD'];
$data[$i]['Supervisingtxt'] = '( Hourly Rate '.$s_THB.' THB , Hourly Rate '. $s_USD.' USD )';
$data[$i]['AssigneeTHB'] = $AssigneeId['Data'][$i]['HourlyRateTHB'];
$data[$i]['AssigneeUSD'] = $AssigneeId['Data'][$i]['HourlyRateUSD'];
$data[$i]['Assigneetxt'] = '( Hourly Rate '.$a_THB.' THB , Hourly Rate '. $a_USD.' USD )';
$i++;
}
//$data['sql'] = $view;
return $data;
}
public function LoadUserId($Id)
{
$name_table = "t_system_users";
$secrch = "Id = '".$Id."' AND IsDeleted = '0'";
$count ='';
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$secrch);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$supervisingId = $this->LoadSupervising($row['SupervisingId']);
$assigneeId = $this->LoadAssignee($row['AssigneeId']);
$s_THB = $supervisingId['Data'][$i]['HourlyRateTHB'];
$s_USD = $supervisingId['Data'][$i]['HourlyRateUSD'];
$s_Name = $supervisingId['Data'][$i]['Name'];
$a_THB = $assigneeId['Data'][$i]['HourlyRateTHB'];
$a_USD = $assigneeId['Data'][$i]['HourlyRateUSD'];
$a_Name = $assigneeId['Data'][$i]['Name'];
$data[$i]['Id'] =$row['Id'];
$data[$i]['UserName'] =$row['UserName'];
$data[$i]['Name'] =$row['Name'];
$data[$i]['SurName'] =$row['SurName'];
$data[$i]['SupervisingId'] = $row['SupervisingId'];
$data[$i]['SupervisingName'] = $s_Name;
$data[$i]['SupervisingTHB'] = $s_THB;
$data[$i]['SupervisingUSD'] = $s_USD;
$data[$i]['Supervisingtxt'] = '( Hourly Rate '.$s_THB.' THB , Hourly Rate '. $s_USD.' USD )';
$data[$i]['AssigneeId'] = $row['AssigneeId'];
$data[$i]['AssigneeName'] = $a_Name;
$data[$i]['AssigneeTHB'] = $a_THB;
$data[$i]['AssigneeUSD'] = $a_USD;
$data[$i]['Assigneetxt'] = '( Hourly Rate '.$a_THB.' THB , Hourly Rate '. $a_USD.' USD )';
$i++;
}
//$data['sql'] = $view;
return $data;
}
public function LoadUserAll()
{
$name_table = "t_system_users";
$start_count = 0;
$max_rows = 10;
$secrch = "IsDeleted = 0";
$count ='';
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$secrch);//, 'limit'=> "$start_count,$max_rows"
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$supervisingId = $this->LoadSupervising($row['SupervisingId']);
$assigneeId = $this->LoadAssignee($row['AssigneeId']);
$s_THB = @$supervisingId['Data'][$i]['HourlyRateTHB'];
$s_USD = @$supervisingId['Data'][$i]['HourlyRateUSD'];
$a_THB = @$assigneeId['Data'][$i]['HourlyRateTHB'];
$a_USD = @$assigneeId['Data'][$i]['HourlyRateUSD'];
$data['Data'][$i]['Id'] =$row['Id'];
$data['Data'][$i]['UserName'] =$row['UserName'];
$data['Data'][$i]['Name'] =$row['Name'];
$data['Data'][$i]['SurName'] =$row['Surname'];
$data['Data'][$i]['SupervisingTHB'] = @$supervisingId['Data'][$i]['HourlyRateTHB'];
$data['Data'][$i]['SupervisingUSD'] = @$supervisingId['Data'][$i]['HourlyRateUSD'];
$data['Data'][$i]['Supervisingtxt'] = '( Hourly Rate '.$s_THB.' THB , Hourly Rate '. $s_USD.' USD )';
$data['Data'][$i]['AssigneeTHB'] = @$AssigneeId['Data'][$i]['HourlyRateTHB'];
$data['Data'][$i]['AssigneeUSD'] = @$AssigneeId['Data'][$i]['HourlyRateUSD'];
$data['Data'][$i]['Assigneetxt'] = '( Hourly Rate '.$a_THB.' THB , Hourly Rate '. $a_USD.' USD )';
$i++;
}
//$data['sql'] = $view;
return $data;
}
public function loadCommission($Id)
{
$name_table = "ct_quotation_assignee";
$start_count = 0;
$secrch = "AssigneeId = '".$Id."'";
$count ='';
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$secrch);//, 'limit'=> "$start_count,$max_rows"
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;
$data=array();
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['QuotationAssigneeId'] =$row['QuotationAssigneeId'];
$data['Data'][$i]['AssigneeId'] =$row['AssigneeId'];
$i++;
}
$name_table2 = "ct_quotation";
$start_count2 = 0;
$secrch2 = "SupervisingId = '".$Id."'";
$count2 ='';
$sql2 = array('table'=>$name_table2, 'count'=>$count2,'where'=>$secrch2);//, 'limit'=> "$start_count,$max_rows"
$view2 = $this->view($sql2);
$result2 = $this->q_re($view2);
while ($row2 = $this->q_ro($result2)) {
$data['Data'][$i]['row'] =$row2;
$i++;
}
//$data['sql'] = $view;
return $data;
}
public function loadCommissionAss($Id)
{
$name_table = "ct_quotation_assignee";
$start_count = 0;
$secrch = "AssigneeId = '".$Id."'";
$count ='';
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$secrch);//, 'limit'=> "$start_count,$max_rows"
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;
$data=array();
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['QuotationAssigneeId'] =$row['QuotationAssigneeId'];
$data['Data'][$i]['AssigneeId'] =$row['AssigneeId'];
$i++;
}
}
public function loadCommissionSup($Id)
{
$name_table2 = "ct_quotation";
$start_count2 = 0;
$secrch2 = "SupervisingId = '".$Id."'";
$count2 ='';
$sql2 = array('table'=>$name_table2, 'count'=>$count2,'where'=>$secrch2);//, 'limit'=> "$start_count,$max_rows"
$view2 = $this->view($sql2);
$result2 = $this->q_re($view2);
while ($row2 = $this->q_ro($result2)) {
$data['Data'][$i]['row'] =$row2;
$i++;
}
//$data['sql'] = $view;
return $data;
}
}
?>