/** * @return \Illuminate\Routing\Route|null|string */ public function ingnoreId() { $id = $this->route('commodity'); $name = $this->input('name'); $metric_id = $this->input('metric_id'); return Commodity::where(compact('id', 'name', 'metric_id'))->exists() ? $id : ''; }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { $receipt = Receipt::find($id); $suppliers = Supplier::all()->lists('name', 'id'); $commodities = Commodity::all()->lists('name', 'id'); return view('receipt.edit')->with('receipt', $receipt)->with('commodities', $commodities)->with('suppliers', $suppliers); }
public function yiyuanShow($id) { // $jssdk = new Jssdk(env('WX_APPID'), env('WX_SECRET')); // $signPackage = $jssdk->getSignPackage(); $item = Commodity::with(['images', 'slideImages'])->find($id); return view('shop.yiyuan-detail')->with(['item' => $item->toArray()]); }
public static function commodity() { $result = []; foreach (Commodity::all() as $commodity) { $result[] = ['id' => $commodity->id, 'name' => $commodity->name, 'count' => self::getCommoditySoldSum($commodity)]; } return $result; }
/** * Retrieve the details for a specific commodity * @param integer $id * @return array */ public function actionView($id = NULL) { if ($id === NULL) { throw new HttpException(400, 'Missing ID parameter'); } $query = Commodity::find()->where(['id' => $id]); return ResponseBuilder::build($query, 'commodities+stations', Yii::$app->request->get('sort', 'name'), Yii::$app->request->get('order', 'asc')); }
private function getAllSection() { $commodity = Commodity::find()->where(['uid' => Yii::$app->user->id])->all(); $commodityArray = array(); foreach ($commodity as $item) { $name = $item->getAttribute('name'); $commodityArray[$name] = $name; } return $commodityArray; }
public static function getStatisticsByCustomerID($customerID) { $details = CustomerCommodityStatistics::where('customer_id', $customerID)->get(); if ($details) { $details = $details->toArray(); } else { $details = []; } foreach ($details as &$detail) { $detail['commodity'] = Commodity::withTrashed()->find($detail['commodity_id'])->toArray(); } return $details; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Commodity::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'status' => $this->status, 'uid' => Yii::$app->user->id]); $query->andFilterWhere(['like', 'name', $this->name]); return $dataProvider; }
public function yiyuanIndex() { $customer = \Helper::getCustomer(); // \Log::info('Location-yiyuan---'.$customer ); // if ($customer->yikangQuestionnaire()->first() == null) { // // \Log::info('yiyuan---不存在用户' ); // return redirect('/questionnaire2'); // } // if ($customer->hasPurchesedOneSale()) { // // \Log::info('yiyuan---已购买过' ); // return '<a style="font-size: 50px;display:block;width: 100%;margin: 20% auto;text-align: center;">每人仅能参加一次活动!</a>'; // } // \Log::info('yiyuan---进入一元专区' ); // $jssdk = new Jssdk(env('WX_APPID'), env('WX_SECRET')); // $signPackage = $jssdk->getSignPackage(); return view('shop.yiyuan-index')->with(['items' => Commodity::where('special_sale', '=', '1元专区')->with('images')->orderBy('priority', 'desc')->get()]); }
public function testAddItem() { $item = \App\Models\Commodity::find(1); $item2 = \App\Models\Commodity::find(2); Cart::addItem($item); $this->assertEquals(Cart::getItems()->count(), 1); $this->assertEquals(Cart::getTotalCost(), $item->getPrice()); Cart::removeItemsById($item->getIdentifer()); $this->assertEquals(Cart::getItems()->count(), 0); $this->assertEquals(Cart::getTotalCost(), 0); Cart::addItem($item); Cart::addItem($item2); Cart::addItem($item); $this->assertEquals(Cart::getItems()->count(), 2); $this->assertEquals(Cart::getTotalCost(), $item->getPrice() * 2 + $item2->getPrice()); Cart::removeItems(['name' => $item->getName()]); $this->assertEquals(Cart::getItems()->count(), 1); $this->assertEquals(Cart::getTotalCost(), $item2->getPrice()); }
/** * @return \yii\db\ActiveQuery */ public function getCommodities() { return $this->hasMany(Commodity::className(), ['category_id' => 'id']); }
public function actionCreate($cid) { $commodity = Commodity::findOne($cid); if (empty($commodity)) { throw new HttpException(404, '商品不存在!'); } if ($commodity->statu != Commodity::$_AUDIT_ACCESS) { throw new HttpException(404, '商品未审核通过!'); } $model = new CommodityOrder(); if ($model->load(Yii::$app->request->post())) { $model->create_time = date('Y-m-d H:i:s'); $model->uid = $this->user->id; $model->statu = CommodityOrder::$_AUDIT_PEND; $model->op_statu = CommodityOrder::$_OP_NOT; $model->platform_id = $commodity->platform_id; if ($model->save()) { $commodityOrderDetails = Yii::$app->request->post('CommodityOrderDetail'); $size = count($commodityOrderDetails['keyword']); $corpus = 0; $total_fee = 0; $budget_num = 0; for ($i = 0; $i < $size; $i++) { $commodityOrderDetail = new CommodityOrderDetail(); $commodityOrderDetail->coid = $model->id; $commodityOrderDetail->keyword = $commodityOrderDetails['keyword'][$i]; $commodityOrderDetail->eid = $commodityOrderDetails['eid'][$i]; $entrance = Entrance::findOne($commodityOrderDetail->eid); if (!is_null($entrance)) { $commodityOrderDetail->entrance = $entrance->name; } $commodityOrderDetail->condition = $commodityOrderDetails['condition'][$i]; $commodityOrderDetail->num = $commodityOrderDetails['num'][$i]; $commodityOrderDetail->price = $commodityOrderDetails['price'][$i]; $commodityOrderDetail->fee = $commodityOrderDetails['fee'][$i]; $commodityOrderDetail->save(); $num = intval($commodityOrderDetail->num); $price = floatval($commodityOrderDetail->price); $fee = floatval($commodityOrderDetail->fee); $total_price = $num * $price; $sum_fee = $num * $fee; $corpus += $total_price; $total_fee += $sum_fee; $budget_num += $num; } $statistics = new Statistics(); $statistics->coid = $model->id; $statistics->shop = $model->shop; $statistics->platform = $model->platform; $statistics->commodity = $model->commodity_id; $statistics->corpus = $corpus; $statistics->total_fee = $total_fee; $statistics->real_income = 0; $statistics->fact_fee = 0; $statistics->total_num = 0; $statistics->total_income = 0; $statistics->budget_num = $budget_num; $statistics->handle_time = $model->handle_time; $statistics->uid = $model->uid; $statistics->save(); echo "\t<meta charset='utf-8'>"; echo "<script>alert('提交成功!')</script>"; echo "<script>history.go(-1);</script>"; return; } } $model->cid = $cid; $model->shop = $commodity->shop; $model->commodity_id = $commodity->commodity_id; $model->sku = $commodity->sku; $model->img = $commodity->img; $model->rule = $commodity->rule; $model->buyer_rule = $commodity->buyer_rule; $model->remark = $commodity->remark; $model->platform = $commodity->platform; $model->credit = $commodity->credit; $model->trade_num = $commodity->trade_num; $dataProvider = new ActiveDataProvider(['query' => CommodityOrderTemplet::find()->where('cid = :cid', [':cid' => $cid])->orderBy('keyword'), 'pagination' => false]); return $this->render('create', array('model' => $model, 'commodity' => $commodity, 'dataProvider' => $dataProvider)); }
/** * Finds the Commodity model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Commodity the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Commodity::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
public function category() { return view('shop.category')->with(['items' => Commodity::all()]); }
public function validateCommodity($attribute, $params) { echo 'validateCommodity'; $commodity = Commodity::find()->where('commodity_id = :commodity_id', [':commodity_id' => $this->{$attribute}])->one(); if (is_null($commodity)) { return $this->addError($attribute, '商品不存在'); } if ($this->scenario == 'create') { $orderCount = (new Query())->from(Order::tableName())->where('commodity = :commodity', [':commodity' => $this->{$attribute}])->count(); $coCount = (new Query())->select(CommodityOrderDetail::tableName() . '.num as num')->from(CommodityOrder::tableName())->leftJoin(CommodityOrderDetail::tableName(), CommodityOrderDetail::tableName() . '.coid = ' . CommodityOrder::tableName() . '.id')->where('commodity_id = :commodity_id', [':commodity_id' => $this->{$attribute}])->sum('num'); if ($orderCount + 1 == $coCount) { $sql = "update " . CommodityOrder::tableName() . " set op_statu = " . CommodityOrder::$_OP_FINISH . " where commodity_id = :commodity_id"; $db = Yii::$app->db; $command = $db->createCommand($sql); $command->bindParam(":commodity_id", $this->{$attribute}, PDO::PARAM_STR); $command->execute(); } if ($orderCount >= $coCount) { return $this->addError($attribute, '该商品订单已满'); } } }
/** * @return \yii\db\ActiveQuery */ public function getCommodity() { return $this->hasOne(Commodity::className(), ['id' => 'commodity_id']); }
public function actionAuditView($id) { $model = Commodity::findOne($id); $commodityOrderTemplet = new CommodityOrderTemplet(); if ($commodityOrderTemplet->load(Yii::$app->request->post())) { $commodityOrderTemplet->cid = $model->id; $entrance = Entrance::findOne($commodityOrderTemplet->eid); if (!empty($entrance)) { $commodityOrderTemplet->entrance = $entrance->name; } $commodityOrderTemplet->save(); //$commodityOrderTemplet->dirtyAttributes; } $dataProvider = new ActiveDataProvider(['query' => CommodityOrderTemplet::find()->where('cid = :cid', [':cid' => $id])->orderBy('keyword'), 'pagination' => false]); $entrances = Entrance::find()->all(); $entrances_json = array(); foreach ($entrances as $entrance) { $enarray = ['value' => $entrance->id, 'text' => $entrance->name]; array_push($entrances_json, $enarray); } $entrances_json = json_encode($entrances_json); return $this->render('audit-view', array('model' => $model, 'dataProvider' => $dataProvider, 'commodityOrderTemplet' => $commodityOrderTemplet, 'entrances' => $entrances, 'entrances_json' => $entrances_json)); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function delete($id) { //Soft delete the item $commodity = Commodity::find($id); $commodity->delete(); // redirect return redirect()->to('commodity.index')->with('message', trans('messages.commodity-succesfully-deleted')); }
/** * @param array $items * @return $this */ public function addCommodities(array $items) { foreach ($items as $item) { $commodity = Commodity::findOrFail($item['id']); $this->addCommodity($commodity, $item['num']); } return $this; }
/** * Import station commodities information * @param array $station * @param string $class * @param array $data * @return boolean */ private function importStationCommodity($station, $class, $model, $data) { Yii::$app->db->createCommand('DELETE FROM station_commodities WHERE station_id = :station_id AND type=:type')->bindValue(':station_id', $station['id'])->bindValue(':type', $class)->execute(); $i = 0; foreach ($data as $d) { if ($class === 'listings') { $commodity = Commodity::find()->where(['id' => $d['commodity_id']])->one(); } else { $commodity = Commodity::find()->where(['name' => $d])->one(); } if ($commodity !== NULL) { $model->attributes = ['station_id' => $station['id'], 'commodity_id' => $commodity->id, 'type' => (string) $class, 'supply' => isset($d['supply']) ? $d['supply'] : null, 'buy_price' => isset($d['buy_price']) ? $d['buy_price'] : null, 'sell_price' => isset($d['sell_price']) ? $d['sell_price'] : null, 'demand' => isset($d['demand']) ? $d['demand'] : null]; if ($model->save()) { $i++; } } else { Yii::warning("{$station['id']}::{$station['name']} - Couldn't find commodity {$commodity}", __METHOD__); } } $inflected = \yii\helpers\Inflector::humanize($class); $this->stdOut(" - {$inflected} :: {$i}\n"); }