public function search($input)
{
$query = PurchaseOrderDetail::query();
$columns = Schema::getColumnListing('purchaseOrderDetails');
$attributes = array();
foreach ($columns as $attribute) {
if (isset($input[$attribute]) and !empty($input[$attribute])) {
$query->where($attribute, $input[$attribute]);
$attributes[$attribute] = $input[$attribute];
} else {
$attributes[$attribute] = null;
}
}
return [$query->get(), $attributes];
}
/**
* Updates an existing PurchaseOrder model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id
* @return mixed
*/
public function actionUpdate($id)
{
$model = $this->findModel($id);
$updatePODetail = new PurchaseOrderDetail();
$poDetails = PurchaseOrderDetail::find()->where(['purchaseorderdetail_purchaseorderid' => $id])->orderBy('purchaseorderdetail_id')->all();
$product = Product::find()->where(['product_type' => 'p'])->orderBy('product_id')->all();
$service = Product::find()->where(['product_type' => 's'])->orderBy('product_id')->all();
$customer = Customer::find()->orderBy('customer_name')->all();
$company = Company::findOne(1);
$customerID = $model->purchaseorder_customerid;
$thisCustomer = Customer::findOne($customerID);
$uid = Yii::$app->user->identity->user_id;
$uname = Yii::$app->user->identity->user_name;
if (isset($_POST['description'])) {
$poDetailList = $_POST['description'];
$customer_id = $_POST['customer-list'];
$po_id = $_POST['po_id'];
$po_no = $_POST['po_no'];
$po_date = $_POST['po_date'];
$productType = $_POST['productType'];
$qty = $_POST['qty'];
$unit = $_POST['unit'];
$cost = $_POST['cost'];
$hidden_price = $_POST['hidden_price'];
$hidden_gst = $_POST['hidden_gst'];
$hidden_tax_code = $_POST['hidden_tax_code'];
$hidden_tax_rate = $_POST['hidden_tax_rate'];
$hidden_price_gst = $_POST['hidden_price_gst'];
$hidden_total = $_POST['hidden_total'];
$hidden_gsttotal = $_POST['hidden_gsttotal'];
$hidden_gstpricetotal = $_POST['hidden_gstpricetotal'];
$hidden_id = $_POST['hidden_id'];
$hidden_poid = $_POST['hidden_poid'];
$hidden_product_name = $_POST['hidden_product_name'];
if ($updateQPODetail != NULL) {
$updateQPODetail = $this->findModel($id);
$updateQPODetail->purchaseorder_id = $po_id;
$updateQPODetail->purchaseorder_no = $po_no;
$updateQPODetail->purchaseorder_date = $po_date;
$updateQPODetail->purchaseorder_date_transaction = $po_date;
$updateQPODetail->purchaseorder_date_delete = $po_date;
$updateQPODetail->purchaseorder_customerid = $customer_id;
$updateQPODetail->purchaseorder_supplierid = 1;
$updateQPODetail->purchaseorder_supplier_quotation_no = 11;
$updateQPODetail->purchaseorder_createid = $uid;
$updateQPODetail->purchaseorder_createname = $uname;
$updateQPODetail->purchaseorder_remark = "lol";
$updateQPODetail->purchaseorder_system = "y";
$updateQPODetail->purchaseorder_partno = "y";
$updateQPODetail->purchaseorder_charge = 123;
$updateQPODetail->purchaseorder_update_stock_status = "y";
$updateQPODetail->purchaseorder_status = "y";
$updateQPODetail->purchaseorder_tax_label = "lol";
$updateQPODetail->purchaseorder_tax_percent = 1;
$updateQPODetail->purchaseorder_tax_amount = 100;
$updateQPODetail->purchaseorder_printed_status = "y";
$updateQPODetail->purchaseorder_revision = 1;
$updateQPODetail->purchaseorder_parts_total = $hidden_total;
$updateQPODetail->purchaseorder_deleteid = 1;
$updateQPODetail->purchaseorder_payment_status = "y";
$updateQPODetail->purchaseorder_no_user_format = "lol";
$updateQPODetail->purchaseorder_auto_generate = "y";
$updateQPODetail->purchaseorder_creditorid = 1;
$updateQPODetail->purchaseorder_purchase_return = 123;
$updateQPODetail->purchaseorder_payment_paid_thus_far = 123;
$updateQPODetail->purchaseorder_outstanding_amount = 123;
$updateQPODetail->purchaseorder_projectid = 1;
$updateQPODetail->purchaseorder_gst_payable = $hidden_gsttotal;
$updateQPODetail->purchaseorder_total_amount = $hidden_gstpricetotal;
$updateQPODetail->save();
foreach ($poDetailList as $key => $n) {
if ($hidden_poid[$key] != $id || $hidden_poid[$key] == NULL || $hidden_poid[$key] == '') {
if ($unit[$key] == NULL) {
$unit[$key] = "-";
}
$newPODetail = new PurchaseOrderDetail();
$newPODetail->purchaseorderdetail_purchaseorderid = $po_id;
$newPODetail->purchaseorderdetail_productid = $n;
$newPODetail->purchaseorderdetail_partno = "lol";
$newPODetail->purchaseorderdetail_productname = $hidden_product_name[$key];
$newPODetail->purchaseorderdetail_unit = $qty[$key];
$newPODetail->purchaseorderdetail_unitname = $unit[$key];
$newPODetail->purchaseorderdetail_product_cost = $cost[$key];
$newPODetail->purchaseorderdetail_price = $hidden_price[$key];
$newPODetail->purchaseorderdetail_unitsent = 0;
$newPODetail->purchaseorderdetail_status = "y";
$newPODetail->purchaseorderdetail_tax_code = $hidden_tax_code[$key];
$newPODetail->purchaseorderdetail_tax_rate = $hidden_tax_rate[$key];
$newPODetail->purchaseorderdetail_tax_amount = $hidden_gst[$key];
$newPODetail->purchaseorderdetail_total_amount = $hidden_price_gst[$key];
$newPODetail->purchaseorderdetail_gst_status = 1;
$newPODetail->save();
} elseif ($hidden_poid[$key] == $id) {
$poid = $hidden_id[$key];
$updatePODetail = PurchaseOrderDetail::findOne($poid);
$updatePODetail->purchaseorderdetail_purchaseorderid = $po_id;
$updatePODetail->purchaseorderdetail_productid = $n;
$updatePODetail->purchaseorderdetail_partno = "lol";
$updatePODetail->purchaseorderdetail_productname = $hidden_product_name[$key];
$updatePODetail->purchaseorderdetail_unit = $qty[$key];
$updatePODetail->purchaseorderdetail_unitname = $unit[$key];
$updatePODetail->purchaseorderdetail_product_cost = $cost[$key];
$updatePODetail->purchaseorderdetail_price = $hidden_price[$key];
$updatePODetail->purchaseorderdetail_unitsent = 0;
$updatePODetail->purchaseorderdetail_status = "y";
$updatePODetail->purchaseorderdetail_tax_code = $hidden_tax_code[$key];
$updatePODetail->purchaseorderdetail_tax_rate = $hidden_tax_rate[$key];
$updatePODetail->purchaseorderdetail_tax_amount = $hidden_gst[$key];
$updatePODetail->purchaseorderdetail_total_amount = $hidden_price_gst[$key];
$updatePODetail->purchaseorderdetail_gst_status = 1;
$updatePODetail->save();
}
}
}
}
if ($updatePODetail->save()) {
return $this->redirect(['index']);
} elseif ($updatePODetail->load(Yii::$app->request->post())) {
return $this->redirect(['index']);
} else {
return $this->render('update', ['model' => $model, 'poDetails' => $poDetails, 'product' => $product, 'service' => $service, 'customer' => $customer, 'thisCustomer' => $thisCustomer, 'company' => $company]);
}
}
