| Server IP : 172.67.216.113 / Your IP : 172.71.28.146 [ 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 NamesClass extends ViewData
{
public function LoadNames($request)
{
$name_table = "
t_names_mas tnm
INNER JOIN t_case_names_map tcnm ON tnm.NamesId=tcnm.NamesId
INNER JOIN t_names_type_mas tntm ON tcnm.NamesTypeId=tntm.NamesTypeId
";
// t_names_type_mas
$count = "
tnm.*, tcnm.CaseNameId,tcnm.CaseId, tcnm.NamesTypeId, tcnm.NamesId, tcnm.SeqNo, tcnm.Attention, tcnm.Reference,
tntm.NamesTypeName, tntm.SeqNo AS SeqNo_nametype
";
//$count = "trs.*, ts.UserName, ts.EmailAddress, ts.Title, ts.Name, ts.MiddleName, ts.Surname, tr.RoleName, tr.Remark ";
$search = "tnm.Deleted=0";
if(@$request['User']!=''){
$search = $search." AND tnm.UserName = '".@$request['User']."'";
}
if(@$request['Email']!=''){
$search = $search." AND tnm.EmailAddress = '".@$request['Email']."'";
}
if(@$request['Name']!=''){
$search = $search." AND tnm.Name = '".@$request['Name']."'";
}
if(@$request['Surname']!=''){
$search = $search." AND tnm.Surname = '".@$request['Surname']."'";
}
if(@$request['Role']!=''){
$search = $search." AND tnm.RoleId = '".@$request['Role']."'";
}
if(@$request['NamesId']!=''){
$search = $search." AND tnm.NamesId = '".@$request['NamesId']."'";
}
if(@$request['nameCodeText']!=''){
if(@$request['nameCode']==0){
$search = $search." AND `tnm`.`NamesCode` LIKE '".@$request['nameCodeText']."%'";
}
if(@$request['nameCode']==1){
$search = $search." AND RIGHT(`tnm`.`NamesCode`, 4) LIKE '%".@$request['nameCodeText']."'";
}
if(@$request['nameCode']==2){
$search = $search." AND `tnm`.`NamesCode` LIKE '%".@$request['nameCodeText']."%'";
}
if(@$request['nameCode']==3){
$search = $search." AND `tnm`.`NamesCode` NOT LIKE '%".@$request['nameCodeText']."%'";
}
if(@$request['nameCode']==4){
//$search = $search." AND `tnm`.`NamesCode` NOT LIKE '%".@$request['nameCodeText']."%'";
}
if(@$request['nameCode']==5){
//$search = $search." AND `tnm`.`NamesCode` NOT LIKE '%".@$request['nameCodeText']."%'";
}
}
if(@$request['nameText']!=''){
if(@$request['name']==0){
$search = $search." AND `tnm`.`NamesName` LIKE '".@$request['nameText']."%'";
}
if(@$request['name']==1){
$search = $search." AND RIGHT(`tnm`.`NamesName`, 4) LIKE '%".@$request['nameText']."'";
}
if(@$request['name']==2){
$search = $search." AND `tnm`.`NamesName` LIKE '%".@$request['nameText']."%'";
}
if(@$request['name']==3){
$search = $search." AND `tnm`.`NamesName` NOT LIKE '%".@$request['nameText']."%'";
}
if(@$request['name']==4){
//$search = $search." AND `tnm`.`NamesName` NOT LIKE '%".@$request['nameText']."%'";
}
if(@$request['name']==5){
//$search = $search." AND `tnm`.`NamesName` NOT LIKE '%".@$request['nameText']."%'";
}
}
if(@$request['addressText']!=''){
if(@$request['address']==0){
$search = $search." AND `tnm`.`PostalAddress` LIKE '".@$request['addressText']."%'";
}
if(@$request['address']==1){
$search = $search." AND RIGHT(`tnm`.`PostalAddress`, 4) LIKE '%".@$request['addressText']."'";
}
if(@$request['address']==2){
$search = $search." AND `tnm`.`PostalAddress` LIKE '%".@$request['addressText']."%'";
}
if(@$request['address']==3){
$search = $search." AND `tnm`.`PostalAddress` NOT LIKE '%".@$request['addressText']."%'";
}
if(@$request['address']==4){
//$search = $search." AND `tnm`.`PostalAddress` NOT LIKE '%".@$request['addressText']."%'";
}
if(@$request['address']==5){
//$search = $search." AND `tnm`.`PostalAddress` NOT LIKE '%".@$request['addressText']."%'";
}
}
if(@$request['dataNameType']!=''){
$search = $search." AND `tntm`.`NamesTypeName` = '".@$request['dataNameType']."%'";
}
$order = '';
if($request['OrderDirection']!=''){
$order = " Order By tnm.".$request['OrderBy'] ." ".$request['OrderDirection'];
}
$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>0){
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['log'] = $row;
$data['Data'][$i]['NamesId'] =$row['NamesId'];
$data['Data'][$i]['NamesName'] =$row['NamesName'];
$data['Data'][$i]['NamesCode'] =$row['NamesCode'];
$data['Data'][$i]['Telephone'] =$row['Telephone'];
$data['Data'][$i]['PostalAddress'] =$row['PostalAddress'];
$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'];
$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'];
$sql1 = array('table'=>'t_system_users','where'=>'Id = "'.$row['LastUpdateBy'].'"');
$view1 = $this->view($sql1);
$row1 = $this->q($view1);
$data['Data'][$i]['Name'] =$row1['Name'];
$data['Data'][$i]['Surname'] =$row1['Surname'];
$data['Data'][$i]['Namefull'] =$row1['Name'] ." ".$row1['Surname'];
$i++;
}
}else{
$data['Data'] = '';
}
$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 LoadAddressNames($request)
{
$count ="*";
$name_table = " t_names_address_dtl ";
$search = "NamesId = '".@$request['NamesId']."' AND Deleted = 0";
$order = " ORDER BY CreateDateTime DESC";
$order = '';
$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>0){
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['NamesAddressId'] =$row['NamesAddressId'];
$data['Data'][$i]['NamesId'] =$row['NamesId'];
$data['Data'][$i]['AddressType'] =$row['AddressType'];
$data['Data'][$i]['Address'] =$row['Address'];
$data['Data'][$i]['Telephone'] =$row['Telephone'];
$data['Data'][$i]['Fax'] =$row['Fax'];
$data['Data'][$i]['Remark'] =$row['Remark'];
$data['Data'][$i]['StatusActive'] =$row['StatusActive'];
$data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];
$data['Data'][$i]['LastUpdateDateTime'] =$row['LastUpdateDateTime'];
$data['Data'][$i]['Deleted'] =$row['Deleted'];
$sql1 = array('table'=>'t_system_users','where'=>'Id = "'.$row['LastUpdateBy'].'"');
$view1 = $this->view($sql1);
$row1 = $this->q($view1);
$data['Data'][$i]['LastUpdateBy'] =$row1['Name'] ." ".$row1['Surname'];
$sql2 = array('table'=>'t_system_users','where'=>'Id = "'.$row['CreateBy'].'"');
$view2 = $this->view($sql2);
$row2 = $this->q($view2);
$data['Data'][$i]['CreateBy'] =$row2['Name'] ." ".$row2['Surname'];
$i++;
}
}else{
$data['Data'] = '';
}
$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 LoadNamesId($request)
{
$count ="T.NamesId
,T.NamesName
,T.NamesCode
,T.Telephone
,T.PostalAddress
,T.Fax
,T.ElectronicMail
,T.TaxID
,T.Remark
,T.Initial
,T.StatusActive
,concat(u1.Name, ' ', concat(u1.MiddleName,' ',u1.Surname)) as CreateBy
,concat(u2.Name,' ', concat(u2.MiddleName,' ',u2.Surname)) as LastUpdateBy
,T.CreateDateTime as CreateDateTime
,T.LastUpdateDateTime as LastUpdateDateTime";
$name_table = " t_names_mas T
LEFT JOIN t_system_users u1 ON T.CreateBy=u1.Id
LEFT JOIN t_system_users u2 ON T.LastUpdateBy=u2.Id
";
$search = "T.Deleted = 0
AND T.StatusActive = 1
AND T.NamesId = '".@$request['NamesId']."'";
$order = " ORDER BY T.CreateDateTime DESC";
$order = '';
$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>0){
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['NamesId'] =$row['NamesId'];
$data['Data'][$i]['NamesName'] =$row['NamesName'];
$data['Data'][$i]['NamesCode'] =$row['NamesCode'];
$data['Data'][$i]['Telephone'] =$row['Telephone'];
$data['Data'][$i]['PostalAddress'] =$row['PostalAddress'];
$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'];
$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'];
$sql1 = array('table'=>'t_system_users','where'=>'Id = "'.$row['LastUpdateBy'].'"');
$view1 = $this->view($sql1);
$row1 = $this->q($view1);
$data['Data'][$i]['Name'] =$row1['Name'];
$data['Data'][$i]['Surname'] =$row1['Surname'];
$data['Data'][$i]['Namefull'] =$row1['Name'] ." ".$row1['Surname'];
$i++;
}
}else{
$data['Data'] = '';
}
$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 LoadNamesId2($request)
{
$count ="";
$name_table = " t_names_mas";
$search = "Deleted = 0 AND NamesId = '".@$request['NamesId']."'";
$order = '';
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search,'order'=>$order);
$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]['NamesId'] =$row['NamesId'];
$data['Data'][$i]['NamesName'] =$row['NamesName'];
$data['Data'][$i]['NamesCode'] =$row['NamesCode'];
$data['Data'][$i]['Telephone'] =$row['Telephone'];
$data['Data'][$i]['PostalAddress'] =$row['PostalAddress'];
$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'];
$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'];
$sql1 = array('table'=>'t_system_users','where'=>'Id = "'.$row['LastUpdateBy'].'"');
$view1 = $this->view($sql1);
$row1 = $this->q($view1);
$data['Data'][$i]['Name'] =$row1['Name'];
$data['Data'][$i]['Surname'] =$row1['Surname'];
$data['Data'][$i]['Namefull'] =$row1['Name'] ." ".$row1['Surname'];
$i++;
}
}else{
$data['Data'] = '';
}
$data['TotalRecords'] = @$respons_count;
$data['sql'] = @$view;
return $data;
}
public function LoadNamestypeSearch()
{
$count ="";
$name_table = "t_names_type_mas";
$search = "Deleted=0";
$order = "";
$sql = array('table'=>$name_table,'where'=>$search);
$view = $this->view($sql);
$result = $this->q_re($view);
$respons = $this->q_nr($result);
$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]['NamesTypeId'] =$row['NamesTypeId'];
$data['Data'][$i]['NamesTypeName'] =$row['NamesTypeName'];
$data['Data'][$i]['SeqNo'] =$row['SeqNo'];
$data['Data'][$i]['StatusActive'] =$row['StatusActive'];
$data['Data'][$i]['CreateBy'] =$row['CreateBy'];
$data['Data'][$i]['LastUpdateBy'] =$row['LastUpdateBy'];
$i++;
}
}else{
$data['Data'] = '';
}
$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['request'] = @$respons;
$data['sql'] = @$view;
return $data;
}
public function LoadNamestypeSearch2($request)
{
$count ="T.NamesId
,T.NamesName
,T.NamesCode
,T.Telephone
,T.PostalAddress
,T.Fax
,T.ElectronicMail
,T.TaxID
,T.Remark
,T.Initial
,T.StatusActive
,concat(u1.Name, ' ', concat(u1.MiddleName,' ',u1.Surname)) as CreateBy
,concat(u2.Name,' ', concat(u2.MiddleName,' ',u2.Surname)) as LastUpdateBy
,T.CreateDateTime as CreateDateTime
,T.LastUpdateDateTime as LastUpdateDateTime";
$name_table = " t_names_mas T
LEFT JOIN t_system_users u1 ON T.CreateBy=u1.Id
LEFT JOIN t_system_users u2 ON T.LastUpdateBy=u2.Id
";
$search = "T.Deleted = 0
AND T.StatusActive = 1
AND T.NamesName ". $nameTS_f ." LIKE '%".@$namename."%'
AND T.NamesCode ". $nameCodeTS_f ." LIKE '%".@$namecode."%'
AND T.Initial ". $initialTS_f ." LIKE '%".@$initial."%'
AND T.PostalAddress ". $addressTS_f ." LIKE '%".@$address."%'
";
$order = " ORDER BY T.CreateDateTime DESC";
$sql = array('table'=>$name_table,'where'=>$search,'count'=>$count,'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;$data=array();
if(@$respons_count_num > 0){
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['CreateBy'] =$row['CreateBy'];
$data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];
$data['Data'][$i]['ElectronicMail'] =$row['ElectronicMail'];
$data['Data'][$i]['Fax'] =$row['Fax'];
$data['Data'][$i]['Initial'] =$row['Initial'];
$data['Data'][$i]['LastUpdateBy'] =$row['LastUpdateBy'];
$data['Data'][$i]['LastUpdateDateTime'] =$row['LastUpdateDateTime'];
$data['Data'][$i]['NamesCode'] =$row['NamesCode'];
$data['Data'][$i]['NamesId'] =$row['NamesId'];
$data['Data'][$i]['NamesName'] =$row['NamesName'];
$data['Data'][$i]['PostalAddress'] =$row['PostalAddress'];
$data['Data'][$i]['Remark'] =$row['Remark'];
$data['Data'][$i]['StatusActive'] =$row['StatusActive'];
$data['Data'][$i]['TaxID'] =$row['TaxID'];
$data['Data'][$i]['Telephone'] =$row['Telephone'];
$i++;
}
}else{
$data['Data'] = '';
}
$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['request'] = @$respons;
$data['sql'] = @$view;
return $data;
}
public function NameService($request)
{
$nameTS = $request['name'];
$nameText = $request['nameText'];
$nameCodeTS = $request['nameCode'];
$nameCodeText = $request['nameCodeText'];
$initialTS = $request['initial'];
$initialText = $request['initialText'];
$addressTS = $request['address'];
$addressText = $request['addressText'];
$filesInTS = $request['dataFiilein'];
$country = @$request['country'];
$nameTypeTs = $request['dataNameType'];
$noOfCasesText = $request['noOfCasesText'];
$noofcase = $request['noOfCasesText'];
$count ="";
$name_table = "(
SELECT T.NamesId
,T.NamesName
,T.NamesCode
,T.Telephone
,T.PostalAddress
,T.Fax
,T.ElectronicMail
,T.TaxID
,T.Remark
,T.Initial
,(
SELECT count(CaseId)
FROM t_case_management_trn r
WHERE 1=1
";
if(intval($filesInTS) > 0 ){
$name_table = $name_table. " AND r.CountryId = '".@$country."'";
}
$name_table = $name_table . "
AND r.CaseId IN (
SELECT DISTINCT CaseId
FROM t_case_names_map T2
WHERE T.NamesId = T2.NamesId
AND T2.Deleted = 0
AND T2.StatusActive = 1 ";
if(intval($nameTypeTs) > 0 ){
$name_table = $name_table . " AND T2.NamesTypeId = '".@$nametype."'";
}
$nameTS_f = ($nameTS==3||$nameTS==5)?"not":"";
$nameCodeTS_f = ($nameCodeTS==3||$nameCodeTS==5)?"not":"";
$initialTS_f = ($initialTS==3||$initialTS==5)?"not":"";
$addressTS_f = ($addressTS==3||$addressTS==5)?"not":"";
$name_table = $name_table . " )
) AS NOOFCASE
,T.StatusActive
,concat(u1.Name, ' ', concat(u1.MiddleName,' ',u1.Surname)) as CreateBy
,concat(u2.Name,' ', concat(u2.MiddleName,' ',u2.Surname)) as LastUpdateBy
,T.CreateDateTime as CreateDateTime
,T.LastUpdateDateTime as LastUpdateDateTime
FROM t_names_mas T
LEFT JOIN t_system_users u1 ON T.CreateBy=u1.Id
LEFT JOIN t_system_users u2 ON T.LastUpdateBy=u2.Id
WHERE T.Deleted = 0
AND T.StatusActive = 1
AND T.NamesName ". $nameTS_f ." LIKE '%".@$namename."%'
AND T.NamesCode ". $nameCodeTS_f ." LIKE '%".@$namecode."%'
AND T.Initial ". $initialTS_f ." LIKE '%".@$initial."%'
AND T.PostalAddress ". $addressTS_f ." LIKE '%".@$address."%'
) AS a ";
$search = "1=1 ";
/*AND NOOFCASE >= '".@$noofcase."'*/
$order = " ORDER BY a.CreateDateTime DESC";
$sql = array('table'=>$name_table,'where'=>$search,'count'=>$count,'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;$data=array();
if($respons_count_num > 0){
while ($row = $this->q_ro($result)) {
/* $data['Data'][$i]['Attention'] =$row['Attention'];
$data['Data'][$i]['CaseId'] =$row['CaseId'];
$data['Data'][$i]['CaseNameId'] =$row['CaseNameId'];
$data['Data'][$i]['CreateBy'] =$row['CreateBy'];
$data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];
$data['Data'][$i]['Deleted'] =$row['Deleted'];
$data['Data'][$i]['ElectronicMail'] =$row['ElectronicMail'];
$data['Data'][$i]['Fax'] =$row['Fax'];
$data['Data'][$i]['Initial'] =$row['Initial'];
$data['Data'][$i]['LastUpdateBy'] =$row['LastUpdateBy'];
$data['Data'][$i]['LastUpdateDateTime'] =$row['LastUpdateDateTime'];
$data['Data'][$i]['NamesName'] =$row['NamesName'];
$data['Data'][$i]['NamesCode'] =$row['NamesCode'];
$data['Data'][$i]['NamesId'] =$row['NamesId'];
$data['Data'][$i]['NamesTypeId'] =$row['NamesTypeId'];
$data['Data'][$i]['NamesTypeName'] =$row['NamesTypeName'];
$data['Data'][$i]['PostalAddress'] =$row['PostalAddress'];
$data['Data'][$i]['Reference'] =$row['Reference'];
$data['Data'][$i]['Remark'] =$row['Remark'];
$data['Data'][$i]['SeqNo'] =$row['SeqNo'];
$data['Data'][$i]['StatusActive'] =$row['StatusActive'];
$data['Data'][$i]['TaxID'] =$row['TaxID'];
$data['Data'][$i]['Telephone'] =$row['Telephone'];*/
$data['Data'][$i]['TaxID'] =$row;
$i++;
}
}else{
$data['Data'] = '';
}
$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;
$data['f'] = intval($filesInTS);
$data['f2'] = $name_table;
return $data;
}
public function NameService2($request)
{
$nameTS = $request['name'];
$nameText = $request['nameText'];
$nameCodeTS = $request['nameCode'];
$nameCodeText = $request['nameCodeText'];
$initialTS = $request['initial'];
$initialText = $request['initialText'];
$addressTS = $request['address'];
$addressText = $request['addressText'];
$filesInTS = $request['dataFiilein'];
$country = @$request['country'];
$nameTypeTs = $request['dataNameType'];
$noOfCasesText = $request['noOfCasesText'];
$count ="";
$name_table = "(
SELECT T.NamesId
,T.NamesName
,T.NamesCode
,T.Telephone
,T.PostalAddress
,T.Fax
,T.ElectronicMail
,T.TaxID
,T.Remark
,T.Initial
,(
SELECT count(CaseId)
FROM t_case_management_trn r
WHERE 1=1
";
$search = "1=1
AND NOOFCASE >= '".@$noofcase."'
ORDER BY a.CreateDateTime DESC";
$order = "";
$sql = array('table'=>$name_table,'where'=>$search,'count'=>$count,'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;$data=array();
if($respons_count_num > 0){
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['TaxID'] =$row;
$i++;
}
}else{
$data['Data'] = '';
}
$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;
$data['f'] = intval($filesInTS);
$data['f2'] = $name_table;
return $data;
}
public function namesddl($Id)
{
$namesId = $Id;
$count = "";
$order = "";
$search = "NamesName Like '%".@$namesId."%' AND StatusActive = '1'";
$name_table = "t_names_mas";
$sql = array('table'=>$name_table,'count'=>$count,'where'=>$search,'order'=> $order, 'limit'=> "0,10");
$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[$i]['NamesName'] = $row['NamesName'];
$data[$i]['NamesId'] = $row['NamesId'];
$data[$i]['sql'] = $view;
$i++;
}
}
return $data;
}
}
?>