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