public function saleClientCookie($client_id) { //$this->clearAll(); $sale_item = SaleClientCookie::model()->findAll('client_id=:client_id', array(':client_id' => $client_id)); if (isset($sale_item)) { foreach ($sale_item as $row) { $this->addItem($row->item_id, $row->quantity, $row->discount_amount, $row->price, $row->description); } } }
public function saveSaleCookie($items, $customer_id, $employee_id, $comment) { if (count($items) == 0 && !isset($customer_id)) { return -1; } $transaction = Yii::app()->db->beginTransaction(); try { $query = "delete from sale_client_cookie where client_id=:client_id"; $command = Yii::app()->db->createCommand($query); $command->bindParam(":client_id", $customer_id, PDO::PARAM_INT); $command->execute(); // Saving sale item to sale_item table foreach ($items as $line => $item) { if (substr($item['discount'], 0, 1) == '$') { $discount_amount = substr($item['discount'], 1); $discount_type = '$'; } else { $discount_amount = $item['discount']; $discount_type = '%'; } $cur_item_info = Item::model()->findbyPk($item['item_id']); //Saving frequency buy items for client $sale_client_cookie = new SaleClientCookie(); $sale_client_cookie->client_id = $customer_id; $sale_client_cookie->item_id = $item['item_id']; $sale_client_cookie->quantity = $item['quantity']; $sale_client_cookie->cost_price = $cur_item_info->cost_price; $sale_client_cookie->unit_price = $cur_item_info->unit_price; $sale_client_cookie->price = $item['price']; // The exact selling price $sale_client_cookie->discount_amount = $discount_amount == null ? 0 : $discount_amount; $sale_client_cookie->discount_type = $discount_type; $sale_client_cookie->save(); } $transaction->commit(); } catch (Exception $e) { //$sale_id=$e; //Uncomment here for debuggin purpose $transaction->rollback(); return -1; } //return $sale_id; }