| 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 CaseListClass extends Viewdata
{
public function Edit($Id)
{
$count = "c.*,q.QuotationNo,q.CountryId,q.CustomerId,q.CorId,q.Corper,q.BillId,q.Billper,
q.CorIdfix,q.Corperfix,q.OriginatingAttorneyId,q.OriginatingAttorneyper,q.SupervisingId,q.SupervisingName,
q.Supervisingusd,q.Supervisingthb,q.Hour,q.HRateusdE,q.HRatethbE,q.AssigneeId,q.HRateusd,q.HRatethb,
q.RetainerStart,q.RetainerEnd,q.Condition,q.QuotationType,q.CreditType,q.CreditTerms,q.Vat,q.Referral,q.ContactPerson,
q.ContactPerson,q.LocalQuantity,q.InterQuantity";
$name_table = "
ct_case c
INNER JOIN ct_quotation q ON c.QuotationId=q.QuotationId
";
$search = "c.CaseId = '".$Id."'";
$sql = array('table'=>$name_table,'where'=>$search,'count'=>$count);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;
$data=[];
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'] ? $row['Del'] : "";
$data[$i]['ContactPerson'] =$row['ContactPerson'] ? $row['ContactPerson'] : "";
$data[$i]['Currency'] =($row['Currency'] ?? "");
$data[$i]['CurrentLocalQuantity'] =($row4['InterQuantity']!='')?$row4['InterQuantity']:'';
$data[$i]['CurrentInterQuantity'] =($row4['InterQuantity']!='')?$row4['InterQuantity']:'';
$data[$i]['LimitLocalQuantity'] =($row['LocalQuantity']!='')?$row['LocalQuantity']:'';
$data[$i]['LimitInterQuantity'] =($row['InterQuantity']!='')?$row['InterQuantity']:'';
$data[$i]['CorId'] = $row['CorId'];
$data[$i]['BillId'] = $row['BillId'];
$data[$i]['Referral'] = $row['Referral'];
$data[$i]['OriginatingAttorneyId'] = $row['OriginatingAttorneyId'];
$data[$i]['QuotationType'] = $row['QuotationType'];
$data[$i]['RetainerStart'] = $row['RetainerStart'];
$data[$i]['RetainerEnd'] = $row['RetainerEnd'];
$data[$i]['Corper'] = $row['Corper'];
$data[$i]['Billper'] = $row['Billper'];
$data[$i]['OriginatingAttorneyper'] = $row['OriginatingAttorneyper'];
$data[$i]['SupervisingId'] = $row['SupervisingId'];
$data[$i]['Supervisingusd'] = $row['Supervisingusd'];
$data[$i]['Supervisingthb'] = $row['Supervisingthb'];
$data[$i]['Hour'] = $row['Hour'];
$data[$i]['HRateusdE'] = $row['HRateusdE'];
$data[$i]['HRatethbE'] = $row['HRatethbE'];
$data[$i]['AssigneeId'] = $row['AssigneeId'];
$data[$i]['HRateusd'] = $row['HRateusd'];
$data[$i]['HRatethb'] = $row['HRatethb'];
$data[$i]['Super'] = $this->LoadCheckSA($row['QuotationId']);
$i++;
}
$data['view'] = $view;
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 LoadCheckHr($Id)
{
$count = "c.CaseId, c.CaseNumber, q.Hour";
$name_table = "
ct_quotation q
INNER JOIN ct_case c ON q.QuotationId=c.QuotationId
";
$search = "c.QuotationId = '".$Id."'";
$sql = array('table'=>$name_table,'where'=>$search,'count'=>$count);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
$Duration = 0;$s=0;
while ($row = $this->q_ro($result)) {
$u=0;$y=0;$ss1=0;$ss2=0;
$data[$i]['CaseId'] =$row['CaseId'];
$data[$i]['Hour'] =$row['Hour'];
$data[$i]['CaseNumber'] =$row['CaseNumber'];
$Duration2 = 0;
$Duration3 = 0;
$sql2 = array('table'=>'ct_case_event cv INNER JOIN t_system_users t ON cv.CreateBy = t.Id'
,'count'=>'cv.*, t.UserName, t.Name, t.SurName,t.Id'
,'where'=>"cv.CaseId = '".$row['CaseId']."'");
$view2 = $this->view($sql2);
$result2 = $this->q_re($view2);
while ($row2 = $this->q_ro($result2)) {
$Duration2 = $Duration2 + $row2['Duration'];
$data[$i]['new_set_duration'][$ss1] = $row2['Duration'];
$data[$i]['new_set_createby'][$ss1] = $row2['UserName'];
$data[$i]['new_set_createby_id'][$ss1] = $row2['Id'];
$data[$i]['new_set_createtime'][$ss1] = ($row2['CreateDateTime'] ?? "");
$data[$i]['new_set_createtime_all'][$ss2] = ($row2['CreateDateTime'] ?? "");
$u++;$s++;$ss1++;$ss2++;
}
$sql3 = array('table'=>'ct_timesheet ct INNER JOIN t_system_users t ON ct.CreateBy = t.Id'
,'count'=>'ct.*, t.UserName, t.Name, t.SurName,t.Id'
,'where'=>"ct.CaseId = '".$row['CaseId']."'");
$view3 = $this->view($sql3);
$result3 = $this->q_re($view3);
while ($row3 = $this->q_ro($result3)) {
$Duration3 = $Duration3 + $row3['Duration'];
$data[$i]['new_set_duration'][$ss1] = $row3['Duration'];
$data[$i]['new_set_createby'][$ss1] = $row3['UserName'];
$data[$i]['new_set_createby_id'][$ss1] = $row3['Id'];
$data[$i]['new_set_createtime'][$ss1] = $row3['CreateDateTime'];
$data[$i]['new_set_createtime_all'][$ss2] = $row3['CreateDateTime'];
$y++;$s++;$ss1++;$ss2++;
}
$data[$i]['Duration2'] =$Duration2;
$data[$i]['Duration3'] =$Duration3;
$data[$i]['sum'] =$Duration2 + $Duration3;
$i++;
}
for ($y=0; $y < count($data); $y++) {
$Duration = floatval($Duration) + floatval($data[$y]['sum']);
}
$data['Duration'] = $Duration;
//$data['sql'] = $view;
return $data;
}
public function LoadCheckSA($Id) {
$count = " ca.AssigneeId, ca.AssigneelavelId,ca.AssigneelavelName,ca.HourlyRateTHB AS thbA,ca.HourlyRateUSD AS usdA,
cs.SupervisingId,cs.SupervisinglavelId,cs.SupervisinglavelName,cs.HourlyRateTHB AS thbS,cs.HourlyRateUSD AS usdS";
$name_table = "ct_quotation q
INNER JOIN ct_quotation_assignee ca ON q.QuotationId=ca.QuotationId
INNER JOIN ct_quotation_supervising cs ON q.QuotationId=cs.QuotationId
";
$search = "q.QuotationId = '".$Id."'";
$sql = array('table'=>$name_table,'where'=>$search,'count'=>$count);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
$Duration = 0;$s=0;
while ($row = $this->q_ro($result)) {
$data[$i]['AssigneeId'] =$row['AssigneeId'];
$data[$i]['AssigneelavelId'] =$row['AssigneelavelId'];
$data[$i]['AssigneelavelName'] =$row['AssigneelavelName'];
$data[$i]['thbA'] =$row['thbA'];
$data[$i]['usdA'] =$row['usdA'];
$data[$i]['SupervisingId'] =$row['SupervisingId'];
$data[$i]['SupervisinglavelId'] =$row['SupervisinglavelId'];
$data[$i]['SupervisinglavelName'] =$row['SupervisinglavelName'];
$data[$i]['thbS'] =$row['thbS'];
$data[$i]['usdS'] =$row['usdS'];
$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";
$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'];
$data[$i]['TaskDate'] =$row['TaskDate'];
$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]['CategoryId'] =$row['CategoryId'];
$data[$i]['Category'] ="";
$sql_cate = array('table'=>'ct_category_timesheet','where'=>'CategoryId = "'.$row['CategoryId'].'"');
$view_cate = $this->view($sql_cate);
$result_cate = $this->q_re($view_cate);
$result_cate_num = $this->q_nr($result_cate);
if($result_cate_num>0){
$row_cate = $this->q($view_cate);
$data[$i]['Category'] =$row_cate['CategoryName'];
}
$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'];
$documentTypeMap = [
1 => "Customer Doc",
2 => "Lawyer Doc",
3 => "Gov. Doc"
];
$data[$i]['DocumentTypeName'] = isset($documentTypeMap[$row['DocumentType']])
? $documentTypeMap[$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 LoadTimesheetCategory($CategoryId)
{
$name_table = "ct_category_timesheet";
$search = "Status = 1 AND Del = 0";
if($CategoryId!=""){
$search = $search. " AND CategoryId = '".$CategoryId."'";
}
$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['Data'][$i]['CategoryId'] =$row['CategoryId'];
$data['Data'][$i]['Category'] =$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'];
$i++;
}
$data['sql'] = $view;
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 = '';
$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_sup = array('table'=>"ct_quotation","count"=>'SupervisingName AS SupName','where'=>"QuotationId = '".$row['QuotationId']."'");
$view_sup = $this->view($sql_sup);
$row_sup = $this->q($view_sup);
$data['Data'][$i]['supervisingName'] =$row_sup['SupName'];
$data['Data'][$i]['super'] = $this->LoadCheckSA($row['QuotationId']);
$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;
$data['Data2'] = $this->LoadCheckHr($row2['QuotationId']);
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;
}
}
?>