public static function changeschstatus($data) { $arr = PapQuotationScheme::model()->updateByPK($data['SchID'], array('Status' => $data['status'])); return $arr; }
public static function editscheme($params) { $organID = Yii::app()->user->getOrganID(); $time = $_SERVER['REQUEST_TIME']; //更新报价单 $quoID = self::ifsendquo(array('inqid' => $params['inqid'])); $quodatas['UpdateTime'] = $time; $quodatas['Title'] = $params['quoname']; $result = Yii::app()->papdb->createCommand()->update('pap_quotation', $quodatas, 'QuoID=' . $quoID); $SchID = $params['schid']; $datas['TotalFee'] = $params['quoprices']; $datas['GoodFee'] = $params['totalprices']; $datas['ShipFee'] = $params['shipprices']; $datas['ShipFee'] = $params['shipprices']; $datas['UpdateTime'] = $time; //保存附件 if ($params['fileurl']) { $datas['FileName'] = $params['filename']; $datas['FileUrl'] = $params['fileurl']; //删除之前附件 $quo_data = PapQuotationScheme::model()->findByPk($SchID); if (!empty($quo_data['FileName'])) { $ftp = new Ftp(); $res = $ftp->delete_file($quo_data->FileUrl); $ftp->close(); } } $result = Yii::app()->papdb->createCommand()->update('pap_quotation_scheme', $datas, 'SchID=:SchID', array(':SchID' => $SchID)); //获取商品信息 $goodsinfo = array(); $goodsids = explode(',', $params['quoids']); $goodsnum = explode(',', $params['quonum']); $goodsprice = explode(',', $params['quoprice']); //获取以前的商品信息 $oldgoodsinfo = PapQuotationGoods::model()->findAll('SchID=' . $SchID); $newgoodsinfo = array(); foreach ($goodsids as $key => $v) { if ($v) { $newgoodsinfo[$key]['GoodsID'] = $goodsids[$key]; $newgoodsinfo[$key]['Num'] = $goodsnum[$key]; $newgoodsinfo[$key]['Price'] = $goodsprice[$key]; $version = QuotationService::getgoodsversion($goodsids[$key]); $newgoodsinfo[$key]['Version'] = $version ? $version : 0; } } $insertid = array(); //将报价单商品插入报价单商品表中 if ($SchID) { foreach ($newgoodsinfo as $nkey => $new) { $newids[] = $new['GoodsID']; } if ($oldgoodsinfo) { foreach ($oldgoodsinfo as $okey => $old) { $oldids[] = $old['GoodsID']; } } else { $oldids = array(); } foreach ($oldids as $id) { if (!in_array($id, $newids)) { //删除商品 $delcount = Yii::app()->papdb->createCommand()->delete('pap_quotation_goods', 'SchID=:SchID and GoodsID=:goodsid', array(':SchID' => $SchID, ':goodsid' => $id)); } } foreach ($newids as $key => $id) { if (in_array($id, $oldids)) { //更新商品 $update['Num'] = $newgoodsinfo[$key]['Num']; $update['Price'] = $newgoodsinfo[$key]['Price']; $update['Version'] = $newgoodsinfo[$key]['Version']; $result = Yii::app()->papdb->createCommand()->update('pap_quotation_goods', $update, 'SchID=:SchID and GoodsID=:goodsid', array(':SchID' => $SchID, ':goodsid' => $id)); if ($result == 1) { $res = 1; } } else { //插入商品 $goodsdatas['SchID'] = $SchID; $goodsdatas['GoodsID'] = $newgoodsinfo[$key]['GoodsID']; $goodsdatas['Num'] = $newgoodsinfo[$key]['Num']; $goodsdatas['Price'] = $newgoodsinfo[$key]['Price']; $goodsdatas['Version'] = $newgoodsinfo[$key]['Version']; $result = Yii::app()->papdb->createCommand()->insert('pap_quotation_goods', $goodsdatas); $insertid[] = Yii::app()->papdb->getLastInsertID(); } } } if ($res = 1 || count($insertid) > 0 || $delcount > 0) { echo json_encode(array('count' => 1, 'schid' => $SchID, 'success' => true)); } else { echo json_encode(array('count' => 0)); } }
public static function cancelquo($params) { $quoid = $params['quoid']; if ($params['inqid']) { //查询询价单状态 $sta = 'select Status from pap_inquiry where InquiryID=' . $params['inqid']; $r = Yii::app()->papdb->createCommand($sta)->queryRow(); if ($r['Status'] > 1) { echo json_encode(array('count' => -1, 'msg' => '只能取消待报价或待确认的询价单')); die; } } else { //查询报价单状态 $sta = 'select Status from pap_quotation where QuoID=' . $quoid; $r = Yii::app()->papdb->createCommand($sta)->queryRow(); if ($r['Status'] != '1') { echo json_encode(array('count' => -1, 'msg' => '只能取消待确认的报价单')); die; } } $sql = 'select SchID from pap_quotation_scheme where QuoID=' . $quoid; $result = Yii::app()->papdb->createCommand($sql)->queryAll(); $schids = array(); foreach ($result as $r) { $schids[] = $r['SchID']; } $schstr = implode(',', $schids); if ($schids) { $goods = PapQuotationGoods::model()->deleteAll('SchID in (' . $schstr . ')'); } $sch = PapQuotationScheme::model()->deleteAll('QuoID=' . $quoid); $quo = PapQuotation::model()->deleteByPk($quoid); if ($params['inqid']) { //查询询价单是否报价 $quosql = 'select QuoID from pap_quotation where IfSend="2" and InquiryID=' . $params['inqid']; $quos = Yii::app()->papdb->createCommand($quosql)->queryRow(); if (!$quos) { $update = 'update pap_inquiry set Status=0 where InquiryID=' . $params['inqid']; Yii::app()->papdb->createCommand($update)->execute(); } } echo json_encode(array('count' => $quo + $sch + $goods)); }