private function updatedocstr($iid, $rid, $ty) { $sql = "SELECT a.* , p.id AS p_id " . " FROM tmp_docd a LEFT JOIN product_id p ON a.cnom=p.ckey AND p.db=1" . " WHERE a.user="******" AND a.ckey=" . $iid; //.$value['id']; $dets = Yii::app()->db->createCommand($sql)->query(); if (count($dets) > 0) { $id = 0; foreach ($dets as $value) { if (!($value['p_id'] == null)) { if ($ty == 0) { $expd = new Expd(); $expd->exp = $rid; //$group->id; } else { $expd = new Invd(); $expd->inv = $rid; } $expd->id = ++$id; $expd->product = $value['p_id']; $expd->amount = $value['bqua']; $expd->price = $value['bpri']; $expd->vat = $value['bvat']; $expd->total = $value['bsum']; $expd->save(); } } } }