public function getSumReport($data, $row) { $criteria = new CDbCriteria(); $criteria->select = 'SUM(bill_sale_detail_price * bill_sale_detail_qty) AS SUM_ALL'; $criteria->join = 'INNER JOIN tb_bill_sale_detail AS c ON c.bill_id = t.bill_sale_id'; $criteria->condition = 'bill_sale_pay_date IS NULL'; $criteria->condition = 'bill_sale_drop_bill_date IS NULL'; $criteria->compare("t.member_id", $data->member_id); $criteria->group = 't.member_id'; $result = BillSale::model()->find($criteria); return number_format($result->SUM_ALL, 2); }
$product_qty = number_format($product_qty); $vat = number_format($bill_sale_detail_price_vat, 2); $product = Product::model()->findByAttributes(array('product_code' => $product_code)); $weight = $product->weight; $sum_weight += $weight; if (empty($weight)) { $weight = 0; } $content .= "\r\n <tr>\r\n <td class='cell' style='text-align: center'>{$i}</td>\r\n <td class='cell' width='180px'>{$product_code}</td>\r\n <td class='cell'>{$product_name}</td>\r\n <td class='cell' style='text-align: right'>{$weight}</td>\r\n <td class='cell' style='text-align: right'>{$product_price}</td>\r\n <td class='cell' style='text-align: right'>{$product_qty}</td>\r\n <td class='cell' style='text-align: right'>{$price_per_row}</td>\r\n </tr>"; $i++; } // table footer $sum_qty = number_format($sum_qty); $sum_price = number_format($sum); $content .= "\r\n </tbody>\r\n <tfoot>\r\n <tr>\r\n <td class='text bold'>รวม</td>\r\n <td></td>\r\n <td></td>\r\n <td></td>\r\n <td></td>\r\n <td class='cell cell-footer'>{$sum_qty}</td>\r\n <td class='cell cell-footer'>{$sum_price}</td>\r\n </tr>\r\n </tfoot>\r\n </table>\r\n <br />"; $billSale = BillSale::model()->findByPk($billSaleId); $billConfig = BillConfig::model()->find(); $vat_type = $billSale->vat_type; $out_vat = $billSale->out_vat * 1; $total_price = $sum; if ($vat_type == 'out') { $total_price = $sum + $out_vat; } $money = number_format($out_vat, 2); $money_add = number_format($total_price, 2); $bonus_price = number_format($billSale->bonus_price, 2); $total_pay = number_format($total_price - $billSale->bonus_price, 2); $money_add_total = $total_price - $out_vat; $money_add_total = number_format($money_add_total, 2); $content .= "<table width='300px'>"; if ($billSale->bill_sale_vat == 'vat') {
function actionDialogBillAddVat($bill_sale_id) { $org = Organization::model()->find(); $billSale = BillSale::model()->findByAttributes(array('bill_sale_id' => (int) $bill_sale_id)); $this->render('//Dialog/DialogBillAddVat', array('org' => $org, 'billSale' => $billSale)); }
echo $priceTotal; ?> " 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>
public function actionSendFromQuotationBillToBillSale() { $this->checkLogin(); $quotation_id = (int) $_POST['quotation_id']; $vat_price = $_POST['vat_price']; $quotation = Quotation::model()->findByPk((int) $quotation_id); if (!empty($quotation)) { $billSale = BillSale::model()->findByAttributes(array('quotation_id' => $quotation_id)); if (empty($billSale)) { $user_id = Yii::app()->request->cookies['user_id']->value; $user = User::model()->findByPk($user_id); // // create bill_sale // $billSale = new BillSale(); $billSale->quotation_id = $quotation_id; $billSale->sale_type = 'sale'; $billSale->bill_sale_pay_date = new CDbExpression('NOW()'); $billSale->branch_id = $user->branch_id; $billSale->user_id = $user_id; $billSale->member_id = 0; $billSale->bill_sale_status = 'pay'; $billSale->bill_sale_created_date = new CDbExpression('NOW()'); if ($quotation->vat > 0) { $vat_price = str_replace(',', '', $vat_price); $billSale->vat_type = 'out'; $billSale->out_vat = $vat_price; $billSale->bill_sale_vat = 'vat'; $billSale->vat_percen = $quotation->vat; } if ($billSale->save()) { // // read from quotation and transfer to tb_bill_sale_detail // $quotationDetails = QuotationDetail::model()->findAllByAttributes(array('quotation_id' => $quotation_id)); foreach ($quotationDetails as $quotationDetail) { $billSaleDetail = new BillSaleDetail(); $billSaleDetail->bill_id = $billSale->bill_sale_id; $billSaleDetail->bill_sale_detail_barcode = $quotationDetail->barcode; $billSaleDetail->bill_sale_detail_price = $quotationDetail->old_price; $billSaleDetail->bill_sale_detail_qty = $quotationDetail->qty; $billSaleDetail->sub = $quotationDetail->sub; $billSaleDetail->quotation_detail_id = $quotationDetail->id; $billSaleDetail->save(); } echo $billSale->bill_sale_id; } } else { echo $billSale->bill_sale_id; } } }
$configSoftware = ConfigSoftware::model()->find(); $bill_drop_title = $configSoftware->bill_drop_title; // header $header = "\n <div class='header-text bold'>{$bill_drop_title}</div>\n <div class='header-text'>{$td_logo} {$org->org_name} {$org->org_name_eng}</div>\n <div class='header-text'>เลขประจำตัวผู้เสียภาษี: {$org->org_tax_code} เบอร์โทร; {$org->org_tel}</div>\n <div class='header-text'>{$org->org_address_1} {$org->org_address_2}</div>\n <div class='header-text'>{$org->org_address_3} {$org->org_address_4}</div>\n <div class='header-text'>วันที่: {$date_time}</div>\n <br />\n "; // to member $header .= "\n <div class='row'>\n <span>ลูกค้า: {$member->member_name}</span>\n <span> </span>\n <span>เบอร์โทร: {$member->member_tel}</span>\n </div>\n <div class='row'>ที่อยู่: {$member->member_address}</div>\n <br />"; // content $content = "\n <table width='100%' cellspacing='0' cellpadding='0'>\n <thead>\n <tr>\n <td class='cell-header' style='text-align: center'>ลำดับ</td>\n <td class='cell-header' style='text-align: center'>วันที่ออกใบส่งสินค้า</td>\n <td class='cell-header' style='text-align: right'>เลขที่บิล</td>\n <td class='cell-header' style='text-align: right'>จำนวนเงิน</td>\n </tr>\n </thead>\n <tbody>"; $sum = 0; $i = 1; // table body $bill_sale_ids = Yii::app()->session['bill_sale_ids']; $criteria = new CDbCriteria(); $criteria->order = 'bill_sale_id DESC'; $criteria->addInCondition('bill_sale_id', $bill_sale_ids); $billSales = BillSale::model()->findAll($criteria); foreach ($billSales as $r) { $bill_sale_id = $r->bill_sale_id; $product_price = $r->getSum(false); $sum += $product_price; $label_price = number_format($product_price); $content .= "\n <tr>\n <td class='cell' style='text-align: center' width='30px'>{$i}</td>\n <td class='cell' style='text-aligh: center'>{$r->bill_sale_created_date}</td>\n <td class='cell' style='text-align: right' width='100px'>{$bill_sale_id}</td>\n <td class='cell' style='text-align: right' width='100px'>{$label_price}</td>\n </tr>"; $i++; } // table footer $sum = number_format($sum); $content .= "\n </tbody>\n <tfoot>\n <tr>\n <td class='text bold'>รวม</td>\n <td></td>\n <td></td>\n <td class='cell-footer'>{$sum}</td>\n </tr>\n </tfoot>\n </table>\n <br />"; // footer $footer = "\n <table width='100%'>\n <tr>\n <td class='text' style='text-align: center; font-weight: bold'>พนักงานขาย</td>\n <td class='text' style='text-align: center; font-weight: bold'>ผู้รับสินค้า</td>\n </tr>\n <tr>\n <td align='center'>\n <span class='blank-row'>\n \n \n \n </span>\n </td>\n <td align='center'>\n <span class='blank-row'>\n \n \n \n </span>\n </td>\n </tr>\n </table>\n <br />"; $html = $header . $content . $footer; if (!empty($configSoftware->bill_drop_footer)) {
function actionDialogBillAddVat() { $org = Organization::model()->find(); $criteria = new CDbCriteria(); $criteria->order = 'bill_sale_id DESC'; $criteria->limit = 1; $criteria->compare('bill_sale_status', 'pay'); $billSale = BillSale::model()->find($criteria); $this->render('//Dialog/DialogBillAddVat', array('org' => $org, 'billSale' => $billSale)); }
public function actionClearBillSale() { $this->checkLogin(); BillSale::model()->deleteAll(); BillSaleDetail::model()->deleteAll(); $this->redirect(array("Basic/ManageBill")); }
public function actionArPay($bill_sale_id) { $billSale = BillSale::model()->findByPk((int) $bill_sale_id); $billSale->bill_sale_pay_date = new CDbExpression('NOW()'); $billSale->bill_sale_status = 'pay'; $billSale->save(); echo 'success'; }