/**
* @return \yii\db\ActiveQuery
*/
public function getSalesDtls()
{
return $this->hasMany(SalesDtl::className(), ['id_warehouse' => 'id_warehouse']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getSalesDtls()
{
return $this->hasMany(SalesDtl::className(), ['id_product' => 'id_product']);
}
/**
*
* @param SalesHdr $model
* @return array
*/
protected function saveSales($model)
{
$post = Yii::$app->request->post();
$details = $model->salesDtls;
$success = false;
if ($model->load($post)) {
$transaction = Yii::$app->db->beginTransaction();
try {
$formName = (new SalesDtl())->formName();
$postDetails = empty($post[$formName]) ? [] : $post[$formName];
if ($postDetails === []) {
throw new Exception('Detail tidak boleh kosong');
}
$objs = [];
foreach ($details as $detail) {
$objs[$detail->id_sales_dtl] = $detail;
}
if ($model->save()) {
$success = true;
$id_hdr = $model->id_sales;
$id_whse = $model->id_warehouse;
$details = [];
foreach ($postDetails as $dataDetail) {
$id_dtl = $dataDetail['id_sales_dtl'];
if (isset($objs[$id_dtl])) {
$detail = $objs[$id_dtl];
unset($objs[$id_dtl]);
} else {
$detail = new SalesDtl();
}
$detail->setAttributes($dataDetail);
$detail->id_sales = $id_hdr;
$detail->id_warehouse = $id_whse;
if ($detail->idCogs) {
$detail->cogs = $detail->idCogs->cogs;
} else {
$detail->cogs = 0;
}
if (!$detail->save()) {
$success = false;
$model->addError('', implode("\n", $detail->firstErrors));
break;
}
$details[] = $detail;
}
if ($success && count($objs) > 0) {
$success = SalesDtl::deleteAll(['id_sales_dtl' => array_keys($objs)]);
}
}
if ($success) {
$transaction->commit();
} else {
$transaction->rollBack();
}
} catch (Exception $exc) {
$success = false;
$model->addError('', $exc->getMessage());
$transaction->rollBack();
}
if (!$success) {
$details = [];
foreach ($postDetails as $value) {
$detail = new SalesDtl();
$detail->setAttributes($value);
$details[] = $detail;
}
}
}
return [$details, $success];
}
/**
* @return \yii\db\ActiveQuery
*/
public function getSalesDtls()
{
return $this->hasMany(SalesDtl::className(), ['id_sales' => 'id_sales'])->with('idCogs');
}