| Server IP : 104.21.37.246 / 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 : /home/cp648411/public_html/ilawasia.onnud20.com/class/ |
Upload File : |
<?php
/**
*
*/
class CaseListClass extends Viewdata
{
public function Edit($Id)
{
$count = "";
$name_table = "
ct_case c
INNER JOIN ct_quotation q ON c.QuotationId=q.QuotationId
";
$search = "CaseId = '".$Id."'";
$sql = array('table'=>$name_table,'where'=>$search,'count'=>$count);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$sql2 = array('table'=>'t_system_users','where'=>"Id = '".$row['CreateBy']."'");
$view2 = $this->view($sql2);
$row2 = $this->q($view2);
$sql3 = array('table'=>'t_system_users','where'=>"Id = '".$row['ResponseId']."'");
$view3 = $this->view($sql3);
$row3 = $this->q($view3);
$sql4 = array('table'=>'ct_case','count'=>' SUM(InterQuantity) AS InterQuantity','where'=>"QuotationId = '".$row['QuotationId']."' AND ".date("m")." = MONTH(CreateDateTime) AND ".date("Y")." = YEAR(CreateDateTime)");
$view4 = $this->view($sql4);
$row4 = $this->q($view4);
$data[$i]['Creator'] =$row2['UserName'];
$data[$i]['CaseId'] =$row['CaseId'];
$data[$i]['CaseNumber'] =$row['CaseNumber'];
$data[$i]['CaseTypeId'] =$row['CaseTypeId'];
$data[$i]['CaseDescription'] =$row['CaseDescription'];
$data[$i]['QuotationId'] =$row['QuotationId'];
$data[$i]['CustomerId'] =$row['CustomerId'];
$data[$i]['CreateBy'] =$row['CreateBy'];
$data[$i]['CreateDateTime'] =$row['CreateDateTime'];
$data[$i]['UpdateBy'] =$row['UpdateBy'];
$data[$i]['UpdateDateTime'] =$row['UpdateDateTime'];
$data[$i]['LocalQuantity'] =$row['LocalQuantity'];
$data[$i]['IsNoCounting'] =$row['IsNoCounting'];
$data[$i]['ResponseId'] =$row['ResponseId'];
$data[$i]['Responsibility'] = ($row['ResponseId']>0)?$row3['Name'].' '.$row3['Surname']:'';
$data[$i]['QuotationNo'] =$row['QuotationNo'];
$data[$i]['CountryId'] =$row['CountryId'];
$data[$i]['QuotationType'] =$row['QuotationType'];
$data[$i]['RetainerStart'] =$row['RetainerStart'];
$data[$i]['RetainerEnd'] =$row['RetainerEnd'];
$data[$i]['Condition'] =$row['Condition'];
$data[$i]['CreditType'] =$row['CreditType'];
$data[$i]['CreditTerms'] =$row['CreditTerms'];
$data[$i]['Vat'] =$row['Vat'];
$data[$i]['Del'] =$row['Del'];
$data[$i]['ContactPerson'] =$row['ContactPerson'];
$data[$i]['Currency'] =$row['Currency'];
$data[$i]['CurrentLocalQuantity'] =($row['Quotation']!='')?$row4['InterQuantity']:'';
$data[$i]['CurrentInterQuantity'] =($row['Quotation']!='')?$row4['InterQuantity']:'';
$data[$i]['LimitLocalQuantity'] =($row['Quotation']!='')?$row['LocalQuantity']:'';
$data[$i]['LimitInterQuantity'] =($row['Quotation']!='')?$row['InterQuantity']:'';
$i++;
}
return $data;
}
public function Index($request)
{
$name_table = "ct_country";
$search = "Del = 0";
$sql = array('table'=>$name_table,'where'=>$search);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$data[$i]['CountryId'] =$row['CountryId'];
$data[$i]['CountryName'] =$row['CountryName'];
$data[$i]['CountryCode'] =$row['CountryCode'];
$data[$i]['Status'] =$row['Status'];
$data[$i]['Del'] =$row['Del'];
$data[$i]['CreateBy'] =$row['CreateBy'];
$data[$i]['CreateDateTime'] =$row['CreateDateTime'];
$data[$i]['UpdateBy'] =$row['UpdateBy'];
$data[$i]['UpdateDateTime'] =$row['UpdateDateTime'];
$i++;
}
return $data;
}
public function LoadCaseTypeByCountry($CountryId)
{
$name_table = "ct_master_case_type";
$search = "CountryId = '".$CountryId."'";
$order = " ORDER BY Sort DESC";
$sql = array('table'=>$name_table,'where'=>$search, "order"=>$order);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$data[$i]['CaseTypeId'] =$row['CaseTypeId'];
$data[$i]['CountryId'] =$row['CountryId'];
$data[$i]['CaseTypeName'] =$row['CaseTypeName'];
$data[$i]['CaseTypeAbbr'] =$row['CaseTypeAbbr'];
$data[$i]['Status'] =$row['Status'];
$data[$i]['Del'] =$row['Del'];
$data[$i]['CreateBy'] =$row['CreateBy'];
$data[$i]['CreateDateTime'] =$row['CreateDateTime'];
$data[$i]['UpdateBy'] =$row['UpdateBy'];
$data[$i]['UpdateDateTime'] =$row['UpdateDateTime'];
$data[$i]['Sort'] =$row['Sort'];
$i++;
}
return $data;
}
public function LoadCaseExpense($CaseId)
{
$name_table = "ct_case_expense";
$search = "CaseId = '".$CaseId."' AND Del = 0";
//$order = " ORDER BY Sort DESC"
$sql = array('table'=>$name_table,'where'=>$search);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$data[$i]['CaseExpenseId'] =$row['CaseExpenseId'];
$data[$i]['CaseId'] =$row['CaseId'];
$data[$i]['ExpenseDate'] =$row['ExpenseDate'];
$data[$i]['ExpenseDetail'] =$row['ExpenseDetail'];
$data[$i]['ExpenseTotal'] =$row['ExpenseTotal'];
$data[$i]['ExpenseStatus'] =$row['ExpenseStatus'];
$data[$i]['Category'] =$row['Category'];
$data[$i]['IsExcludeVat'] =$row['IsExcludeVat'];
$data[$i]['Del'] =$row['Del'];
$data[$i]['CreateBy'] =$row['CreateBy'];
$data[$i]['CreateDateTime'] =$row['CreateDateTime'];
$data[$i]['UpdateBy'] =$row['UpdateBy'];
$data[$i]['UpdateDateTime'] =$row['UpdateDateTime'];
$i++;
}
return $data;
}
public function LoadCaseEvent($request)
{
$name_table = "ct_case_event";
$search = "CaseId = '".$request['CaseId']."' AND Del = 0";
$order = "";
$count = "";
$sql = array('table'=>$name_table,'where'=>$search);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$data[$i]['CaseEventId'] =$row['CaseEventId'];
$data[$i]['CaseId'] =$row['CaseId'];
$data[$i]['EventId'] =$row['EventId'];
$data[$i]['EventDate'] =$row['EventDate'];
$data[$i]['DueDate'] =$row['DueDate'];
$data[$i]['AttachmentPath'] =$row['AttachmentPath'];
$data[$i]['TimeSheetPerson'] =$row['TimeSheetPerson'];
$data[$i]['Duration'] =$row['Duration'];
$data[$i]['Del'] =$row['Del'];
$data[$i]['CreateBy'] =$row['CreateBy'];
$data[$i]['CreateDateTime'] =$row['CreateDateTime'];
$data[$i]['UpdateBy'] =$row['UpdateBy'];
$data[$i]['UpdateDateTime'] =$row['UpdateDateTime'];
$data[$i]['OtherText'] =$row['OtherText'];
$i++;
}
return $data;
}
public function LoadCaseNote($CaseId)
{
$name_table = "ct_case_note";
$search = "CaseId = '".$CaseId."' AND Del = 0";
$sql = array('table'=>$name_table,'where'=>$search);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$data[$i]['CaseNoteId'] =$row['CaseNoteId'];
$data[$i]['CaseId'] =$row['CaseId'];
$data[$i]['NoteType'] =$row['NoteType'];
$data[$i]['NoteDate'] =$row['NoteDate'];
$data[$i]['NoteDescription'] =$row['NoteDescription'];
$data[$i]['Del'] =$row['Del'];
$data[$i]['CreateBy'] =$row['CreateBy'];
$data[$i]['CreateDateTime'] =$row['CreateDateTime'];
$data[$i]['UpdateBy'] =$row['UpdateBy'];
$data[$i]['UpdateDateTime'] =$row['UpdateDateTime'];
$i++;
}
return $data;
}
public function LoadCaseTimeSheet($CaseId)
{
$name_table = "ct_case_timesheet";
$search = "CaseId = '".$CaseId."' AND Del = 0";
$order = "ORDER BY TaskDate ASC, CaseTimeSheetId ASC";
$sql = array('table'=>$name_table,'where'=>$search,'order'=>$order);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$data[$i]['CaseTimeSheetId'] =$row['CaseTimeSheetId'];
$data[$i]['TaskDate'] =$row['TaskDate'];
$data[$i]['TaskDescription'] =$row['TaskDescription'];
$data[$i]['Duration'] =$row['Duration'];
$data[$i]['Del'] =$row['Del'];
$sql2 = array('table'=>"t_system_users",'where'=>"Id = '".$row['CreateBy']."'","count"=>"concat(Name,'',SurName) AS Person");
$view2 = $this->view($sql2);
$row2 = $this->q($view2);
$data[$i]['Person'] =$row2['Person'];
$i++;
}
return $data;
}
public function LoadCaseAttachment($CaseId)
{
$name_table = "ct_case_attachment";
$search = "CaseId = '".$CaseId."' AND Del = 0";
$sql = array('table'=>$name_table,'where'=>$search);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$data[$i]['CaseAttachmentId'] =$row['CaseAttachmentId'];
$data[$i]['DocumentName'] =$row['DocumentName'];
$data[$i]['DocumentDate'] =$row['DocumentDate'];
$data[$i]['DocumentType'] =$row['DocumentType'];
$data[$i]['DocumentTypeName'] =($row['DocumentType'] ==1)?"Customer Doc": ($row['DocumentType'] == 2) ? "Lawyer Doc" : ($row['DocumentType'] ==3)? "Gov. Doc" : "";
$data[$i]['FilePath'] =$row['FilePath'];
$data[$i]['AttachmentDate'] =$row['AttachmentDate'];
$data[$i]['Del'] =$row['Del'];
$i++;
}
return $data;
}
public function LoadCaseDisbursement($request)
{
$name_table = "ct_case_disbursement";
$search = "CaseId = '".$request['CaseId']."' AND Del = 0";
$order = " ORDER BY Date DESC";
$sql = array('table'=>$name_table,'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]['Amount'] =floatval($row['Amount']);
$data['Data'][$i]['CaseDisburseId'] =$row['CaseDisburseId'];
$data['Data'][$i]['CaseId'] =$row['CaseId'];
$data['Data'][$i]['Category'] =$row['Category'];
$data['Data'][$i]['CreateBy'] =$row['CreateBy'];
$data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];
$data['Data'][$i]['Date'] =$row['Date'];
$data['Data'][$i]['Del'] =$row['Del'];
$data['Data'][$i]['Detail'] =$row['Detail'];
$data['Data'][$i]['UpdateBy'] =$row['UpdateBy'];
$data['Data'][$i]['UpdateDateTime'] =$row['UpdateDateTime'];
$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;
return $data;
}
public function GetDisburseCategories()
{
//$name_table = "ct_master_disburse_cat";
$name_table = "ct_category";
$search = "Status = '1'";
$order = "";
$sql = array('table'=>$name_table,'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);
$result_num = $this->q_nr($result);
$i=0;$data=array();
if($result_num >0){
while ($row = $this->q_ro($result)) {
/*
$data['Data'][$i]['DisburseCategoryId'] =$row['DisburseCategoryId'];
$data['Data'][$i]['Name'] =$row['Name'];
*/
$data['Data'][$i]['CategoryId'] =$row['CategoryId'];
$data['Data'][$i]['CategoryName'] =$row['CategoryName'];
$data['Data'][$i]['Status'] =$row['Status'];
$data['Data'][$i]['Del'] =$row['Del'];
$data['Data'][$i]['CreateBy'] =$row['CreateBy'];
$data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];
$data['Data'][$i]['UpdateBy'] =$row['UpdateBy'];
$data['Data'][$i]['UpdateDateTime'] =$row['UpdateDateTime'];
$data['Data'][$i]['Sort'] =$row['Sort'];
$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['result_num'] = @$result_num;
return $data;
}
public function LoadFilterEvent($CaseTypeId)
{
$name_table = "ct_master_case_type_event";
$search = "CaseTypeId = '".$CaseTypeId."'";
//$name_table = "ct_master_case_type";
$sql = array('table'=>$name_table,'where'=>$search);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$sql2 = array('table'=>"ct_master_event",'where'=>"EventId = '".$row['EventId']."'");
$view2 = $this->view($sql2);
$row2 = $this->q($view2);
$data[$i]['EventId'] =$row2['EventId'];
$data[$i]['EventName'] =$row2['EventName'];
$data[$i]['DeadLineFlag'] =$row2['DeadLineFlag'];
$data[$i]['FreeTextFlag'] =$row2['FreeTextFlag'];
$data[$i]['TimeSheetFlag'] =$row2['TimeSheetFlag'];
$data[$i]['Status'] =$row2['Status'];
$data[$i]['DefaultFlag'] =$row2['DefaultFlag'];
$data[$i]['Del'] =$row2['Del'];
$data[$i]['CreateBy'] =$row2['CreateBy'];
$data[$i]['CreateDateTime'] =$row2['CreateDateTime'];
$data[$i]['UpdateBy'] =$row2['UpdateBy'];
$data[$i]['UpdateDateTime'] =$row2['UpdateDateTime'];
$data[$i]['row2'] =$row2;
$data[$i]['row'] =$row;
$i++;
}
//$data['sql'] = $view;
return $data;
}
public function LoadFilterEvent2($CaseTypeId)
{
$name_table = "ct_master_event";
$search = '';
//$name_table = "ct_master_case_type";
//$search = "CaseTypeId = '".$CaseTypeId."'";
$sql = array('table'=>$name_table,'where'=>$search);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$data[$i]['EventId'] =$row['EventId'];
$data[$i]['EventName'] =$row['EventName'];
$data[$i]['DeadLineFlag'] =$row['DeadLineFlag'];
$data[$i]['FreeTextFlag'] =$row['FreeTextFlag'];
$data[$i]['TimeSheetFlag'] =$row['TimeSheetFlag'];
$data[$i]['Status'] =$row['Status'];
$data[$i]['DefaultFlag'] =$row['DefaultFlag'];
$data[$i]['Del'] =$row['Del'];
$data[$i]['CreateBy'] =$row['CreateBy'];
$data[$i]['CreateDateTime'] =$row['CreateDateTime'];
$data[$i]['UpdateBy'] =$row['UpdateBy'];
$data[$i]['UpdateDateTime'] =$row['UpdateDateTime'];
$data[$i]['row'] =$row;
$i++;
}
//$data['sql'] = $view;
return $data;
}
public function LoadCaseAutoComplete($Keyword)
{
$name_table = "ct_case";
$search = " CaseNumber Like '%".$Keyword."%'";
$sql = array('table'=>$name_table,'where'=>$search, 'order'=> 'LIMIT 0,10');
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$data[$i]['CaseId'] =$row['CaseId'];
$data[$i]['CaseNumber'] =$row['CaseNumber'];
$data[$i]['CaseTypeId'] =$row['CaseTypeId'];
$data[$i]['CaseDescription'] =$row['CaseDescription'];
$data[$i]['QuotationId'] =$row['QuotationId'];
$data[$i]['CustomerId'] =$row['CustomerId'];
$data[$i]['CreateBy'] =$row['CreateBy'];
$data[$i]['CreateDateTime'] =$row['CreateDateTime'];
$data[$i]['UpdateBy'] =$row['UpdateBy'];
$data[$i]['UpdateDateTime'] =$row['UpdateDateTime'];
$data[$i]['LocalQuantity'] =$row['LocalQuantity'];
$data[$i]['InterQuantity'] =$row['InterQuantity'];
$data[$i]['ResponseId'] =$row['ResponseId'];
$i++;
}
return $data;
}
public function LoadCaseList($request)
{
$count = "
c.*,'' as DueDate
,'' as LastEvent
";
$name_table = "ct_case c";
$search = " 1=1 ";
$order='';
if($request['CaseTypeId']!=''){
$search = $search." AND c.CaseTypeId = '".@$request['CaseTypeId']."'";
}
if($request['CaseNumber']!=''){
$search = $search." AND c.CaseNumber LIKE '%".@$request['CaseNumber']."%'";
}
if($request['Status']>0){
if($request['Status']==1){
$search = $search." AND (SELECT Count(*) FROM ct_case_event WHERE EventId = 1 AND CaseId=c.CaseId) > 0";
$search = $search." AND (SELECT Count(*) FROM ct_case_event WHERE EventId = 2 AND CaseId=c.CaseId) = 0";
}
if($request['Status']==2){
$search = $search." AND (SELECT Count(*) FROM ct_case_event WHERE EventId = 2 AND CaseId=c.CaseId) > 0";
}
}
if($request['CustomerId']>0){
$search = $search." AND c.CustomerId = '".@$request['CustomerId']."'";
}
if(@$request['DueDateStart'] !='' && @$request['DueDateEnd'] !='' ){
$dueStart = $request['DueDateStart'];
$dueEnd = $request['DueDateEnd'];
$search = $search." AND (SELECT Count(*) FROM ct_case_event WHERE DueDate BETWEEN '".$dueStart."' AND '".$dueEnd."' AND CaseId=c.CaseId) > 0";
}
if(@$request['EventDateStart'] !='' && @$request['EventDateEnd']!=''){
$eventStart = $request['EventDateStart'];
$eventEnd = $request['EventDateEnd'];
$search = $search." AND (SELECT Count(*) FROM ct_case_event WHERE (EventDate BETWEEN '".$eventStart."' AND '".$eventEnd."') AND CaseId=c.CaseId) > 0";
}
if($request['PersonName']!=''){
$personName=$request['PersonName'];
$sql_ResponT = array('table'=>"t_system_users",'where'=>"CONCAT(Name,' ',Surname) LIKE '%".$personName."%'");
$view_ResponT = $this->view($sql_ResponT);
$row_ResponT = $this->q($view_ResponT);
//$search = $search." AND c.Responsibility = '".$row_ResponT['Id']."' ";
$search = $search." AND (SELECT CONCAT(Name,' ',Surname) as Name FROM t_system_users WHERE Id = c.CreateBy) LIKE '%".$personName."%' ";
}
if($request['Responsibility']!=''){
$responseName=$request['Responsibility'];
$search = $search." AND (SELECT CONCAT(Name,' ',Surname) as Name FROM t_system_users WHERE Id = c.ResponseId) LIKE '%".$responseName."%' ";
}
if($request['OrderDirection']!=''){
$order = " Order By ".$request['OrderBy'] ." ".$request['OrderDirection'];
}
//$order = " ORDER BY EventId DESC"
$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]['LastEvent'] =$row['LastEvent'];
$data['Data'][$i]['row'] =$row;
$sql2 = array('table'=>"ct_case_event",'where'=>"CaseId = '".$row['CaseId']."' AND DueDate!=''");
$view2 = $this->view($sql2);
$result2 = $this->q_re($view2);
while ($row2 = $this->q_ro($result2)) {
$data['Data'][$i]['row2'] =$row2;
}
$sql_CaseType = array('table'=>"ct_master_case_type","count"=>'CaseTypeName AS CaseType','where'=>"CaseTypeId = '".$row['CaseTypeId']."'");
$view_CaseType = $this->view($sql_CaseType);
$row_CaseType = $this->q($view_CaseType);
$data['Data'][$i]['CaseType'] = $row_CaseType['CaseType'];
$sql_NamesName = array('table'=>"t_names_mas","count"=>'NamesName AS CustomerName','where'=>"NamesId = '".$row['CustomerId']."'");
$view_NamesName = $this->view($sql_NamesName);
$row_NamesName = $this->q($view_NamesName);
$data['Data'][$i]['CustomerName'] =$row_NamesName['CustomerName'];
$sql_Respon = array('table'=>"t_system_users","count"=>"CONCAT(Name, ' ', SurName) AS Responsibility",'where'=>"Id = '".$row['ResponseId']."'");
$view_Respon = $this->view($sql_Respon);
$row_Respon = $this->q($view_Respon);
$data['Data'][$i]['Responsibility'] =$row_Respon['Responsibility'];
$sql_Creator = array('table'=>"t_system_users","count"=>'UserName AS Creator','where'=>"Id = '".$row['CreateBy']."'");
$view_Creator = $this->view($sql_Creator);
$row_Creator = $this->q($view_Creator);
$data['Data'][$i]['Creator'] =$row_Creator['Creator'];
$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['view_ResponT'] = $view_ResponT;
return $data;
}
public function LoadQuotationItems($request)
{
$sql2 = array('table'=>"ct_case",'where'=>"CaseId = '".$request['CaseId']."'");
$view2 = $this->view($sql2);
$row2 = $this->q($view2);
$count = "";
$name_table = "ct_quotation";
$search = " QuotationId = '".$row2['QuotationId']."'";
$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();
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['CaseTypeId'] =$row['CaseTypeId'];
$data['Data'][$i]['Condition'] =$row['Condition'];
$data['Data'][$i]['ContactPerson'] =$row['ContactPerson'];
$data['Data'][$i]['CountryId'] =$row['CountryId'];
$data['Data'][$i]['CreateBy'] =$row['CreateBy'];
$data['Data'][$i]['QuotationDate'] =$row['CreateDateTime'];
$data['Data'][$i]['CreditTerms'] =$row['CreditTerms'];
$data['Data'][$i]['CreditType'] =$row['CreditType'];
$data['Data'][$i]['Currency'] =$row['Currency'];
$data['Data'][$i]['CustomerId'] =$row['CustomerId'];
$data['Data'][$i]['Del'] =$row['Del'];
$data['Data'][$i]['InterQuantity'] =$row['InterQuantity'];
$data['Data'][$i]['LocalQuantity'] =$row['LocalQuantity'];
$data['Data'][$i]['QuotationId'] =$row['QuotationId'];
$data['Data'][$i]['QuotationNo'] =$row['QuotationNo'];
$data['Data'][$i]['QuotationType'] =$row['QuotationType'];
$data['Data'][$i]['RetainerEnd'] =$row['RetainerEnd'];
$data['Data'][$i]['RetainerStart'] =$row['RetainerStart'];
$data['Data'][$i]['Status'] =$row['Status'];
$data['Data'][$i]['UpdateBy'] =$row['UpdateBy'];
$data['Data'][$i]['UpdateDateTime'] =$row['UpdateDateTime'];
$data['Data'][$i]['Vat'] =$row['Vat'];
$sql3 = array('table'=>"ct_quotation_document",'where'=>"QuotationId = '".$row['QuotationId']."' AND Status =3");
$view3 = $this->view($sql2);
$row3 = $this->q($view2);
$data['Data'][$i]['File'] =$row3['ApproveFilePath'];
$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;
return $data;
}
public function LoadUsersAutoComplete($Keyword)
{
$name_table = "t_system_users";
$search = " UserName Like '%".$Keyword."%' || Name Like '%".$Keyword."%' || Surname Like '%".$Keyword."%'";
$sql = array('table'=>$name_table,'where'=>$search, 'order'=> 'LIMIT 0,10');
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$data[$i]['CreationTime'] =$row['CreationTime'];
$data[$i]['CreatorUserId'] =$row['CreatorUserId'];
$data[$i]['EmailAddress'] =$row['EmailAddress'];
$data[$i]['Id'] =$row['Id'];
$data[$i]['IsDeleted'] =$row['IsDeleted'];
$data[$i]['LastUpdateBy'] =$row['LastUpdateBy'];
$data[$i]['LastUpdateDateTime'] =$row['LastUpdateDateTime'];
$data[$i]['MiddleName'] =$row['MiddleName'];
$data[$i]['Name'] =$row['Name'];
$data[$i]['StatusActive'] =$row['StatusActive'];
$data[$i]['Surname'] =$row['Surname'];
$data[$i]['Title'] =$row['Title'];
$data[$i]['UserName'] =$row['UserName'];
$i++;
}
return $data;
}
public function LoadUsersAutoCompleteAll()
{
$name_table = "t_system_users";
$search = "1=1 ";
//$order = " ORDER BY EventId DESC"
$sql = array('table'=>$name_table,'where'=>$search);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
while ($row = $this->q_ro($result)) {
$data[$i]['CreationTime'] =$row['CreationTime'];
$data[$i]['CreatorUserId'] =$row['CreatorUserId'];
$data[$i]['EmailAddress'] =$row['EmailAddress'];
$data[$i]['Id'] =$row['Id'];
$data[$i]['IsDeleted'] =$row['IsDeleted'];
$data[$i]['LastUpdateBy'] =$row['LastUpdateBy'];
$data[$i]['LastUpdateDateTime'] =$row['LastUpdateDateTime'];
$data[$i]['MiddleName'] =$row['MiddleName'];
$data[$i]['Name'] =$row['Name'];
$data[$i]['StatusActive'] =$row['StatusActive'];
$data[$i]['Surname'] =$row['Surname'];
$data[$i]['Title'] =$row['Title'];
$data[$i]['UserName'] =$row['UserName'];
$i++;
}
return $data;
}
}
?>