public function loadModeldetail($id)
{
$model = Podetail::model()->findByPk((int) $id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
/**
* Lists all models.
*/
public function actionIndex()
{
parent::actionIndex();
$purchasingorg = new Purchasingorg('search');
$purchasingorg->unsetAttributes();
// clear any default values
if (isset($_GET['Purchasingorg'])) {
$purchasingorg->attributes = $_GET['Purchasingorg'];
}
$paymentmethod = new Paymentmethod('search');
$paymentmethod->unsetAttributes();
// clear any default values
if (isset($_GET['Paymentmethod'])) {
$paymentmethod->attributes = $_GET['Paymentmethod'];
}
$purchasinggroup = new Purchasinggroup('search');
$purchasinggroup->unsetAttributes();
// clear any default values
if (isset($_GET['Purchasinggroup'])) {
$purchasinggroup->attributes = $_GET['Purchasinggroup'];
}
$supplier = new Supplier('search');
$supplier->unsetAttributes();
// clear any default values
if (isset($_GET['Supplier'])) {
$supplier->attributes = $_GET['Supplier'];
}
$podetail = new Podetail('search');
$podetail->unsetAttributes();
// clear any default values
if (isset($_GET['Podetail'])) {
$podetail->attributes = $_GET['Podetail'];
}
$product = new Prmaterial('search');
$product->unsetAttributes();
// clear any default values
if (isset($_GET['Prmaterial'])) {
$product->attributes = $_GET['Prmaterial'];
}
$unitofmeasure = new Unitofmeasure('search');
$unitofmeasure->unsetAttributes();
// clear any default values
if (isset($_GET['Unitofmeasure'])) {
$unitofmeasure->attributes = $_GET['Unitofmeasure'];
}
$currency = new Currency('search');
$currency->unsetAttributes();
// clear any default values
if (isset($_GET['Currency'])) {
$currency->attributes = $_GET['Currency'];
}
$sloc = new Sloc('search');
$sloc->unsetAttributes();
// clear any default values
if (isset($_GET['Sloc'])) {
$sloc->attributes = $_GET['Sloc'];
}
$tax = new Tax('search');
$tax->unsetAttributes();
// clear any default values
if (isset($_GET['Tax'])) {
$tax->attributes = $_GET['Tax'];
}
$model = new Poheader('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['Poheader'])) {
$model->attributes = $_GET['Poheader'];
}
if (isset($_GET['pageSize'])) {
Yii::app()->user->setState('pageSize', (int) $_GET['pageSize']);
unset($_GET['pageSize']);
// would interfere with pager and repetitive page size change
}
$this->render('index', array('model' => $model, 'purchasingorg' => $purchasingorg, 'purchasinggroup' => $purchasinggroup, 'paymentmethod' => $paymentmethod, 'supplier' => $supplier, 'podetail' => $podetail, 'product' => $product, 'unitofmeasure' => $unitofmeasure, 'currency' => $currency, 'sloc' => $sloc, 'tax' => $tax, 'podetail' => $podetail));
}
public function actionDelpo($idpo, $kdpo)
{
$podet = Podetail::find()->where(['KD_PO' => $kdpo, 'ID' => $idpo])->one();
$po = Purchasedetail::find()->where(['KD_PO' => $kdpo, 'ID' => $podet->ID_DET_PO])->one();
$sisa = $po->QTY - $podet->QTY;
if ($sisa == '0') {
\Yii::$app->db_esm->createCommand()->update('p0002', ['QTY' => $sisa, 'STATUS' => '3'], "ID='{$po->ID}'")->execute();
} else {
\Yii::$app->db_esm->createCommand()->update('p0002', ['QTY' => $sisa], "ID='{$po->ID}'")->execute();
}
$podet->STATUS = '3';
$podet->save();
return $this->redirect(['create', 'kdpo' => $kdpo]);
}