public function actionDialogBillSendProduct($bill_type = "send")
{
// organization data
$org = Organization::model()->find();
// bill_sale data
$billSale = BillSale::model()->find(array('limit' => 1, 'order' => 'bill_sale_id DESC'));
// bill_sale_detail data
$billSaleDetail = BillSaleDetail::model()->findAll(array('condition' => "bill_id = {$billSale->bill_sale_id}"));
// member
if ($billSale->member_id > 0) {
$criteria = new CDbCriteria();
$criteria->compare('member_code', @$billSale->member->member_code);
$member = Member::model()->find($criteria);
} else {
$member = null;
}
$this->renderPartial('//Report/BillSendProduct', array('org' => $org, 'billSale' => $billSale, 'billSaleDetail' => $billSaleDetail, 'member' => $member, 'billType' => $bill_type));
}
"
style="text-align: right; width: 150px" />
</div>
<!-- end form -->
</form>
</div>
</div>
</div>
<!-- รายการขายล่าสุด -->
<?php
$user_id = Yii::app()->request->cookies['user_id']->value;
$lastBillSale = BillSale::model()->find(array('limit' => 1, 'order' => 'bill_sale_id DESC', 'condition' => 'user_id = :user_id', 'params' => array('user_id' => $user_id)));
if (!empty($lastBillSale)) {
$lastBillSaleDetails = BillSaleDetail::model()->findAllByAttributes(array('bill_id' => $lastBillSale->bill_sale_id));
}
?>
<?php
if (!empty($lastBillSale)) {
?>
<div class="panel panel-primary" style="margin-top: 15px">
<div class="panel-heading">
<div class="pull-left">
<i class="glyphicon glyphicon-ok"></i>
<?php
echo Yii::t('lang', 'recent_sales');
?>
</div>
<div class="pull-right">
<i class="glyphicon glyphicon-cog"></i>
$billConfig = BillConfig::model()->find();
// style
$style = "\n\t<style>\n\t\t.text {\n\t\t\tfont-size: 13px;\n\t\t}\n\t\t.bold {\n\t\t\tfont-weight: bold;\n\t\t}\n\t\t.red {\n\t\t\tfont-color: #FF0000;\n\t\t}\n\t\t.cell {\n\t\t\tpadding: 5px;\n\t\t\tfont-size: 13px;\n";
if ($billConfig->bill_add_show_line == 'yes') {
$style .= "border-bottom: #cccccc 1px solid;";
}
$style .= "\n\t\t}\n\t\t.cell-header {\n\t\t\ttext-align: center;\n\t\t\tbackground: #cccccc;\n\t\t}\n\t\t.right {\n\t\t\ttext-align: right;\n\t\t}\n\t\t.center {\n\t\t\ttext-align: center;\n\t\t}\n\t\t.cell-footer {\n\t\t\tfont-size: 13px;\n\t\t}\n\t</style>\n";
// header text
$header_text = "\n\t<div>\n\t\t<div class='center bold'>\n\t\t\tใบกำกับภาษี\n\t\t</div>\n\t</div>\n\t<div>\n\t\t<span class='text'>\n\t\t\tเลขที่: <span class='bold'>{$billSale->bill_sale_id}</span>\n\t\t\tวันที่: <span class='bold red'>{$nowThai}</span>\n\t\t</span>\n\t</div>\n\t<div>\n\t\t<span class='text'>\n\t\t\tร้าน: \n\t\t\t<span class='bold red'>{$org->org_name}</span>\n\t\t</span>\n\t\t<span class='text'>\n\t\t\tสาขา:\n\t\t\t<span class='bold red'>{$billSale->branch->branch_name}</span>\n\t\t</span>\n\t</div>\n\t<div>\n\t\t<span class='text'>\n\t\t\t<div>{$org->org_address_1}</div>\n\t\t\t<div>{$org->org_address_2}</div>\n\t\t\t<div>{$org->org_address_3}</div>\n\t\t\t<div>{$org->org_address_4}</div>\n\t\t\t<div>\n\t\t\t\t<span style='padding-right: 40px'>\n\t\t\t\t\tเลขประจำตัวผู้เสียภาษี: {$org->org_tax_code}\n\t\t\t\t</span>\n\t\t\t\t\n\t\t\t\t<span style='padding-right: 40px'>\n\t\t\t\t\tโทรศัพท์: {$org->org_tel}\t\t\t\t\n\t\t\t\t</span>\n\t\t\t\t\n\t\t\t\t<span>\n\t\t\t\t\tแฟกซ์: {$org->org_fax}\n\t\t\t\t</span>\n\t\t\t</div>\t\n\t\t</span>\n\t</div>\n\t<div>\n\t\t<span class='text'>\n\t\t\t<div class=''>\n\t\t\t\t<strong>ลูกค้า</strong>\n\t\t\t\t<span>\n\t\t\t\t\t{$billSale->member->member_code} \n\t\t\t\t\t{$billSale->member->member_name}\n\t\t\t\t</span>\n\n\t\t\t\t<strong>เบอร์โทร: </strong>\n\t\t\t\t<span>{$billSale->member->member_tel}</span>\n\n\t\t\t\t<strong>เลขประจำตัวผู้เสียภาษี: </strong>\n\t\t\t\t<span>{$billSale->member->tax_code}</span>\n\t\t\t</div>\n\t\t\t<div>{$billSale->member->member_address}</div>\n\t\t</span>\n\t</div>\n";
// body
$body_text = "\n\t<table width='100%'>\n\t\t<thead>\n\t\t\t<tr>\n\t\t\t\t<td class='cell cell-header' width='40px'>ลำดับ</td>\n\t\t\t\t<td class='cell cell-header' width='100px'>รหัสสินค้า</td>\n\t\t\t\t<td class='cell cell-header'>ชื่อ</td>\n\t\t\t\t<td class='cell cell-header' width='50px'>จำนวน</td>\n\t\t\t\t<td class='cell cell-header' width='110px'>ราคาต่อหน่วย</td>\n\t\t\t\t<td class='cell cell-header' width='70px'>ราคารวม</td>\n\t\t\t</tr>\n\t\t</thead>\n";
$n = 1;
$sumPrice = 0;
$criteria = new CDbCriteria();
$criteria->compare('bill_id', $billSale->bill_sale_id);
$billSaleDetails = BillSaleDetail::model()->findAll($criteria);
foreach ($billSaleDetails as $billSaleDetail) {
$qty = $billSaleDetail->bill_sale_detail_qty;
$price = $billSaleDetail->bill_sale_detail_price;
$totalPricePerRow = $qty * $price;
$sumPrice += $totalPricePerRow;
$totalPricePerRowOutput = number_format($totalPricePerRow);
$product_name = $billSaleDetail->product->product_name;
$product_code = $billSaleDetail->bill_sale_detail_barcode;
// find name of product
if (empty($product_name)) {
$productPrice = BarcodePrice::model()->findByPk($product_code);
$fk = $productPrice->barcode_fk;
$productRelate = Product::model()->findByAttributes(array('product_code' => $fk));
$product_name = $productRelate->product_name . " ({$productPrice->name})";
}
public function actionClearBillSale()
{
$this->checkLogin();
BillSale::model()->deleteAll();
BillSaleDetail::model()->deleteAll();
$this->redirect(array("Basic/ManageBill"));
}
public function actionArDetail($bill_sale_id)
{
$billSaleDetails = BillSaleDetail::model()->findAll(array('condition' => "bill_id = :bill_sale_id", 'order' => 'bill_sale_detail_id DESC', 'params' => array('bill_sale_id' => (int) Util::input($bill_sale_id))));
$this->renderPartial('//Report/ArDetail', array('billSaleDetails' => $billSaleDetails, 'n' => 1, 'bill_sale_id' => $bill_sale_id, 'sum' => 0));
}
