function calculateQuotationSubtotal($id)
{
// get quotatin items
$quotation_line_items = LbQuotationItem::model()->getquotationItems($id, self::LB_QUERY_RETURN_TYPE_MODELS_ARRAY);
// calculate sub total
$subtotal = 0;
foreach ($quotation_line_items as $item) {
$subtotal += $item->lb_quotation_item_total;
}
$quotation_total = $this->model()->find('lb_quotation_id=' . $id);
$quotation_total->lb_quotation_subtotal = $subtotal;
$quotation_total->save();
}
public function actionAjaxCopyQuotation($id)
{
//Add thong tin quotation
$quo_new = new LbQuotation();
$quotation = LbQuotation::model()->findByPk($id);
$quo_new->lb_quotation_no = LbQuotation::model()->formatQuotationNextNumFormatted(0);
$quo_new->lb_quotation_date = date('Y-m-d');
$quo_new->lb_quotation_due_date = date('Y-m-d');
$quo_new->lb_quotation_status = LbQuotation::LB_QUOTATION_STATUS_CODE_DRAFT;
$quo_new->lb_company_id = $quotation->lb_company_id;
$quo_new->lb_company_address_id = $quotation->lb_company_address_id;
$quo_new->lb_quotation_customer_id = $quotation->lb_quotation_customer_id;
$quo_new->lb_quotation_customer_address_id = $quotation->lb_quotation_customer_address_id;
$quo_new->lb_quotation_attention_id = $quotation->lb_quotation_attention_id;
$quo_new->lb_quotation_internal_note = $quotation->lb_quotation_internal_note;
$quo_new->lb_quotation_subject = $quotation->lb_quotation_subject;
$quo_new->lb_quotation_note = $quotation->lb_quotation_note;
$quo_new->lb_quotation_encode = LbQuotation::model()->setBase64_decodeQuotation();
if ($quo_new->save()) {
// Add thong tin tax
$quotation_tax_arr = LbQuotationTax::model()->getTaxQuotation($quotation->lb_record_primary_key);
foreach ($quotation_tax_arr->data as $tax_item) {
$quo_tax_new = new LbQuotationTax();
$quo_tax_new->lb_quotation_id = $quo_new->lb_record_primary_key;
$quo_tax_new->lb_quotation_tax_id = $tax_item->lb_quotation_tax_id;
$quo_tax_new->lb_quotation_tax_value = $tax_item->lb_quotation_tax_value;
$quo_tax_new->lb_quotation_tax_total = $tax_item->lb_quotation_tax_total;
$quo_tax_new->save();
}
//END
//Add thong tin discount
$quotation_discount_arr = LbQuotationDiscount::model()->getQuotationDiscounts($quotation->lb_record_primary_key);
foreach ($quotation_discount_arr->data as $discount_item) {
$quo_discount_new = new LbQuotationDiscount();
$quo_discount_new->lb_quotation_id = $quo_new->lb_record_primary_key;
$quo_discount_new->lb_quotation_discount_description = $discount_item->lb_quotation_discount_description;
$quo_discount_new->lb_quotation_discount_total = $discount_item->lb_quotation_discount_total;
$quo_discount_new->lb_quotation_discount_value = $discount_item->lb_quotation_discount_value;
$quo_discount_new->save();
}
//END
//Add Thong tin total
$quotation_total = LbQuotationTotal::model()->getQuotationTotal($quotation->lb_record_primary_key);
$quo_total_new = new LbQuotationTotal();
$quo_total_new->lb_quotation_id = $quo_new->lb_record_primary_key;
$quo_total_new->lb_quotation_subtotal = $quotation_total->lb_quotation_subtotal;
$quo_total_new->lb_quotation_total_after_discount = $quotation_total->lb_quotation_total_after_discount;
$quo_total_new->lb_quotation_total_after_tax = $quotation_total->lb_quotation_total_after_tax;
$quo_total_new->lb_quotation_total_after_total = $quotation_total->lb_quotation_total_after_total;
$quo_total_new->save();
//Add thong tin item
$quotation_item_arr = LbQuotationItem::model()->getquotationItems($quo_new->lb_record_primary_key);
foreach ($quotation_item_arr->data as $item) {
$quo_item_new = new LbQuotationItem();
$quo_item_new->lb_quotation_id = $quo_new->lb_record_primary_key;
$quo_item_new->lb_quotation_item_price = $item->lb_quotation_item_price;
$quo_item_new->lb_quotation_item_description = $item->lb_quotation_item_description;
$quo_item_new->lb_quotation_item_quantity = $item->lb_quotation_item_quantity;
$quo_item_new->lb_quotation_item_total = $item->lb_quotation_item_total;
$quo_item_new->save();
}
//END
}
}
function delete()
{
$quotation_id = $this->lb_record_primary_key;
$result = parent::delete();
if ($result) {
$quotation_item = LbQuotationItem::model()->getquotationItems($quotation_id);
foreach ($quotation_item->data as $item) {
$item->delete();
}
$quotation_discount = LbQuotationDiscount::model()->getQuotationDiscounts($quotation_id);
foreach ($quotation_discount->data as $discount) {
$discount->delete();
}
$quotation_tax = LbQuotationTax::model()->getTaxQuotation($quotation_id);
foreach ($quotation_tax->data as $tax) {
$tax->delete();
}
$quotation_total = LbQuotationTotal::model()->getQuotationTotal($quotation_id);
$quotation_total->delete();
}
}
