| 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 : /home/cp648411/public_html/ilawasia.onnud20.com/class_old/ |
Upload File : |
<?php
/**
*
*/
class QuotationClass extends ViewData
{
public function LoadQuotationList($request){
$count = "
* FROM (
SELECT q.*,c.NamesName as CustomerName,c.NamesCode as CustomerCode
,(SELECT CountryName FROM ct_country WHERE CountryId=q.CountryId) as Country
,CASE WHEN q.Status = 1 THEN 'Draft' ELSE 'Approved' END as StatusText
,(SELECT SUM(Amount) FROM ct_quotation_item WHERE QuotationId = q.QuotationId) as Amount
,c.PostalAddress as Address,ct.Department
,(SELECT COUNT(*) FROM ct_case WHERE QuotationId = q.QuotationId) + (SELECT COUNT(*) FROM ct_case_quotation WHERE QuotationId = q.QuotationId) as IsEdit
";
$name_table = "
ct_quotation q
INNER JOIN t_names_mas c ON q.CustomerId=c.NamesId
INNER JOIN ct_master_case_type ct ON ct.CaseTypeId = q.CaseTypeId
) A
";
$search = "Del = '0'";
$order='';
if(@$request['CustomerId']>0){
$cusId = $request['CustomerId'];
$search = $search ." AND CustomerId = '".$cusId."'";
}
if(@$request['QuotationNumber']!=''){
$quotationNo = $request['QuotationNumber'];
$search = $search ." AND QuotationNo = '".$quotationNo."'";
}
if(@$request['CustomerName']!=''){
$customerName = $request['CustomerName'];
//$search = $search ." AND CustomerName LIKE '%".$customerName."%'";
//$search = $search ." OR c.NamesCode = '".$customerName."'";
}
if(@$request['CaseNumber']!=''){
$caseNo = $request['CaseNumber'];
$search = $search ." AND (SELECT Count(*) From ct_case cc WHERE cc.QuotationId=A.QuotationId AND cc.CaseNumber LIKE '%".$caseNo."%') > 0";
}
if(@$request['Department']!=''){
$department = $request['Department'];
$search = $search ." AND Department = '".$department."'";
}
if(@$request['QuotationType']>0){
$quotationType = $request['QuotationType'];
$search = $search ." AND QuotationType LIKE '".$quotationType."'";
}
if(@$request['Status']>0){
$status = $request['Status'];
$search = $search ." AND Status LIKE '".$status."'";
}
if(@$request['QuotationId']!=""){
$search .= " AND QuotationId = '".$request['QuotationId']."'";
}
if($request['OrderDirection']!=""){
$order = " ORDER BY `A`.`".$request['OrderBy']."` ".$request['OrderDirection'];
}
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search, 'order' => $order);
if($request['PageSize']!=''){
$page_number = $request['PageNumber'] - 1;
$max_rows = $request['PageSize'];
$list_count = array('table'=>$name_table,'count'=>$count,'where'=>$search); //,'order' => 'ORDER BY `QuotationId` DESC '
$start_count = $page_number * $max_rows;
$view_count = $this->view($list_count);
$result_count = $this->q_re($view_count);
$respons_count = $this->q_nr($result_count);
$respons_count_num = mysqli_num_rows($result_count);
$respons_pages = ceil($respons_count/$max_rows)-1;
$data_c['page_number'] = $page_number;
$data_c['respons_pages'] = $respons_pages;
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search, 'limit'=> "$start_count,$max_rows",'order'=> $order);
}
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;$data=array();
if($respons_count_num > 0){
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['Address'] =$row['Address'];
$data['Data'][$i]['Amount'] = floatval($row['Amount']);
$data['Data'][$i]['CaseTypeId'] =$row['CaseTypeId'];
$data['Data'][$i]['Condition'] =$row['Condition'];
$data['Data'][$i]['ContactPerson'] =$row['ContactPerson'];
$data['Data'][$i]['Country'] =$row['Country'];
$data['Data'][$i]['CountryId'] =$row['CountryId'];
$data['Data'][$i]['CreateBy'] =$row['CreateBy'];
$data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];
$data['Data'][$i]['CreditTerms'] =$row['CreditTerms'];
$data['Data'][$i]['CreditType'] =$row['CreditType'];
$data['Data'][$i]['Currency'] =$row['Currency'];
$data['Data'][$i]['CustomerCode'] =$row['CustomerCode'];
$data['Data'][$i]['CustomerId'] =$row['CustomerId'];
$data['Data'][$i]['CustomerName'] =$row['CustomerName'];
$data['Data'][$i]['Del'] =$row['Del'];
$data['Data'][$i]['Department'] =$row['Department'];
$data['Data'][$i]['InterQuantity'] =$row['InterQuantity'];
$data['Data'][$i]['IsEdit'] =$row['IsEdit'];
$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]['StatusText'] =$row['StatusText'];
$data['Data'][$i]['UpdateBy'] =$row['UpdateBy'];
$data['Data'][$i]['UpdateDateTime'] =$row['UpdateDateTime'];
$data['Data'][$i]['Vat'] =$row['Vat'];
$i2 = 0;
$secrch_inv = "QuotationId = '".$row['QuotationId']."' AND Del = '0'";
$order_inv = "ORDER BY InvoiceId ASC";
$sql_inv = array('table'=>'ct_invoice','where'=>$secrch_inv,'order'=>$order_inv);
$view_inv = $this->view($sql_inv);
$result_inv = $this->q_re($view_inv);
$respons_count_inv = $this->q_nr($result_inv);
if($respons_count_inv > 0){
while ($row_inv = $this->q_ro($result_inv)) {
$data['Data'][$i]['invoicelist'][$i2]['BillDetail'] =$row_inv['BillDetail'];
$data['Data'][$i]['invoicelist'][$i2]['CreateBy'] =$row_inv['CreateBy'];
$data['Data'][$i]['invoicelist'][$i2]['CreateDateTime'] =$row_inv['CreateDateTime'];
$data['Data'][$i]['invoicelist'][$i2]['Del'] =$row_inv['Del'];
$data['Data'][$i]['invoicelist'][$i2]['InvoiceId'] =$row_inv['InvoiceId'];
$data['Data'][$i]['invoicelist'][$i2]['InvoiceNo'] =$row_inv['InvoiceNo'];
$data['Data'][$i]['invoicelist'][$i2]['IsCo'] =$row_inv['IsCo'];
$data['Data'][$i]['invoicelist'][$i2]['IsConsultService'] =$row_inv['IsConsultService'];
$data['Data'][$i]['invoicelist'][$i2]['IsExcludeVat'] =$row_inv['IsExcludeVat'];
$data['Data'][$i]['invoicelist'][$i2]['IsWitholdingTax'] =$row_inv['IsWitholdingTax'];
$data['Data'][$i]['invoicelist'][$i2]['ResponseId'] =$row_inv['ResponseId'];
$data['Data'][$i]['invoicelist'][$i2]['Status'] =$row_inv['Status'];
$data['Data'][$i]['invoicelist'][$i2]['Tax'] =$row_inv['Tax'];
$data['Data'][$i]['invoicelist'][$i2]['Vat'] =$row_inv['Vat'];
$data['Data'][$i]['invoicelist'][$i2]['UpdateBy'] =$row_inv['UpdateBy'];
$data['Data'][$i]['invoicelist'][$i2]['UpdateDateTime'] =$row_inv['UpdateDateTime'];
$i2++;
}
}else {
$data['Data'][$i]['invoicelist'][$i2]['BillDetail'] ='';
$data['Data'][$i]['invoicelist'][$i2]['CreateBy'] ='';
$data['Data'][$i]['invoicelist'][$i2]['CreateDateTime'] ='';
$data['Data'][$i]['invoicelist'][$i2]['Del'] ='';
$data['Data'][$i]['invoicelist'][$i2]['InvoiceId'] ='';
$data['Data'][$i]['invoicelist'][$i2]['InvoiceNo'] ='';
$data['Data'][$i]['invoicelist'][$i2]['IsCo'] ='';
$data['Data'][$i]['invoicelist'][$i2]['IsConsultService'] ='';
$data['Data'][$i]['invoicelist'][$i2]['IsExcludeVat'] ='';
$data['Data'][$i]['invoicelist'][$i2]['IsWitholdingTax'] ='';
$data['Data'][$i]['invoicelist'][$i2]['ResponseId'] ='';
$data['Data'][$i]['invoicelist'][$i2]['Status'] ='';
$data['Data'][$i]['invoicelist'][$i2]['Tax'] ='';
$data['Data'][$i]['invoicelist'][$i2]['Vat'] ='';
$data['Data'][$i]['invoicelist'][$i2]['UpdateBy'] ='';
$data['Data'][$i]['invoicelist'][$i2]['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;
$data['sql'] = $view;
return $data;
}
public function LoadQuotationListCk($request){
$count = "
* FROM (
SELECT q.*,c.NamesName as CustomerName,c.NamesCode as CustomerCode
,(SELECT CountryName FROM ct_country WHERE CountryId=q.CountryId) as Country
,CASE WHEN q.Status = 1 THEN 'Draft' ELSE 'Approved' END as StatusText
,(SELECT SUM(Amount) FROM ct_quotation_item WHERE QuotationId = q.QuotationId) as Amount
,c.PostalAddress as Address,ct.Department
,(SELECT COUNT(*) FROM ct_case WHERE QuotationId = q.QuotationId) + (SELECT COUNT(*) FROM ct_case_quotation WHERE QuotationId = q.QuotationId) as IsEdit
";
$name_table = "
ct_quotation q
INNER JOIN t_names_mas c ON q.CustomerId=c.NamesId
INNER JOIN ct_master_case_type ct ON ct.CaseTypeId = q.CaseTypeId
) A
";
$search = "1=1 ";
$order='';
if(@$request['CustomerId']>0){
$cusId = $request['CustomerId'];
$search = $search ." AND CustomerId = '".$cusId."'";
}
if(@$request['QuotationNumber']!=''){
$quotationNo = $request['QuotationNumber'];
$search = $search ." AND QuotationNo LIKE '%".$quotationNo."%'";
}
if(@$request['CustomerName']!=''){
$customerName = $request['CustomerName'];
$search = $search ." AND CustomerName LIKE '%".$customerName."%'";
//$search = $search ." OR c.NamesCode = '".$customerName."'";
}
if(@$request['CaseNumber']!=''){
$caseNo = $request['CaseNumber'];
$search = $search ." AND (SELECT Count(*) From ct_case cc WHERE cc.QuotationId=A.QuotationId AND cc.CaseNumber LIKE '%".$caseNo."%') > 0";
}
if(@$request['Department']!=''){
$department = $request['Department'];
$search = $search ." AND Department = '".$department."'";
}
if(@$request['QuotationType']>0){
$quotationType = $request['QuotationType'];
$search = $search ." AND QuotationType LIKE '".$quotationType."'";
}
if(@$request['Status']>0){
$status = $request['Status'];
$search = $search ." AND Status LIKE '".$status."'";
}
if(@$request['QuotationId']!=""){
$search .= " AND QuotationId = '".$request['QuotationId']."'";
}
if($request['OrderDirection']!=""){
$order = " ORDER BY `A`.`".$request['OrderBy']."` ".$request['OrderDirection'];
}
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search, 'order' => $order);
if($request['PageSize']!=''){
$page_number = $request['PageNumber'] - 1;
$max_rows = $request['PageSize'];
$list_count = array('table'=>$name_table,'count'=>$count,'where'=>$search); //,'order' => 'ORDER BY `QuotationId` DESC '
$start_count = $page_number * $max_rows;
$view_count = $this->view($list_count);
$result_count = $this->q_re($view_count);
$respons_count = $this->q_nr($result_count);
$respons_count_num = mysqli_num_rows($result_count);
$respons_pages = ceil($respons_count/$max_rows)-1;
$data_c['page_number'] = $page_number;
$data_c['respons_pages'] = $respons_pages;
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search,'order'=> $order);
//, 'limit'=> "$start_count,$max_rows"
}
$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]['Address'] =$row['Address'];
$data['Data'][$i]['Amount'] = floatval($row['Amount']);
$data['Data'][$i]['CaseTypeId'] =$row['CaseTypeId'];
$data['Data'][$i]['Condition'] =$row['Condition'];
$data['Data'][$i]['ContactPerson'] =$row['ContactPerson'];
$data['Data'][$i]['Country'] =$row['Country'];
$data['Data'][$i]['CountryId'] =$row['CountryId'];
$data['Data'][$i]['CreateBy'] =$row['CreateBy'];
$data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];
$data['Data'][$i]['CreditTerms'] =$row['CreditTerms'];
$data['Data'][$i]['CreditType'] =$row['CreditType'];
$data['Data'][$i]['Currency'] =$row['Currency'];
$data['Data'][$i]['CustomerCode'] =$row['CustomerCode'];
$data['Data'][$i]['CustomerId'] =$row['CustomerId'];
$data['Data'][$i]['CustomerName'] =$row['CustomerName'];
$data['Data'][$i]['Del'] =$row['Del'];
$data['Data'][$i]['Department'] =$row['Department'];
$data['Data'][$i]['InterQuantity'] =$row['InterQuantity'];
$data['Data'][$i]['IsEdit'] =$row['IsEdit'];
$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]['StatusText'] =$row['StatusText'];
$data['Data'][$i]['UpdateBy'] =$row['UpdateBy'];
$data['Data'][$i]['UpdateDateTime'] =$row['UpdateDateTime'];
$data['Data'][$i]['Vat'] =$row['Vat'];
$i2 = 0;
$secrch_inv = "QuotationId = '".$row['QuotationId']."' AND Del = '0'";
$order_inv = "ORDER BY InvoiceId ASC";
$sql_inv = array('table'=>'ct_invoice','where'=>$secrch_inv,'order'=>$order_inv);
$view_inv = $this->view($sql_inv);
$result_inv = $this->q_re($view_inv);
$respons_count_inv = $this->q_nr($result_inv);
if($respons_count_inv > 0){
while ($row_inv = $this->q_ro($result_inv)) {
$data['Data'][$i]['invoicelist'][$i2]['BillDetail'] =$row_inv['BillDetail'];
$data['Data'][$i]['invoicelist'][$i2]['CreateBy'] =$row_inv['CreateBy'];
$data['Data'][$i]['invoicelist'][$i2]['CreateDateTime'] =$row_inv['CreateDateTime'];
$data['Data'][$i]['invoicelist'][$i2]['Del'] =$row_inv['Del'];
$data['Data'][$i]['invoicelist'][$i2]['InvoiceId'] =$row_inv['InvoiceId'];
$data['Data'][$i]['invoicelist'][$i2]['InvoiceNo'] =$row_inv['InvoiceNo'];
$data['Data'][$i]['invoicelist'][$i2]['IsCo'] =$row_inv['IsCo'];
$data['Data'][$i]['invoicelist'][$i2]['IsConsultService'] =$row_inv['IsConsultService'];
$data['Data'][$i]['invoicelist'][$i2]['IsExcludeVat'] =$row_inv['IsExcludeVat'];
$data['Data'][$i]['invoicelist'][$i2]['IsWitholdingTax'] =$row_inv['IsWitholdingTax'];
$data['Data'][$i]['invoicelist'][$i2]['ResponseId'] =$row_inv['ResponseId'];
$data['Data'][$i]['invoicelist'][$i2]['Status'] =$row_inv['Status'];
$data['Data'][$i]['invoicelist'][$i2]['Tax'] =$row_inv['Tax'];
$data['Data'][$i]['invoicelist'][$i2]['Vat'] =$row_inv['Vat'];
$data['Data'][$i]['invoicelist'][$i2]['UpdateBy'] =$row_inv['UpdateBy'];
$data['Data'][$i]['invoicelist'][$i2]['UpdateDateTime'] =$row_inv['UpdateDateTime'];
$i2++;
}
}else {
$data['Data'][$i]['invoicelist'][$i2]['BillDetail'] ='';
$data['Data'][$i]['invoicelist'][$i2]['CreateBy'] ='';
$data['Data'][$i]['invoicelist'][$i2]['CreateDateTime'] ='';
$data['Data'][$i]['invoicelist'][$i2]['Del'] ='';
$data['Data'][$i]['invoicelist'][$i2]['InvoiceId'] ='';
$data['Data'][$i]['invoicelist'][$i2]['InvoiceNo'] ='';
$data['Data'][$i]['invoicelist'][$i2]['IsCo'] ='';
$data['Data'][$i]['invoicelist'][$i2]['IsConsultService'] ='';
$data['Data'][$i]['invoicelist'][$i2]['IsExcludeVat'] ='';
$data['Data'][$i]['invoicelist'][$i2]['IsWitholdingTax'] ='';
$data['Data'][$i]['invoicelist'][$i2]['ResponseId'] ='';
$data['Data'][$i]['invoicelist'][$i2]['Status'] ='';
$data['Data'][$i]['invoicelist'][$i2]['Tax'] ='';
$data['Data'][$i]['invoicelist'][$i2]['Vat'] ='';
$data['Data'][$i]['invoicelist'][$i2]['UpdateBy'] ='';
$data['Data'][$i]['invoicelist'][$i2]['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;
$data['sql'] = $view;
return $data;
}
public function LoadQuotationCase($request){
$count = "
* FROM (
SELECT q.*,c.NamesName as CustomerName,c.NamesCode as CustomerCode
,(SELECT CountryName FROM ct_country WHERE CountryId=q.CountryId) as Country
,CASE WHEN q.Status = 1 THEN 'Draft' ELSE 'Approved' END as StatusText
,(SELECT SUM(Amount) FROM ct_quotation_item WHERE QuotationId = q.QuotationId) as Amount
";
if($request['QuotationType']==2){
$count .= ",(SELECT SUM(LocalQuantity) FROM ct_case WHERE QuotationId = q.QuotationId AND ".date("m")." = MONTH(CreateDateTime) AND ".date("Y")." = YEAR(CreateDateTime)) as CurrentLocalOfMonth";
$count .= ",(SELECT SUM(InterQuantity) FROM ct_case WHERE QuotationId = q.QuotationId AND ".date("m")." = MONTH(CreateDateTime) AND ".date("Y")." = YEAR(CreateDateTime)) as CurrentInterOfMonth";
$count .= ",(DATEDIFF(day,GETDATE(),q.RetainerEnd)) as DayExpired";
}
$count .= ",c.PostalAddress as Address,ct.Department";
$name_table = "
ct_quotation q
INNER JOIN t_names_mas c ON q.CustomerId=c.NamesId
INNER JOIN ct_master_case_type ct ON ct.CaseTypeId = q.CaseTypeId
) A
";
$search = "Del = '0' ";
if($request['CustomerId']!=''){
$custId =$request['CustomerId'];
$search .= " AND CustomerId = '".$custId."'";
}
if($request['CustomerCode']!=''){
$cusCode =$request['CustomerCode'];
$search .= " AND CustomerCode LIKE '%".$cusCode."%'";
}
if($request['CustomerName']!=''){
$cusName =$request['CustomerName'];
$search .= " AND CustomerName LIKE '%".$cusName."%'";
}
if($request['QuotationNumber']!=''){
$quotationNo =$request['QuotationNumber'];
$search .= "AND QuotationNo LIKE '%".$quotationNo."%'";
}
if($request['CaseNumber']!=''){
$caseNo =$request['CaseNumber'];
$search .= " AND (SELECT Count(*) From ct_case cc WHERE cc.QuotationId=A.QuotationId AND cc.CaseNumber LIKE '%".$caseNo."%') > 0";
}
if($request['Department']!=''){
$department =$request['Department'];
$search .= " AND Department = '".$department."'";
}
if($request['CustomerId']>0){
$cusId =$request['CustomerId'];
$search .= " AND CustomerId = '".$cusId."'";
}
if($request['QuotationType']>0){
$quotationType =$request['QuotationType'];
$search .= " AND QuotationType ='".$quotationType."'";
}
if($request['QuotationType']>0){
$quotationType =$request['QuotationType'];
$search .= " AND QuotationType ='".$quotationType."'";
if($request['QuotationType']==1){
$search .= " AND (SELECT Count(*) FROM ct_case WHERE QuotationId = A.QuotationId) = 0 ";
$search .= " AND (SELECT Count(*) FROM ct_case_quotation WHERE QuotationId = A.QuotationId) = 0";
}
}
if($request['Status']>0){
$status =$request['Status'];
$search .= " AND Status LIKE '".$status."'";
}
if($request['OrderDirection']!=''){
$search .= " Order By '". $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]['Address'] =$row['Address'];
$data['Data'][$i]['Amount'] =$row['Amount'];
$data['Data'][$i]['CaseTypeId'] =$row['CaseTypeId'];
$data['Data'][$i]['Condition'] =$row['Condition'];
$data['Data'][$i]['ContactPerson'] =$row['ContactPerson'];
$data['Data'][$i]['Country'] =$row['Country'];
$data['Data'][$i]['CountryId'] =$row['CountryId'];
$data['Data'][$i]['CreateBy'] =$row['CreateBy'];
$data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];
$data['Data'][$i]['CreditTerms'] =$row['CreditTerms'];
$data['Data'][$i]['CreditType'] =$row['CreditType'];
$data['Data'][$i]['Currency'] =$row['Currency'];
$data['Data'][$i]['CustomerCode'] =$row['CustomerCode'];
$data['Data'][$i]['CustomerId'] =$row['CustomerId'];
$data['Data'][$i]['CustomerName'] =$row['CustomerName'];
$data['Data'][$i]['Del'] =$row['Del'];
$data['Data'][$i]['Department'] =$row['Department'];
$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]['StatusText'] =$row['StatusText'];
$data['Data'][$i]['UpdateBy'] =$row['UpdateBy'];
$data['Data'][$i]['UpdateDateTime'] =$row['UpdateDateTime'];
$data['Data'][$i]['Vat'] =$row['Vat'];
$i++;
}
}else {
$data['Data'] ='';
}
$data['PageNumber'] = $request['PageNumber'];
$data['OrderBy'] = $request['OrderBy'];
$data['OrderDirection'] = $request['OrderDirection'];
$data['PageSize'] = $request['PageSize'];
$data['sql'] = $view;
$data['numrows'] = $respons_count_num;
$data['TotalRecords'] = $respons_count_num;
return $data;
}
public function LoadCountry($request){
$name_table = "ct_country";
$secrch = "Del=0";
$order = "";
if(@$require['CountryId']!=''){
$secrch .= "CountryId='".$request['CountryId']."'";
}
//$count = "";
$sql = array('table'=>$name_table,'where'=>$secrch,'order'=>$order);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;
while ($row = $this->q_ro($result)) {
$data[$i]['CountryId'] = $row['CountryId'];
$data[$i]['CountryCode'] = $row['CountryCode'];
$data[$i]['Status'] = $row['Status'];
$data[$i]['Del'] = $row['Del'];
$i++;
}
return $data;
}
public function Edit($Id){
$name_table = "ct_quotation";
$secrch = "QuotationId='".$Id."'";
$order = "";
//$count = "";
$sql = array('table'=>$name_table,'where'=>$secrch,'order'=>$order);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;
while ($row = $this->q_ro($result)) {
$data[$i]['QuotationId'] = $row['QuotationId'];
$data[$i]['QuotationNo'] = $row['QuotationNo'];
$data[$i]['CountryId'] = $row['CountryId'];
$data[$i]['CustomerId'] = $row['CustomerId'];
$data[$i]['QuotationType'] = $row['QuotationType'];
$data[$i]['RetainerStart'] = $row['RetainerStart'];
$data[$i]['RetainerEnd'] = $row['RetainerEnd'];
$data[$i]['Condition'] = $row['Condition'];
$data[$i]['CaseTypeId'] = $row['CaseTypeId'];
$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]['Status'] = $row['Status'];
$data[$i]['CreateBy'] = $row['CreateBy'];
$data[$i]['CreateDateTime'] = $row['CreateDateTime'];
$data[$i]['UpdateBy'] = $row['UpdateBy'];
$data[$i]['UpdateDateTime'] = $row['UpdateDateTime'];
$data[$i]['Currency'] = $row['Currency'];
$data[$i]['LocalQuantity'] = $row['LocalQuantity'];
$data[$i]['InterQuantity'] = $row['InterQuantity'];
$i++;
}
return $data;
}
public function LoadItems($Id){
$name_table = "ct_quotation_item";
$secrch = "QuotationId='".$Id."'";
$order = "";
//$count = "";
$sql = array('table'=>$name_table,'where'=>$secrch,'order'=>$order);
$view = $this->view($sql);
$result = $this->q_re($view);
$respons_count = $this->q_nr($result);
$i=0;
if(@$respons_count>0){
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['QuotationItemId'] = $row['QuotationItemId'];
$data['Data'][$i]['QuotationId'] = $row['QuotationId'];
$data['Data'][$i]['Description'] = $row['Description'];
$data['Data'][$i]['Quantity'] = $row['Quantity'];
$data['Data'][$i]['UnitPrice'] = floatval($row['UnitPrice']);
$data['Data'][$i]['Amount'] = floatval($row['Amount']);
$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]['IsExcludeVat'] = $row['IsExcludeVat'];
$i++;
}
}else {
$data['Data'] = "";
}
return $data;
}
public function LoadDocuments($Id){
$name_table = "ct_quotation_document";
$secrch = "QuotationId='".$Id."'";
$order = "";
//$count = "";
$sql = array('table'=>$name_table,'where'=>$secrch,'order'=>$order);
$view = $this->view($sql);
$result = $this->q_re($view);
$respons_count = $this->q_nr($result);
$i=0;
if(@$respons_count>0){
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['QuotationDocumentId'] = $row['QuotationDocumentId'];
$data['Data'][$i]['QuotationId'] = $row['QuotationId'];
$data['Data'][$i]['DocType'] = $row['DocType'];
$data['Data'][$i]['FilePath'] = $row['FilePath'];
$data['Data'][$i]['ApproveFilePath'] = $row['ApproveFilePath'];
$data['Data'][$i]['Status'] = $row['Status'];
$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++;
}
}else {
$data['Data'] = "";
}
return $data;
}
public function LoadPayments($Id){
$name_table = "ct_quotation_payment_terms";
$secrch = "QuotationId='".$Id."'";
$order = "";
//$count = "";
$sql = array('table'=>$name_table,'where'=>$secrch,'order'=>$order);
$view = $this->view($sql);
$result = $this->q_re($view);
$respons_count = $this->q_nr($result);
$i=0;
if($respons_count>0){
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['QuotationPaymentTermId'] = $row['QuotationPaymentTermId'];
$data['Data'][$i]['Phase'] = $row['Phase'];
$data['Data'][$i]['Detail'] = $row['Detail'];
$data['Data'][$i]['Amount'] = floatval($row['Amount']);
$data['Data'][$i]['Status'] = $row['Status'];
$data['Data'][$i]['IsEdit'] = 1;
$secrch_inv = "q.QuotationPaymentTermId = '".$row['QuotationPaymentTermId']."' AND Del = '0'";
$count_inv = "c.InvoiceId,c.InvoiceNo";
$order_inv = "ORDER BY InvoiceId ASC";
$table_inv = "ct_invoice_item q
INNER JOIN ct_invoice c ON q.InvoiceId=c.InvoiceId";
$sql_inv = array('table'=>$table_inv,'where'=>$secrch_inv,'order'=>$order_inv,'count'=>$count_inv);
$view_inv = $this->view($sql_inv);
$result_inv = $this->q_re($view_inv);
$respons_count_inv = $this->q_nr($result_inv);
$i2=0;
if($respons_count_inv>0){
while ($row_inv = $this->q_ro($result_inv)) {
$data['Data'][$i]['invoicelist'][$i2]['InvoiceId'] =$row_inv['InvoiceId'];
$data['Data'][$i]['invoicelist'][$i2]['InvoiceNo'] =$row_inv['InvoiceNo'];
}
}else{
$data['Data'][$i]['invoicelist'][$i2]['InvoiceId'] ='';
$data['Data'][$i]['invoicelist'][$i2]['InvoiceNo'] ='';
}
$i++;
}
}else {
$data['Data'] = "";
}
$data['sql'] = $view_inv;
return $data;
}
public function LoadRelatedCase($request)
{
$name_table = "ct_case c";
$search = "1=1 AND (c.QuotationId = '".$request['QuotationId']."' OR (SELECT Count(*) FROM ct_case_quotation WHERE c.CaseId = CaseId AND QuotationId = '".$request['QuotationId']."') > 0) ";
$order = "";
$count = "
c.CaseId,c.CaseNumber,'' as DueDate
,(SELECT CaseTypeName FROM ct_master_case_type WHERE CaseTypeId = c.CaseTypeId) as CaseType
,(SELECT NamesName FROM t_names_mas WHERE NamesId = c.CustomerId) as CustomerName
,'' as LastEvent
";
$sql = array('table'=>$name_table,'count'=>$count,'where'=>$search,'order'=>$order);
if($request['PageSize']!=''){
$page_number = $request['PageNumber'] - 1;
$max_rows = $request['PageSize'];
$list_count = array('table'=>$name_table,'count'=>$count,'where'=>$search); //,'order' => 'ORDER BY `QuotationId` DESC '
$start_count = $page_number * $max_rows;
$view_count = $this->view($list_count);
$result_count = $this->q_re($view_count);
$respons_count = $this->q_nr($result_count);
$respons_count_num = mysqli_num_rows($result_count);
$respons_pages = ceil($respons_count/$max_rows)-1;
$data_c['page_number'] = $page_number;
$data_c['respons_pages'] = $respons_pages;
$sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search, 'limit'=> "$start_count,$max_rows",'order'=> $order);
}
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;
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'];
$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 LoadCustomerDetail($Id)
{
$name_table = "t_names_mas T2";
$secrch = "1=1 AND T2.NamesId = '".$Id."'";
$order = "";
$count = "
distinct T2.NamesId as custId,T2.NamesName as custName, T2.NamesCode as custCode,T2.PostalAddress as address,T2.TaxID as taxId
";
$sql = array('table'=>$name_table,'where'=>$secrch,'count'=>$count,'order'=>$order);
$view = $this->view($sql);
$result = $this->q_re($view);
$i=0;
while ($row = $this->q_ro($result)) {
$data['Data'][$i]['QuotationPaymentTermId'] = $row['QuotationPaymentTermId'];
$data['Data'][$i]['Phase'] = $row['Phase'];
$data['Data'][$i]['Detail'] = $row['Detail'];
$data['Data'][$i]['Amount'] = floatval($row['Amount']);
$data['Data'][$i]['Status'] = $row['Status'];
$data['Data'][$i]['IsEdit'] = 1;
$i++;
}
return $view;
}
}
?>