/** * input user data * @param $id_tour * @param $id_booking * @return string */ public function actionRegistration($id_tour, $id_booking) { $model = new Orders(); if (Yii::$app->request->isPost) { $model->load(Yii::$app->request->post()); $model->id_tour = $id_tour; $model->id_booking = $id_booking; if ($model->save()) { $this->redirect('/site/success'); } } return $this->render('registration', compact('model')); }
public function actionAddOrders() { $order = new ModelOrders(); $order->part = $_POST['part']; $order->article = $_POST['article']; $order->OE = $_POST['oe']; $order->provider = $_POST['provider']; $order->quantity = $_POST['quantity']; $order->price = $_POST['price']; $order->cars_id = $_POST['cars_id_hidden']; $order->data_a = date('Y-m-d H:i:s'); $order->insert(); header("Location: http://" . $_SERVER['SERVER_NAME'] . "/orders/AllShowOrders?id=" . $_POST['cars_id_hidden']); }
public function actionAddnew() { $orderNow = orders::find()->where(['active' => 1])->one(); if ($orderNow == null) { $post_order = Yii::$app->request->post()['Orders']; $order = new Orders($post_order); $order->time_begin = date("Y-m-d H:i:s"); $order->active = 1; $order->save(); $resultAdd = 3; } else { $resultAdd = 2; } Yii::$app->response->redirect(array('site/index', 'resultAdd' => $resultAdd)); }
public function actionPopover($id, $attr) { $model = Orders::findOne($id); if ($model->status == Orders::STATUS_REGISTERED && Yii::$app->user->identity->role != 10) { if ($model->status == Orders::STATUS_REGISTERED && Yii::$app->user->identity->role == 0) { $model->scenario = 'registered'; $scenario = $model->scenarios(); if (!in_array($attr, $scenario['registered'])) { throw new \yii\web\HttpException(403, 'У вас нет доступа для редактирования'); } } else { throw new \yii\web\HttpException(403, 'У вас нет доступа для редактирования'); } } if (Yii::$app->request->post('popup')) { $post = Yii::$app->request->post(); $model = Orders::findOne($post['id']); return $this->renderAjax('popover', ['attr' => $post['attr'], 'model' => $model]); } if ($model->load(Yii::$app->request->post())) { $model->editTimestamp = date('Y-m-d H:i:s'); $model->editName = Yii::$app->user->identity->full_name; $model->history .= $model->history($model); $model->save(); } }
public function actionOrder() { if (Yii::$app->session->get('ids')) { $model = new OrderForm(); if ($model->load(Yii::$app->request->post()) && $model->validate()) { $order = new Orders(); $order->delivery = $model->delivery; $ids = Yii::$app->session->get('ids'); $id_count = Yii::$app->session->get('id_count'); $s = ""; for ($i = 0; $i < count($ids); $i++) { $s .= "({$ids[$i]} [{$id_count[$i]}]), "; } $order->product_ids = $s; $order->price = Yii::$app->session->get('price'); $order->email = Html::encode($model->email); $order->adress = Html::encode($model->adress); $order->notice = Html::encode($model->notice); $order->name = Html::encode($model->name); $order->phone = Html::encode($model->phone); $order->date_order = date("Y-m-d H:i:s"); Yii::$app->mailer->compose()->setFrom('*****@*****.**')->setTo($model->email)->setSubject('Заказ товаров на mobzp.ua')->setTextBody('<article id="articles"> <h2>Вы успешно заказали наушники</h2> <p>С вами свяжется наш оператор в течении полу часа и уточнит данные для отправки или место передачи товара.</p> <p>После отправки по новой почте, вам придет смс, что товар отправлен и вы сможете его получить в вашем отделении через несколько дней.</p> <p>Спасибо, что воспользовались услугами нашего магазина! Мы всегда рады положительным отзывам на страничке товара.</p> </article>')->send(); $order->save(); return $this->render('ordersuccess'); } return $this->render('order', ['model' => $model]); } else { return $this->redirect(Yii::$app->request->referrer); } }
public function down() { $this->dropTable($this->tableName); $this->addColumn(Orders::tableName(), 'quantity', $this->integer(5)->notNull()->defaultValue(0)); $this->addColumn(Orders::tableName(), 'product_id', $this->integer(5)->notNull()); $this->addColumn(Orders::tableName(), 'type', $this->string(255)->notNull()); }
public function actionAllShowOrders() { //связь таблиц cars и orders по id(cars) и cars_id(orders) $id = $_GET['id']; $field = 'cars_id'; $this->view->items = Model::findAllUserId($id, $field); $this->view->display('order_car'); }
public function actionSearch($term) { $model = Clients::find()->where(['like', 'name', $term])->limit(10)->all(); foreach ($model as $key => $data) { $orders = Orders::find()->where(['clientId' => $data->id])->count(); $array[$key]['id'] = $data->id; $array[$key]['label'] = $data->name . ' ' . $orders . ' Заказа(ов)'; } echo json_encode($array); }
public function search($params) { $query = Orders::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['exp_delivery_dt' => SORT_DESC]], 'pagination' => ['pageSize' => 100]]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'qty' => $this->qty, 'price_per_unit' => $this->price_per_unit, 'wine_id' => $this->wine_id, 'user_id' => $this->user_id, 'order_dt' => $this->order_dt, 'exp_delivery_dt' => $this->exp_delivery_dt]); $query->andFilterWhere(['like', 'ordered_from', $this->ordered_from])->andFilterWhere(['like', 'futures_flg', $this->futures_flg])->andFilterWhere(['like', 'delivery_location', $this->delivery_location]); return $dataProvider; }
public function actionOrder() { $order = new Orders(); /* @var $cart ShoppingCart */ $cart = \Yii::$app->cart; /* @var $products Product[] */ $products = $cart->getPositions(); $total = $cart->getCost(); if ($order->load(Yii::$app->request->post()) && $order->validate()) { $transaction = $order->getDb()->beginTransaction(); $order->save(false); foreach ($products as $product) { $orderItem = new OrderItem(); $orderItem->order_id = $order->order_id; $orderItem->item_id = $product->item_id; $orderItem->price = $product->getPrice(); $orderItem->quantity = $product->getQuantity(); if (!$orderItem->save(false)) { $transaction->rollBack(); Yii::$app->session->addFlash('error', 'Cannot place your order. Please contact us.'); // TODO: may need to add Yii::t() return $this->redirect('../'); // redirect to web root } } $transaction->commit(); \Yii::$app->cart->removeAll(); Yii::$app->session->addFlash('success', 'Thanks for your order. We\'ll contact you soon.'); $order->sendEmail(); return $this->redirect('../'); // redirect to web root } return $this->render('order', ['order' => $order, 'products' => $products, 'total' => $total]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Orders::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, 'user_id' => $this->user_id, 'quantity' => $this->quantity]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Orders::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, 'user_id' => $this->user_id, 'price' => $this->price, 'status' => $this->status, 'type' => $this->type, 'level_id' => $this->level_id, 'create_time' => $this->create_time, 'update_time' => $this->update_time]); $query->andFilterWhere(['like', 'product', $this->product])->andFilterWhere(['like', 'create_user', $this->create_user])->andFilterWhere(['like', 'update_user', $this->update_user]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Orders::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, 'price' => $this->price, 'time_begin' => $this->time_begin, 'time_total' => $this->time_total]); $query->andFilterWhere(['like', 'work_dir', $this->work_dir])->andFilterWhere(['like', 'link', $this->link]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Orders::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(['order_id' => $this->order_id, 'qty' => $this->qty, 'price_per_unit' => $this->price_per_unit, 'wine_id' => $this->wine_id, 'user_id' => $this->user_id, 'order_dt' => $this->order_dt, 'exp_delivery_dt' => $this->exp_delivery_dt]); $query->andFilterWhere(['like', 'ordered_from', $this->ordered_from])->andFilterWhere(['like', 'futures_flg', $this->futures_flg])->andFilterWhere(['like', 'delivery_location', $this->delivery_location]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Orders::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, 'order_id' => $this->order_id, 'statusID' => $this->statusID, 'delivery_time' => $this->delivery_time]); $query->andFilterWhere(['like', 'spi', $this->spi])->andFilterWhere(['like', 'fio', $this->fio])->andFilterWhere(['like', 'phone', $this->phone])->andFilterWhere(['like', 'amount', $this->amount])->andFilterWhere(['like', 'shop_status', $this->shop_status])->andFilterWhere(['like', 'delivery_status', $this->delivery_status])->andFilterWhere(['like', 'sms_status', $this->sms_status])->andFilterWhere(['like', 'status', $this->status]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Orders::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, 'uid' => $this->uid]); $query->andFilterWhere(['like', 'gordernumber', $this->gordernumber])->andFilterWhere(['like', 'gototal', $this->gototal])->andFilterWhere(['like', 'gostatus', $this->gostatus])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'create_time', $this->create_time]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Orders::find(); // add conditions that should always apply here $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; } // grid filtering conditions $query->andFilterWhere(['id' => $this->id, 'tour_id' => $this->tour_id, 'created' => $this->created, 'user_id' => $this->user_id]); return $dataProvider; }
public function search($params, $date) { if ($date == "") { $query = Orders::find()->joinWith('clients'); } else { $query = Orders::find()->where(['date' => $date])->joinWith('clients'); } $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['date' => SORT_DESC, 'id' => SORT_DESC]], 'pagination' => ['pageSize' => 30]]); // load the search form data and validate if (!($this->load($params) && $this->validate())) { return $dataProvider; } // adjust the query by adding the filters $query->andFilterWhere(['orderNum' => $this->orderNum])->andFilterWhere(['like', 'declaration', $this->declaration])->andFilterWhere(['like', 'clients.name', $this->clientId])->andFilterWhere(['like', 'city', $this->city])->andFilterWhere(['like', 'deliveryId', $this->deliveryId])->andFilterWhere(['like', 'payment', $this->payment])->andFilterWhere(['like', 'driverId', $this->driverId])->andFilterWhere(['like', 'statusS1', $this->statusS1])->andFilterWhere(['like', 'statusS3', $this->statusS3]); return $dataProvider; }
public function run() { Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS = 0'); DB::table('orderitems')->truncate(); $faker = Faker::create(); $orders = \App\Models\Orders::all()->lists('id'); $vendors = \App\Models\Vendors::all()->lists('id'); $categories = \App\Models\Categories::all()->lists('id'); foreach (range(1, 20) as $index) { $quantity = $faker->numberBetween(1, 20); $price = $faker->randomFloat(2, 1, 5000); $finalprice = $faker->randomFloat(2, 1, 5000); DB::table('orderitems')->insert(['name' => $faker->name, 'order_id' => $faker->randomElement($orders), 'category_id' => $faker->randomElement($categories), 'vendor_id' => $faker->randomElement($vendors), 'description' => $faker->text(), 'url' => $faker->url, 'quantity' => $quantity, 'estimatedprice' => $price, 'estimatedtotal' => $price * $quantity, 'fixedprice' => $finalprice, 'fixedtotal' => $finalprice * $quantity, 'status' => 0]); } DB::statement('SET FOREIGN_KEY_CHECKS = 1'); }
use app\models\Parameters; use app\models\Pages; use app\models\Orders; use app\models\Trades; use lithium\core\Environment; use lithium\data\Connections; $Comm = Parameters::find('first'); $howmany = 100; $tradesV = Trades::find('first', array('conditions' => array('SecondType' => 'Virtual'), 'limit' => $howmany, 'order' => array('order' => 1))); $first_currency = substr($tradesV['trade'], 0, 3); $second_currency = substr($tradesV['trade'], 4, 3); $tradesVF = Trades::find('all', array('conditions' => array('SecondType' => 'Fiat'), 'limit' => $howmany, 'order' => array('order' => -1))); $trades = Trades::find('all', array('limit' => $howmany, 'order' => array('order' => 1))); $mongodb = Connections::get('default')->connection; $Rates = Orders::connection()->connection->command(array('aggregate' => 'orders', 'pipeline' => array(array('$project' => array('_id' => 0, 'Action' => '$Action', 'PerPrice' => '$PerPrice', 'Completed' => '$Completed', 'FirstCurrency' => '$FirstCurrency', 'SecondCurrency' => '$SecondCurrency', 'TransactDateTime' => '$Transact.DateTime')), array('$match' => array('Completed' => 'Y')), array('$group' => array('_id' => array('FirstCurrency' => '$FirstCurrency', 'SecondCurrency' => '$SecondCurrency', 'year' => array('$year' => '$TransactDateTime'), 'month' => array('$month' => '$TransactDateTime'), 'day' => array('$dayOfMonth' => '$TransactDateTime')), 'min' => array('$min' => '$PerPrice'), 'avg' => array('$avg' => '$PerPrice'), 'max' => array('$max' => '$PerPrice'), 'last' => array('$last' => '$PerPrice'))), array('$sort' => array('_id.year' => -1, '_id.month' => -1, '_id.day' => -1, '_id.hour' => -1)), array('$limit' => count($trades))))); ?> <p> </p> <div class="container-fluid"> <div class="row placeholders"> <?php foreach ($tradesVF as $tradeVF) { if (substr($tradeVF['trade'], 0, 3) == $second_currency) { ?> <div class="col-xs-6 col-sm-6 placeholder" style="text-align:center"> <h4><?php echo $tradeVF['trade']; ?> </h4> <?php foreach ($Rates['result'] as $rate) {
public function bitcoincharts($currency = 'USD', $filename = null) { if ($filename == "") { return $this->render(array('json' => array('success' => 0, 'now' => time(), 'error' => "No method specified."))); } if ($filename == "trades.json") { if ($date == null) { $StartDate = new MongoDate(strtotime(gmdate('Y-m-d', mktime(0, 0, 0, gmdate('m', time()), gmdate('d', time()), gmdate('Y', time()))))); $EndDate = new MongoDate(strtotime(gmdate('Y-m-d', mktime(0, 0, 0, gmdate('m', time()), gmdate('d', time()), gmdate('Y', time())) + 24 * 60 * 60))); } else { $StartDate = new MongoDate(strtotime($date)); $EndDate = new MongoDate(strtotime($date) + 24 * 60 * 60); } $orders = Orders::find('all', array('conditions' => array('DateTime' => array('$gte' => $StartDate, '$lt' => $EndDate), 'FirstCurrency' => 'BTC', 'SecondCurrency' => $currency, 'Completed' => 'Y'), 'order' => array('DateTime' => -1))); $i = 0; $result = array(); foreach ($orders as $or) { $result[$i]['date'] = $or['DateTime']->sec; $result[$i]['price'] = $or['PerPrice']; $result[$i]['amount'] = $or['Amount']; // $result[$i]['tid1'] = $or['_id']->getInc() ; // $result[$i]['tid2'] = $or['_id']->getHostname() ; $result[$i]['tid'] = $or['_id']->getPID(); $i++; } return $this->render(array('json' => $result)); } //[{"date":1306148860,"price":6.87,"amount":1,"tid":"82771"},{"date":1306149340,"price":6.86001,"amount":1,"tid":"82772"}] if ($filename == "orderbook.json") { $i = 0; $result = array(); $orderbids = array(); $orderask = array(); $orders = Orders::find('all', array('conditions' => array('FirstCurrency' => 'BTC', 'SecondCurrency' => $currency, 'Completed' => 'N'), 'order' => array('DateTime' => -1))); foreach ($orders as $or) { if ($or['Action'] == 'Sell') { array_push($orderbids, array($or['PerPrice'], $or['Amount'])); } if ($or['Action'] == 'Buy') { array_push($orderask, array($or['PerPrice'], $or['Amount'])); } $i++; } $result = array('ask' => $orderask, 'bids' => $orderbids); return $this->render(array('json' => $result)); } // {"asks":[[7.449,1],[7.4499,6.711]],"bids":[[7.40001,5],[7.3325,27.449]]} This will ask }
public function getProfile() { $orders = \App\Models\Orders::where('user_id', '=', \Auth::user()->_id)->get(); return view('auth.profile_page', ['orders' => $orders]); }
public function ChangeCurrentOrder($order_id, $PO_id, $PO_Amount, $user) { $PO = Orders::find('first', array('conditions' => array('_id' => $PO_id))); $CO = Orders::find('first', array('conditions' => array('_id' => $order_id))); if ($CO['Action'] == "Buy") { $CurrCommAmount = round((double) $CO['CommissionPercent'] * (double) $PO_Amount / 100, 8); $NewCommAmount = round((double) $CO['CommissionPercent'] * ((double) $CO['Amount'] - (double) $PO_Amount) / 100, 8); } else { $CurrCommAmount = round((double) $CO['CommissionPercent'] * (double) $PO_Amount * (double) $CO['PrePrice'] / 100, 8); $NewCommAmount = round((double) $CO['CommissionPercent'] * ((double) $CO['Amount'] - (double) $PO_Amount) * (double) $CO['PrePrice'] / 100, 8); } $COData = array('Action' => $CO['Action'], 'FirstCurrency' => $CO['FirstCurrency'], 'SecondCurrency' => $CO['SecondCurrency'], 'CommissionPercent' => (double) $CO['CommissionPercent'], 'Commission.Amount' => (double) $CurrCommAmount, 'Commission.Currency' => $CO['Commission']['Currency'], 'Amount' => (double) $PO_Amount, 'PerPrice' => (double) $CO['PerPrice'], 'DateTime' => $CO['DateTime'], 'username' => $CO['username'], 'IP' => $CO['IP'], 'user_id' => $CO['user_id'], 'Completed' => 'Y', 'Transact.id' => $PO_id, 'Transact.username' => $PO['username'], 'Transact.user_id' => $PO['_id'], 'Transact.DateTime' => new \MongoDate(), 'Order' => 'P>C: Update Current Commission and Amount and Complete Order'); // print_r($COData) ; $data = array('Action' => $CO['Action'], 'FirstCurrency' => $CO['FirstCurrency'], 'SecondCurrency' => $CO['SecondCurrency'], 'CommissionPercent' => (double) $CO['CommissionPercent'], 'Commission.Amount' => (double) $NewCommAmount, 'Commission.Currency' => $CO['Commission']['Currency'], 'Amount' => (double) ($CO['Amount'] - $PO_Amount), 'PerPrice' => (double) $CO['PerPrice'], 'DateTime' => new \MongoDate(), 'Completed' => 'N', 'IP' => $_SERVER['REMOTE_ADDR'], 'username' => $user['username'], 'user_id' => $user['_id']); $CO = Orders::find('all', array('conditions' => array('_id' => $order_id)))->save($COData); // Create Order for the user if ((double) ($CO['Amount'] - $PO_Amount) > 0) { $orders = Orders::create(); $orders->save($data); $order_id = $orders->_id; $this->SendEmails($order_id, $user['_id']); return $order_id; } return false; }
function getOrderByUserId($id) { // \DB::enableQueryLog(); $order = Order::where('user_id', $id)->get(); return $order; }
public function RemoveCompletedOrder($ID) { if ($this->__init() == false) { $this->redirect('ex::dashboard'); } $Orders = Orders::find('first', array('conditions' => array('_id' => new MongoID($ID)))); /* print_r($Orders['_id']); print_r("<br>"); print_r($Orders['Transact']['id']); print_r("<br>"); */ if ($Orders['Completed'] == 'Y') { $details = Details::find('first', array('conditions' => array('user_id' => (string) $Orders['user_id']))); if ($Orders['Action'] == 'Buy') { $balanceFirst = 'balance.' . $Orders['FirstCurrency']; $balanceSecond = 'balance.' . $Orders['SecondCurrency']; $data = array($balanceSecond => (double) ($details[$balanceSecond] + $Orders['PerPrice'] * $Orders['Amount'])); /* print_r($Orders['username']); print_r($details[$balanceSecond]); print_r($data); */ $details = Details::find('all', array('conditions' => array('user_id' => $Orders['user_id'], 'username' => $Orders['username'])))->save($data); $fromUser = Details::find('first', array('conditions' => array('user_id' => (string) $Orders['Transact']['user_id']))); $data = array($balanceFirst => (double) ($fromUser[$balanceFirst] + (double) $Orders['Amount'])); /* print_r($Orders['Transact']['username']); print_r($fromUser[$balanceFirst]); print_r($data); */ $details = Details::find('all', array('conditions' => array('user_id' => $Orders['Transact']['user_id'], 'username' => $Orders['Transact']['username'])))->save($data); } if ($Orders['Action'] == 'Sell') { $balanceFirst = 'balance.' . $Orders['FirstCurrency']; $balanceSecond = 'balance.' . $Orders['SecondCurrency']; $data = array($balanceFirst => (double) ($details[$balanceFirst] + (double) $Orders['Amount'])); /* print_r($Orders['username']); print_r($details[$balanceFirst]); print_r($data); */ $details = Details::find('all', array('conditions' => array('user_id' => $Orders['user_id'], 'username' => $Orders['username'])))->save($data); $fromUser = Details::find('first', array('conditions' => array('user_id' => (string) $Orders['Transact']['user_id']))); $data = array($balanceSecond => (double) ($fromUser[$balanceSecond] + $Orders['PerPrice'] * $Orders['Amount'])); /* print_r($Orders['Transact']['username']); print_r($fromUser[$balanceSecond]); print_r($data); */ $details = Details::find('all', array('conditions' => array('user_id' => $Orders['Transact']['user_id'], 'username' => $Orders['Transact']['username'])))->save($data); } $Remove = Orders::remove(array('_id' => $Orders['_id'])); $Remove = Orders::remove(array('_id' => $Orders['Transact']['id'])); $data = array('page.refresh' => true); Details::find('all')->save($data); } $this->redirect(array('controller' => 'Admin', 'action' => "orders")); }
/** * @return \yii\db\ActiveQuery */ public function getOrder() { return $this->hasOne(Orders::className(), ['id' => 'order_id']); }
public function actionCronsms() { Orders::updateOrders(); Orders::getNewShopOrders(); }
/** * @return \yii\db\ActiveQuery */ public function getOrders() { return $this->hasMany(Orders::className(), ['prod_id' => 'id']); }
/** * Finds the Orders model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param string $id * @return Orders the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Orders::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
public function actionEvents() { if (\filter_input(INPUT_GET, 'q')) { $q = \filter_input(INPUT_GET, 'q'); $query = new Query(); $query->select("`b`.*")->from("bookings b, customers c, items i, bookingitems bi")->where("(" . "b.idCustomer=c.id AND " . "(" . "CONCAT(c.firstname, ' ', c.lastname) LIKE '{$q}' OR " . "c.firstname LIKE '{$q}' OR " . "c.lastname LIKE '{$q}' OR " . "CONCAT(c.lastname, ' ', c.firstname) LIKE '{$q}'" . ")" . ") OR (bi.idItem=i.id AND (i.name LIKE '{$q}' OR i.idItem LIKE '{$q}'))")->groupBy("b.id"); $bookings = $query->createCommand()->queryAll(); } else { $bookings = Bookings::find()->all(); } if (!empty($bookings)) { $status = 1; $events = array(); for ($i = 0; $i < sizeof($bookings); $i++) { $is_order = !empty(Orders::find()->where(['idBooking' => $bookings[$i]['id']])->one()->id) ? true : false; $date_passed = strtotime($bookings[$i]['deliveryDate']) < strtotime(date('Y-m-d')) ? true : false; $delivered = $is_order ? Orders::find()->where(['idBooking' => $bookings[$i]['id']])->one()->delivered == 1 ? true : false : false; if (!$is_order && $date_passed) { $status = 3; } elseif ($is_order && $date_passed && !$delivered) { $status = 4; } elseif ($is_order && !$date_passed) { $status = 2; } elseif ($is_order && $date_passed && $delivered) { $status = 5; } else { $status = 1; } $customer = Customers::find()->where(['id' => $bookings[$i]['idCustomer']])->one(); $Event = new \yii2fullcalendar\models\Event(); $Event->id = $bookings[$i]['id']; if (!empty($customer)) { $Event->title = $customer->firstname . " " . $customer->lastname; } $Event->start = $bookings[$i]['deliveryDate']; $Event->status = $status; $events[] = $Event; } if (!empty($events)) { return json_encode($events); } } }