| Server IP : 104.21.37.246 / Your IP : 104.23.243.32 [ 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 : /home2/cp648411/public_html/ilawasia.onnud20.com/class_old/ |
Upload File : |
<?php
/**
*
*/
class CustomerClass extends ViewData
{
public function Index($request)
{
$name_table = "t_names_mas";
$count = "";
$search = "Deleted = 0";
$order = '';
if($request['OrderDirection']!=''){
$order = " Order By ".$request['OrderBy'] ." ".$request['OrderDirection'];
}
if($request['CustomerId']!=''){
$search = $search." AND NamesId = '".$request['CustomerId']."'";
}
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search);
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;$data=array();
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['NamesName'] =$row['NamesName'];
$data['Data'][$i]['NamesCode'] =$row['NamesCode'];
$data['Data'][$i]['NamesId'] =$row['NamesId'];
$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 LoadCustomer($request)
{
$name_table = "t_names_mas T2";
$count = "distinct T2.NamesId as custId,T2.NamesName as custName, T2.NamesCode as custCode,T2.PostalAddress as address,T2.TaxID as taxId";
$search = "1=1 AND Deleted = 0";
$order = '';
if($request['CustomerCode']!=''){
$cusCode = $request['CustomerCode'];
$search = $search." AND T2.NamesCode LIKE '%".$cusCode."%'";
}
if($request['CustomerName']!=''){
$cusName = $request['CustomerName'];
$search = $search." AND T2.NamesName LIKE '%".$cusName."%'";
}
if(intval($request['CustomerId'])>0){
$cusId = $request['CustomerId'];
$search = $search." AND T2.NamesId = '".$cusId."'";
}
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search);
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;$data=array();
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['custId'] =$row['custId'];
$data['Data'][$i]['custName'] =$row['custName'];
$data['Data'][$i]['custCode'] =$row['custCode'];
$data['Data'][$i]['address'] =$row['address'];
$data['Data'][$i]['taxId'] =$row['taxId'];
$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 LoadCustomerAutoComplete($Keyword)
{
$name_table = "t_names_mas";
$start_count = 0;
$max_rows = 10;
$secrch = "NamesCode Like '%".$Keyword."%' || NamesName Like '%".$Keyword."%' AND Deleted = 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)) {
$data[$i]['custId'] =$row['NamesId'];
$data[$i]['custCode'] =$row['NamesCode'];
$data[$i]['custName'] =$row['NamesName'];
$i++;
}
$data['sql'] = $view;
return $data;
}
public function LoadCustomerDetail($id)
{
$name_table = "t_names_mas T2";
$count = "distinct T2.NamesId as custId,T2.NamesName as custName, T2.NamesCode as custCode,T2.PostalAddress as address,T2.TaxID as taxId";
$secrch = "1=1 AND T2.NamesId = '".$id."'";
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$secrch);
$view = $this->view($sql);
$result = $this->q_re($view);
$num = $this->q_nr($result);
$data[0]['num'] =$num;
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$data[$i]['custId'] =$row['custId'];
$data[$i]['custCode'] =$row['custCode'];
$data[$i]['custName'] =$row['custName'];
$data[$i]['address'] =$row['address'];
$data[$i]['sql'] =$view;
$i++;
}
return $data;
}
public function LoadCustomerDetailAll($id)
{
$name_table = "t_names_mas T2";
$count = "distinct T2.NamesId as custId,T2.NamesName as custName, T2.NamesCode as custCode,T2.PostalAddress as address,T2.TaxID as taxId";
$secrch = "1=1 AND T2.NamesId = '".$id."'";
$sql = array('table'=>$name_table,'where'=>$secrch);
$view = $this->view($sql);
$result = $this->q_re($view);
$num = $this->q_nr($result);
$data[0]['num'] =$num;
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$data[$i]['NamesId'] =$row['NamesId'];
$data[$i]['NamesName'] =$row['NamesName'];
$data[$i]['NamesCode'] =$row['NamesCode'];
$data[$i]['Telephone'] =$row['Telephone'];
$data[$i]['PostalAddress'] =$row['PostalAddress'];
$data[$i]['Fax'] =$row['Fax'];
$data[$i]['ElectronicMail'] =$row['ElectronicMail'];
$data[$i]['TaxID'] =$row['TaxID'];
$data[$i]['Remark'] =$row['Remark'];
$data[$i]['Initial'] =$row['Initial'];
$data[$i]['StatusActive'] =$row['StatusActive'];
$data[$i]['CreateBy'] =$row['CreateBy'];
$data[$i]['LastUpdateBy'] =$row['LastUpdateBy'];
$data[$i]['CreateDateTime'] =$row['CreateDateTime'];
$data[$i]['LastUpdateDateTime'] =$row['LastUpdateDateTime'];
$data[$i]['Deleted'] =$row['Deleted'];
$i++;
}
return $data;
}
public function LoadRelatedCase($request)
{
$name_table = "ct_case c";
$count = "c.CaseId,c.CaseNumber,'' as DueDate";
$count .= " ,(SELECT CaseTypeName FROM ct_master_case_type WHERE CaseTypeId = c.CaseTypeId) as CaseType";
$count .= " ,(SELECT NamesName FROM t_names_mas WHERE NamesId = c.CustomerId) as CustomerName";
$count .= " ,'' as LastEvent";
$search = " 1=1 AND c.CustomerId = '".@$request['CustomerId']."'";
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search);
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;$data=array();
if($respons_count_num > 0){
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['CaseId'] =$row['CaseId'];
$data['Data'][$i]['CaseNumber'] =$row['CaseNumber'];
$data['Data'][$i]['DueDate'] =$row['DueDate'];
$data['Data'][$i]['CaseType'] =$row['CaseType'];
$data['Data'][$i]['CustomerName'] =$row['CustomerName'];
$data['Data'][$i]['LastEvent'] =$row['LastEvent'];
$data['Data'][$i]['data'] =$row;
$i++;
}
}else{
$data['Data'] = '';
}
$data['sql'] = $view;
$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;
return $data;
}
public function ExportToExcel($request)
{
$name_table = "t_names_mas ";
$search = " Deleted != '1'";
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search);
$view = $this->view($sql);
$result = $this->q_re($view);
$respons_count_num = mysqli_num_rows($result);
$i=0;$data=array();
if($respons_count_num > 0){
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['NamesCode'] =$row['NamesCode'];
$data['Data'][$i]['NamesName'] =$row['NamesName'];
$data['Data'][$i]['PostalAddress'] =$row['PostalAddress'];
$data['Data'][$i]['Telephone'] =$row['Telephone'];
$data['Data'][$i]['Fax'] =$row['Fax'];
$data['Data'][$i]['ElectronicMail'] =$row['ElectronicMail'];
$data['Data'][$i]['TaxID'] =$row['TaxID'];
$data['Data'][$i]['Remark'] =$row['Remark'];
$data['Data'][$i]['Initial'] =$row['Initial'];
$i++;
}
}else{
$data['Data'] = '';
}
$data['sql'] = $view;
return $data;
}
}
?>