public function search($params)
{
$query = Apply::find();
$dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]], 'pagination' => ['pageSize' => 20]]);
// load the seach form data and validate
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$dateBegin = strtotime($this->date);
$dateEnd = $dateBegin + 86400;
// adjust the query by adding the filters
$query->andFilterWhere(['like', 'apply_sn', $this->apply_sn])->andFilterWhere(['store_id' => $this->store_id])->andFilterWhere(['status' => $this->status])->andFilterWhere(['>=', 'created_at', $this->date ? $dateBegin : null])->andFilterWhere(['<', 'created_at', $this->date ? $dateEnd : null]);
return $dataProvider;
}
public function create($runValidation = true)
{
if ($runValidation && !$this->validate()) {
return false;
}
if (empty($this->_purchaseList)) {
return false;
}
$transaction = Yii::$app->db->beginTransaction();
try {
if (Apply::find()->where(['store_id' => Yii::$app->user->identity->store_id, 'status' => [Apply::STATUS_PENDING, Apply::STATUS_REJECTED, Apply::STATUS_PASSED]])->exists()) {
throw new \Exception('您采购历史中还有未完成的订单，不能继续申请.');
}
$this->_apply = new Apply();
$this->_apply->generateApplySn();
$this->_apply->store_id = Yii::$app->user->identity->store_id;
$this->_apply->status = Apply::STATUS_PENDING;
$this->_apply->fee = Purchase::getVolumeByStoreId($this->_apply->store_id);
$this->_apply->remark = $this->remark;
if (!$this->_apply->save(false)) {
throw new \Exception('创建申请失败！');
}
foreach ($this->_purchaseList as $purchase) {
if ($purchase->isExpired) {
throw new \Exception("商品“{$purchase->goods->name}”已失效，请删除该商品然后继续。");
}
$modelApplyGoods = ApplyGoods::createDuplicate($purchase->goods_id);
$modelApplyGoods->apply_id = $this->_apply->id;
$modelApplyGoods->count = $purchase->count;
if (!$modelApplyGoods->save(false)) {
throw new \Exception('记录商品清单失败！');
}
}
$modelApplyLog = new ApplyLog();
$modelApplyLog->apply_id = $this->_apply->id;
$modelApplyLog->remark = '开始提交申请。';
if (!$modelApplyLog->save(false)) {
throw new \Exception('商品申请记录失败！');
}
Purchase::clear(Yii::$app->user->identity->store_id);
$transaction->commit();
return true;
} catch (\Exception $e) {
$transaction->rollBack();
throw $e;
}
}
