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;
}
}
}
public function actionQuotationDetailDelete($id)
{
$this->checkLogin();
QuotationDetail::model()->deleteByPk((int) $id);
}
