| Server IP : 172.67.216.113 / 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/Quotation/ |
Upload File : |
<div class="card mb-4">
<div class="card-header">
ระบุข้อมูล
<?php
$arrayName = array( 'LoadCountry' => '');
$data_Country = $quotation_db->LoadCountry($arrayName);
if(@$_GET['Type']=='Edit'){
$data_iTem = $quotation_db->Edit($_GET['Id']);
$data_locadiTem = $quotation_db->LoadItems($data_iTem[0]['QuotationId']);
$data_locaddoc = $quotation_db->LoadDocuments($data_iTem[0]['QuotationId']);
$data_locadpay = $quotation_db->LoadPayments($data_iTem[0]['QuotationId']);
$data_locadcde = $quotation_db->LoadCustomerDetail($data_iTem[0]['QuotationId']);
$PageSize = 10;
$PageNumber = 1;
if(isset($_GET['PageNumber'])){$PageNumber = $_GET['PageNumber'];}
$arrayName2 = array(
'QuotationId' => @$data_iTem[0]['QuotationId'],
'Keyword' => @$_GET['Keyword'],
'PageNumber' => @$PageNumber,
'page' => @$PageNumber,
'OrderBy' => '',
'OrderDirection' => '',
'PageSize' => @$PageSize,
);
$data_locadcase = $quotation_db->LoadRelatedCase($arrayName2);
$Id= @$_REQUEST['CustomerId'];
$code= @$_REQUEST['CustomerCode'];
$name= @$_REQUEST['CustomerName'];
$arrayName3 = array(
'CustomerId' => $Id,
'CustomerCode' => $code,
'CustomerName' => $name,
'Keyword' => @$_REQUEST['Keyword'],
'PageNumber' => @$_REQUEST['PageNumber'],
'page' => @$_REQUEST['page'],
'OrderBy' => @$_REQUEST['OrderBy'],
'OrderDirection' => @$_REQUEST['OrderDirection'],
'PageSize' => @$_REQUEST['PageSize'],
);
$data_locadcus = $customer_db->LoadCustomer($arrayName3);
$data_locadcus_a = $customer_db->LoadCustomerAutoComplete($data_locadcus['Data'][0]['custCode']);
$Id= @$data_iTem[0]['CustomerId'];
$code= @$_REQUEST['CustomerCode'];
$name= @$_REQUEST['CustomerName'];
$arrayName4 = array(
'CustomerId' => $Id,
'CustomerCode' => $code,
'CustomerName' => $name,
'Keyword' => @$_REQUEST['Keyword'],
'PageNumber' => @$_REQUEST['PageNumber'],
'page' => @$_REQUEST['page'],
'OrderBy' => @$_REQUEST['OrderBy'],
'OrderDirection' => @$_REQUEST['OrderDirection'],
'PageSize' => @$_REQUEST['PageSize'],
);
$data_locadcus2 = $customer_db->LoadCustomer($arrayName4);
$retainerStart = explode(" ",$data_iTem[0]['RetainerStart']);
$retainerEnd = explode(" ",$data_iTem[0]['RetainerEnd']);
/*
echo "<pre>";
print_r($retainerStart[0]);
echo "</pre>";
*/
}
?>
</div>
<div class="card-body">
<div class="form-group row">
<label for="" class="col-sm-2 col-form-label">Country<sup class="text-danger">*</sup></label>
<div class="col-sm-4">
<select class="form-control" name="CountryId" onchange="loadCaseType(this.value)">
<option value="">Select Country</option>
<?php foreach ($data_Country as $key => $value) { ?>
<option value="<?php echo $value['CountryId']; ?>" <?php echo ($value['CountryId']==$data_iTem[0]['CountryId'])? "selected" : ""; ?>><?php echo $value['CountryCode']; ?></option>
<?php } ?>
</select>
</div>
<?php if(@$_GET['Type']=='Edit'){ ?>
<div class="col-sm-2">
<label for="" class="col-form-label">Quotation No.<sup class="text-danger">*</sup></label>
</div>
<div class="col-sm-4">
<input class="form-control" value="<?php echo $data_iTem[0]['QuotationNo']; ?>" readonly/>
</div>
<?php } ?>
</div>
<div class="form-group row">
<label for="" class="col-sm-2 col-form-label">Customer <sup class="text-danger">*</sup></label>
<div class="col-sm-4">
<input class="form-control" style="width:80% !important;display:inline;" readonly id="txt_cus_code"/>
<a href="#" data-toggle="modal" data-target="#customerModal" class="btn btn-primary">
<span class="icon text-white-50">
<i class="fas fa-search"></i>
</span>
</a>
<input type="hidden" name="CustomerId" id="hd_cus_id" value="" />
</div>
<label for="" class="col-sm-2 col-form-label">Quotation Type <sup class="text-danger">*</sup></label>
<div class="col-sm-4">
<select class="form-control" id="CBO_QUOTATION_TYPE" name="QuotationType">
<option value="1" <?php echo ($data_iTem[0]['QuotationType']==1)?"selected":""; ?> >One Time</option>
<option value="2" <?php echo ($data_iTem[0]['QuotationType']==2)?"selected":""; ?>>Retainer</option>
</select>
</div>
</div>
<div class="form-group row" id="RETAINER_DURATION" style="display:none;">
<label for="" class="col-sm-2 col-form-label">Retainer Start <sup class="text-danger">*</sup></label>
<div class="col-sm-4">
<div class="input-group date" id="dte_retain_start">
<input type="text" class="form-control" name="RetainerStart" id="txt_retain_start" autocomplete="off">
<div class="input-group-append"><span class="input-group-text"><i class="fa fa-calendar"></i></span></div>
</div>
</div>
<label for="" class="col-sm-2 col-form-label">Retainer End <sup class="text-danger">*</sup></label>
<div class="col-sm-4">
<div class="input-group date" id="dte_retain_end">
<input type="text" class="form-control" name="RetainerEnd" id="txt_retain_end" autocomplete="off"><div class="input-group-append"><span class="input-group-text"><i class="fa fa-calendar"></i></span></div>
</div>
</div>
<label for="" class="col-sm-2 col-form-label mt-2">Condition <sup class="text-danger">*</sup></label>
<div class="col-sm-10 mt-2">
<input class="form-control" name="Condition" type="text" value="<?php echo $data_iTem[0]['Condition']; ?>" />
</div>
<label for="" class="col-sm-2 col-form-label mt-2">Local Quantity <sup class="text-danger">*</sup></label>
<div class="col-sm-4 mt-2">
<input class="form-control" name="LocalQuantity" type="number" step="1" min="0" value="<?php echo $data_iTem[0]['LocalQuantity']; ?>" />
</div>
<label for="" class="col-sm-2 col-form-label mt-2">Inter Quantity <sup class="text-danger">*</sup></label>
<div class="col-sm-4 mt-2">
<input class="form-control" name="InterQuantity" type="number" step="1" min="0" value="<?php echo $data_iTem[0]['InterQuantity']; ?>" />
</div>
</div>
<div class="form-group row">
<label for="" class="col-sm-2 col-form-label">Company Name <sup class="text-danger">*</sup></label>
<div class="col-sm-4">
<input class="form-control" readonly id="txt_cus_name" value="<?php echo $data_locadcus2['Data'][0]['custName'] ; ?>" />
</div>
<label for="" class="col-sm-2 col-form-label">TAX ID<sup class="text-danger">*</sup></label>
<div class="col-sm-4">
<input class="form-control" id="txt_cus_tax_id" value="<?php echo $data_locadcus2['Data'][0]['taxId'] ; ?>" readonly />
</div>
</div>
<div class="form-group row">
<label for="" class="col-sm-2 col-form-label">Address <sup class="text-danger">*</sup></label>
<div class="col-sm-4">
<input class="form-control" id="txt_cus_address" value="<?php echo $data_locadcus2['Data'][0]['address'] ; ?>" readonly />
</div>
<label for="" class="col-sm-2 col-form-label">Billing Address<sup class="text-danger">*</sup></label>
<div class="col-sm-4">
<input class="form-control" id="txt_cus_billing_address" value="<?php echo $data_locadcus2['Data'][0]['address'] ; ?>" readonly/>
</div>
</div>
<div class="form-group row">
<label for="" class="col-sm-2 col-form-label">Credit Type <sup class="text-danger">*</sup></label>
<div class="col-sm-2">
<select class="form-control" name="CreditType" >
<option value="1" <?php echo ($data_iTem[0]['CreditType']==1)? "selected":""; ?>>Cash</option>
<option value="2" <?php echo ($data_iTem[0]['CreditType']==2)? "selected":""; ?>>Credit</option>
</select>
</div>
<label for="" class="col-sm-2 col-form-labe text-rightl">Credit Terms: <sup class="text-danger">*</sup></label>
<div class="col-sm-2">
<input class="form-control" type="number" value="<?php echo ($data_iTem[0]['CreditTerms']!='')? $data_iTem[0]['CreditTerms']:""; ?>" name="CreditTerms" />
</div>
<label for="" class="col-sm-2 col-form-label text-right">VAT %: <sup class="text-danger">*</sup></label>
<div class="col-sm-2">
<input class="form-control" type="number" value="<?php echo $data_iTem[0]['Vat']; ?>" name="Vat" id="txt_vat" />
</div>
</div>
<div class="form-group row">
<label for="" class="col-sm-2 col-form-label">Case Type <sup class="text-danger">*</sup></label>
<div class="col-sm-4">
<select class="form-control" id="ddl_case_type" name="CaseTypeId">
<option value="">Select Case Type</option>
</select>
</div>
<?php if(@$_GET['Type']=='Edit'){ ?>
<label for="" class="col-sm-2 col-form-label">Status <sup class="text-danger">*</sup></label>
<div class="col-sm-4">
<select class="form-control" id="ddl_status" name="Status">
<option value="1" <?php echo ($data_iTem[0]['Status']==1)?"selected" : ""; ?>>Draft</option>
<option value="2" <?php echo ($data_iTem[0]['Status']==2)?"selected" : ""; ?>>Approved</option>
</select>
</div>
<?php } ?>
</div>
<div class="form-group row">
<label for="" class="col-sm-2 col-form-label">Contact Person <sup class="text-danger">*</sup></label>
<div class="col-sm-4">
<input type="text" name="ContactPerson" class="form-control" value="<?php echo $data_iTem[0]['ContactPerson']; ?>" />
</div>
<label for="" class="col-sm-2 col-form-label">Currency <sup class="text-danger">*</sup></label>
<div class="col-sm-4">
<select class="form-control" name="Currency">
<option value="">Select Currency</option>
<option value="thb" <?php echo ($data_iTem[0]['Currency']=='thb')? "selected":""; ?>>THB</option>
<option value="usd" <?php echo ($data_iTem[0]['Currency']=='usd')? "selected":""; ?>>USD</option>
</select>
</div>
</div>
<!--
<div class="form-group row">
<label for="" class="col-sm-2 col-form-label">Contact Person<sup class="text-danger">*</sup></label>
<div class="col-sm-4">
<input class="form-control" style="background-color:lightgray; width:80% !important;display:inline;" />
<a href="#" class="btn btn-primary">
<span class="icon text-white-50">
<i class="fas fa-search"></i>
</span>
</a>
</div>
<label for="" class="col-sm-2 col-form-label">Billing Person <sup class="text-danger">*</sup></label>
<div class="col-sm-4">
<input class="form-control" style="background-color:lightgray; width:80% !important;display:inline;" />
<a href="#" class="btn btn-primary">
<span class="icon text-white-50">
<i class="fas fa-search"></i>
</span>
</a>
</div>
</div>
-->
<!-- Modal Customer-->
<div class="modal fade" id="customerModal" tabindex="-1" role="dialog" aria-labelledby="customerModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="customerModalLabel">Select Customer</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<div id="customer_pagination">
<div class="mb-2">
<div class="form-group row">
<div class="col-md-2">
Customer:
</div>
<div class="col-md-3">
<input type="text" class="form-control" id="customer-filter" name="CustomerName" value="" autocomplete="off" />
<input type="hidden" value="" name="CustomerId2" id="hd-customer-id" />
</div>
<div class="col-sm-4">
<button class="btn btn-success d-block" type="button" onclick="loadCustomer(true)">Search</button>
</div>
</div>
</div>
<div class="table-loader text-center" style="display:none;">
<div class="overlay">
<i class="fas fa-3x fa-spinner fa-pulse"></i>
</div>
</div>
<div class="row">
<table class="table table-striped table-bordered ">
<thead>
<tr>
<th>Customer Code.</th>
<th>Customer Name</th>
<th style="width:120px;">Action</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
<br /><br />
</div>
<div class="supplierPager">
<div class="row">
<div class="col-md-6">
<input type="hidden" class="page" value="1" />
<input type="hidden" class="page-size" value="10" />
<input type="hidden" class="numrows" value="0" />
<input type="hidden" class="params" value="" />
แสดงรายการ <span class="start-record"></span> ถึง <span class="end-record"></span> จากทั้งหมด <span class="total-record"></span> รายการ
</div>
<div class="col-md-6 text-right pagination-zone">
</div>
</div>
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
<!--<button type="button" class="btn btn-primary">Save changes</button>-->
</div>
</div>
</div>
</div>
<?php if(@$_GET['Type']=='Edit'){ ?>
<nav>
<div class="nav nav-tabs" id="nav-tab" role="tablist">
<a class="nav-item nav-link active" id="nav-home-tab" data-toggle="tab" href="#nav-home" role="tab" aria-controls="nav-home" aria-selected="true">Item</a>
<a class="nav-item nav-link" id="nav-profile-tab" data-toggle="tab" href="#nav-profile" role="tab" aria-controls="nav-profile" aria-selected="false">Quotation Document</a>
<a class="nav-item nav-link" id="nav-contact-tab" data-toggle="tab" href="#nav-contact" role="tab" aria-controls="nav-contact" aria-selected="false">Payment Terms</a>
<a class="nav-item nav-link" id="nav-contact-tab" data-toggle="tab" href="#nav-related" role="tab" aria-controls="nav-contact" aria-selected="false">Ref. Case</a>
</div>
</nav>
<div class="tab-content" id="nav-tabContent">
<div class="tab-pane fade show active" id="nav-home" role="tabpanel" aria-labelledby="nav-home-tab">
<br />
<p>
<a class="btn btn-danger" href="#" data-toggle="modal" data-target="#itemModal"><i class="fas fa-plus-square"></i> Add Item</a>
<b class="lbl-related-item"></b>
</p>
<table class="table table-bordered" id="item-table">
<thead>
<tr>
<td>No.</td>
<td>Description</td>
<td>Quantity</td>
<td>Unit Price</td>
<td>Amount</td>
<td>Exclude Vat</td>
<td>Action</td>
<tr>
</thead>
<tbody>
<!--<tr>
<td>1</td>
<td>จดทะเบียนจัดตั้งบริษัท</td>
<td>1</td>
<td class="text-right">7,200.00</td>
<td class="text-right">7,200.00</td>
<td>
<a class="btn btn-info btn-sm" href=""><i class="fas fa-edit"></i>Edit</a>
<a class="btn btn-danger btn-sm" href=""><i class="fas fa-trash"></i>Delete</a>
</td>
</tr>
<tr>
<td>2</td>
<td>จัดทำสัญญาจ้างงานสำหรับพนักงาน</td>
<td>1</td>
<td class="text-right">5,000.00</td>
<td class="text-right">5,000.00</td>
<td>
<a class="btn btn-info btn-sm" href=""><i class="fas fa-edit"></i>Edit</a>
<a class="btn btn-danger btn-sm" href=""><i class="fas fa-trash"></i>Delete</a>
</td>
</tr>
-->
</tbody>
<tfoot>
<tr>
<td></td>
<td></td>
<td></td>
<td>VAT</td>
<td class="text-right" id="lbl_vat"></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td>TOTAL</td>
<td class="text-right" id="lbl_total"></td>
<td></td>
</tr>
</tfoot>
</table>
</div>
<div class="tab-pane fade" id="nav-profile" role="tabpanel" aria-labelledby="nav-profile-tab">
<br />
<p>
<a class="btn btn-danger" href="#" data-target="#documentModal" data-toggle="modal"><i class="fas fa-plus-square"></i> เพิ่มเอกสาร</a>
<div class="text-right"> <a href="../Template/PP2020289_บริษัท XYZ จำกัด สัญญาผู้ถือหุ้น.docx" target="_blank">Download Quotation Template</a></div>
</p>
<table class="table table-bordered" id="document-table">
<thead>
<tr>
<td>No.</td>
<td>Description</td>
<td>File</td>
<td>Status</td>
<td>Action</td>
<tr>
</thead>
<tbody>
</tbody>
</table>
</div>
<div class="tab-pane fade" id="nav-contact" role="tabpanel" aria-labelledby="nav-contact-tab">
<br />
<p>
<a class="btn btn-danger" href="#" data-toggle="modal" data-target="#paymentModal"><i class="fas fa-plus-square"></i>Add Payment Terms</a>
<b class="lbl-related-item"></b>
</p>
<table class="table table-bordered" id="payment-table">
<thead>
<tr>
<td>No.</td>
<td>Phase</td>
<td>Details</td>
<td>Amount</td>
<td>Status</td>
<td>InvoiceNo</td>
<td>Action</td>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
<div id="nav-related" class="tab-pane p-2 fade">
<div id="related_pagination" style="position:relative;">
<div class="table-loader text-center" style="display:none;">
<div class="overlay">
<i class="fas fa-3x fa-spinner fa-pulse"></i>
</div>
</div>
<table class="table table-hover table-bordered ">
<thead>
<tr>
<td>Case No.</td>
<td>Due Date</td>
<td>Case Type</td>
</tr>
</thead>
<tbody>
</tbody>
</table>
<br /><br />
<div class="supplierPager">
<div class="row">
<div class="col-md-6">
<input type="hidden" class="page" value="1" />
<input type="hidden" class="page-size" value="10" />
<input type="hidden" class="numrows" value="0" />
<input type="hidden" class="orderBy" value="" />
<input type="hidden" class="orderDirection" value="" />
<input type="hidden" class="params" value="" />
แสดงรายการ <span class="start-record"></span> ถึง <span class="end-record"></span> จากทั้งหมด <span class="total-record"></span> รายการ
</div>
<div class="col-md-6 text-right pagination-zone">
</div>
</div>
</div>
</div>
</div>
</div>
<?php } ?>
</div>
</div>