PHP Podetail::find Examples

Example #1

File: PurchaseOrderController.php Project: adem-team/advanced

 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]);
 }