public function getSaleItem($sale_id)
 {
     $model = SaleSuspendedItem::model()->findAll('sale_id=:saleId', array(':saleId' => $sale_id));
     return $model;
 }
 public function copyEntireSuspendSale($sale_id)
 {
     $this->clearAll();
     $sale = SaleSuspended::model()->findbyPk($sale_id);
     $sale_item = SaleSuspendedItem::model()->getSaleItem($sale_id);
     $payments = SaleSuspendedPayment::model()->getPayment($sale_id);
     foreach ($sale_item as $row) {
         if ($row->discount_type == '$') {
             $discount_amount = $row->discount_type . $row->discount_amount;
         } else {
             $discount_amount = $row->discount_amount;
         }
         $this->addItem($row->item_id, $row->quantity, $discount_amount, $row->price, $row->description);
     }
     foreach ($payments as $row) {
         $this->addPayment($row->payment_type, $row->payment_amount);
     }
     $this->setCustomer($sale->client_id);
     $this->setComment($sale->remark);
 }
 public function saveSale($items, $payments, $customer_id, $employee_id, $sub_total, $comment)
 {
     if (count($items) == 0) {
         return -1;
     }
     $model = new SaleSuspended();
     $payment_types = '';
     //$error='';
     foreach ($payments as $payment_id => $payment) {
         $payment_types = $payment_types . $payment['payment_type'] . ': ' . $payment['payment_amount'] . '<br />';
     }
     $transaction = $model->dbConnection->beginTransaction();
     try {
         $model->sale_time = date('Y-m-d H:i:s');
         $model->client_id = $customer_id;
         $model->employee_id = $employee_id;
         $model->payment_type = $payment_types;
         $model->remark = $comment;
         $model->sub_total = $sub_total;
         if ($model->save()) {
             $sale_id = $model->id;
             // Saving payment items to sale_payment table
             foreach ($payments as $payment) {
                 $sale_payment = new SaleSuspendedPayment();
                 $sale_payment->sale_id = $sale_id;
                 $sale_payment->payment_type = $payment['payment_type'];
                 $sale_payment->payment_amount = $payment['payment_amount'];
                 $sale_payment->save();
             }
             // Saving sale item to sale_item table
             foreach ($items as $line => $item) {
                 $cur_item_info = Item::model()->findbyPk($item['item_id']);
                 $sale_item = new SaleSuspendedItem();
                 if (substr($item['discount'], 0, 1) == '$') {
                     $discount_amount = substr($item['discount'], 1);
                     $discount_type = '$';
                 } else {
                     $discount_amount = $item['discount'];
                     $discount_type = '%';
                 }
                 $sale_item->sale_id = $sale_id;
                 $sale_item->item_id = $item['item_id'];
                 $sale_item->line = $line;
                 $sale_item->quantity = $item['quantity'];
                 $sale_item->cost_price = $cur_item_info->cost_price;
                 $sale_item->unit_price = $cur_item_info->unit_price;
                 $sale_item->price = $item['price'];
                 // The exact selling price
                 $sale_item->discount_amount = $discount_amount == null ? 0 : $discount_amount;
                 $sale_item->discount_type = $discount_type;
                 if (!$sale_item->save()) {
                     $transaction->rollback();
                     return -1;
                 }
             }
             $transaction->commit();
         }
     } catch (Exception $e) {
         $transaction->rollback();
         return -1;
         //return $e;
     }
     return $sale_id;
 }