/**
  * Creates a new Comercios model.
  * If creation is successful, the browser will be redirected to the 'view' page.
  * @return mixed
  */
 public function actionCreate()
 {
     $model = new Comercios();
     if ($model->load(Yii::$app->request->post())) {
         $cantProd = count($model->productos);
         $productos = ArrayHelper::map(Productos::find()->all(), 'idProd', 'nombre');
         /*se crea el stock inicial para el comercio*/
         for ($i = 0; $i < $cantProd; $i++) {
             $id = $model->productos[$i];
             $modelStock = new Stock();
             $modelStock->nombreComercio = $model->nombre;
             $modelStock->cantidadEnStock = 0;
             $modelStock->nombreProducto = $productos[$id];
             $modelStock->save();
         }
         $address = urlencode($model->direccion);
         $url = "http://maps.google.com/maps/api/geocode/json?sensor=false&address=" . $address;
         $response = file_get_contents($url);
         $json = json_decode($response, true);
         if ($json['status'] == 'ZERO_RESULTS') {
             return array();
         }
         $model->latitud = json_encode($json['results'][0]['geometry']['location']['lat']);
         $model->longitud = json_encode($json['results'][0]['geometry']['location']['lng']);
         if ($model->save()) {
             return $this->redirect(['view', 'id' => $model->idComercio]);
         }
     } else {
         return $this->render('create', ['model' => $model]);
     }
 }
 /**
  * Creates a new Stock model.
  * If creation is successful, the browser will be redirected to the 'view' page.
  * @return mixed
  */
 public function actionCreate()
 {
     $model = new Stock();
     if ($model->load(Yii::$app->request->post()) && $model->save()) {
         return $this->redirect(['view', 'id' => $model->id]);
     } else {
         return $this->render('create', ['model' => $model]);
     }
 }
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Stock::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, 'cantidad' => $this->cantidad, 'id_producto' => $this->id_producto, 'id_ruta_diaria_com' => $this->id_ruta_diaria_com]);
     return $dataProvider;
 }
示例#4
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = StockModel::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, 'trade' => $this->trade, 'pricechange' => $this->pricechange, 'changepercent' => $this->changepercent, 'buy' => $this->buy, 'sell' => $this->sell, 'settlement' => $this->settlement, 'open' => $this->open, 'high' => $this->high, 'low' => $this->low, 'volume' => $this->volume, 'amount' => $this->amount, 'pb' => $this->pb, 'mktcap' => $this->mktcap, 'nmc' => $this->nmc, 'turnoverratio' => $this->turnoverratio, 'ticktime' => $this->ticktime, 'updated_at' => $this->updated_at, 'created_at' => $this->created_at]);
     $query->andFilterWhere(['like', 'symbol', $this->symbol])->andFilterWhere(['like', 'code', $this->code])->andFilterWhere(['like', 'name', $this->name]);
     return $dataProvider;
 }
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Stock::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(['idStock' => $this->idStock, 'cantidadEnStock' => $this->cantidadEnStock]);
     $query->andFilterWhere(['like', 'nombreComercio', $this->nombreComercio])->andFilterWhere(['like', 'nombreProducto', $this->nombreProducto]);
     return $dataProvider;
 }
 /**
         Devuelve un numero de 0 a 100 que refleja la actividad del Relevador en esta ruta.
      **/
 public function getCompletitudRecorrido()
 {
     if ($this->getRutaDiariaComercios()->count() > 0) {
         $cantidadComercios = $this->getRutaDiariaComercios()->count();
         $rdComercios = $this->getRutaDiariaComercios()->all();
         $comerciosRecorridos = 0;
         foreach ($rdComercios as $rdComercio) {
             if (Stock::find()->where(['id_ruta_diaria_com' => $rdComercio->id])->count() > 0) {
                 $comerciosRecorridos++;
             }
         }
         return $comerciosRecorridos * 100 / $cantidadComercios;
     } else {
         return 0;
     }
 }
 public function findStockComercio($id)
 {
     if ($models = Stock::find()->where(['id_ruta_diaria_com' => $id])->all() !== null) {
         return $models;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }
 public function actionStock($id)
 {
     $idStockDeComercio = array();
     $arrayNombresProductos = array();
     $cantStockDeComercio = array();
     $conjuntoComercios = ArrayHelper::toArray(Comercios::find()->all());
     $conjuntoStock = ArrayHelper::toArray(Stock::find()->all());
     foreach ($conjuntoComercios as $value) {
         if ($value['idComercio'] == $id) {
             $nomComercio = $value['nombre'];
         }
     }
     foreach ($conjuntoStock as $value) {
         if ($value['nombreComercio'] == $nomComercio) {
             array_push($arrayNombresProductos, $value['nombreProducto']);
             //obtengo los nombres de los productos del stock de ese comercio
             array_push($idStockDeComercio, $value['idStock']);
             array_push($cantStockDeComercio, $value['cantidadEnStock']);
         }
     }
     return $this->render('stock', ['comerciostock' => $arrayNombresProductos, 'nombreComercio' => $nomComercio, 'idStockDeComercio' => $idStockDeComercio, 'cantStockDeComercio' => $cantStockDeComercio]);
 }
 /**
  * Finds the Stock model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $id
  * @return Stock the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = Stock::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }
示例#10
0
 /**
  * 同步当前股票信息
  */
 public function actionSyncStock()
 {
     $sleep = 5;
     while (true) {
         try {
             $hourm = intval(date('Hm'));
             if ($hourm > 900 && $hourm < 1135 || $hourm > 1300 && $hourm < 1510) {
                 $pici = time();
                 $url_arr = ['http://vip.stock.finance.sina.com.cn/quotes_service/api/json_v2.php/Market_Center.getHQNodeData?page=1&num=10000&sort=changepercent&asc=0&node=sz_a&symbol=&_s_r_a=page&time=' . time(), 'http://vip.stock.finance.sina.com.cn/quotes_service/api/json_v2.php/Market_Center.getHQNodeData?page=1&num=10000&sort=changepercent&asc=0&node=sh_a&symbol=&_s_r_a=page'];
                 foreach ($url_arr as $url) {
                     $return_arr = Common::reqUrl($url, [], true, 30, true);
                     if ($return_arr['content']) {
                         $arr = Common::ext_json_decode(mb_convert_encoding($return_arr['content'], "utf-8", "gbk"), true);
                         if ($arr) {
                             foreach ($arr as $row) {
                                 $Stock = Stock::find()->where(['symbol' => $row['symbol']])->one();
                                 if ($Stock) {
                                     $Stock->scenario = 'update';
                                 } else {
                                     $Stock = new Stock(['scenario' => 'create']);
                                     $Stock->updated_at = time();
                                 }
                                 $save_arr = [];
                                 $save_arr['Stock'] = $row;
                                 if ($Stock->id && $row['trade'] != $Stock->trade) {
                                     $StockLog = new StockLog(['scenario' => 'create']);
                                     $StockLog->stock_id = $Stock->id;
                                     $StockLog->pici = $pici;
                                     $StockLog->setAttributes($Stock->attributes);
                                     $StockLog->id = '';
                                     $StockLog->save();
                                 }
                                 if ($Stock->load($save_arr) && $Stock->save()) {
                                 }
                             }
                         }
                     }
                 }
             }
             sleep($sleep);
         } catch (Exception $e) {
         }
     }
 }
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getStocks()
 {
     return $this->hasMany(Stock::className(), ['id_producto' => 'id']);
 }
 public function actionStock()
 {
     $params = Yii::$app->getRequest()->post();
     $user = User::findIdentityByAccessToken($params['muli_token']);
     $valid = false;
     //return $params;
     $arrayStock = $params['stock'];
     foreach ($arrayStock as $stockEnv) {
         $rutaDiaria = RutaDiaria::find()->where(['id_usuario' => $user->id])->andWhere(['fecha' => date('Y-m-d')])->one();
         $rutaDiariaComercio = RutaDiariaComercio::find()->where(['id_comercio' => $params['id_comercio']])->andWhere(['id_ruta_diaria' => $rutaDiaria->id])->one();
         $stockIdProd = Stock::find()->where(['id_producto' => $stockEnv['id_producto']])->andWhere(['id_ruta_diaria_com' => $rutaDiariaComercio->id])->one();
         if ($stockIdProd != null) {
             $stock = $stockIdProd;
             $stock->setAttribute('cantidad', $stockEnv['cant']);
         } else {
             $stock = new Stock();
             $stock->setAttribute('id_ruta_diaria_com', $rutaDiariaComercio->id);
             $stock->setAttribute('id_producto', $stockEnv['id_producto']);
             $stock->setAttribute('cantidad', $stockEnv['cant']);
         }
         if ($stock->cantidad != 0) {
             if ($stock->validate()) {
                 if ($stockIdProd != null) {
                     //es un update del Stock, podemos haber realizado ya el calculo de la venta.
                     $rutaDiariaComercioFecha = RutaDiariaComercio::find()->where('ruta_diaria_comercio.id !=' . $rutaDiariaComercio->id)->andWhere('ruta_diaria_comercio.id_ruta_diaria!=' . $rutaDiariaComercio->id_ruta_diaria)->andWhere(['ruta_diaria_comercio.id_comercio' => $rutaDiariaComercio->id_comercio])->joinWith(['idRutaDiaria' => function ($query) {
                         //$query->where('MAX(ruta_diaria.fecha)');
                         $query->groupBy('ruta_diaria.id')->having('MAX(ruta_diaria.fecha)')->orderBy('fecha DESC');
                     }])->one();
                     $stockAnterior = Stock::find()->where(['id_producto' => $stock->id_producto])->andWhere(['id_ruta_diaria_com' => $rutaDiariaComercioFecha->id])->one();
                     $pedidoAnterior = Pedido::find()->where(['id_producto' => $stock->id_producto])->andWhere(['id_ruta_diaria_com' => $rutaDiariaComercioFecha->id])->one();
                     if ($stockAnterior != null) {
                         $vendidos = $stockAnterior->cantidad - $stock->cantidad;
                         if ($pedidoAnterior != null) {
                             $vendidos = $vendidos + $pedidoAnterior->cantidad;
                         }
                         $compraProducto = ComercioProducto::find()->where(['id_comercio' => $params['id_comercio']])->andWhere(['id_producto' => $stock->id_producto])->andWhere(['fecha' => date('Y-m-d')])->one();
                         $compraProducto->setAttribute('vendidos', $vendidos);
                         $compraProducto->save();
                     }
                 } else {
                     $rutaDiariaComercioFecha = RutaDiariaComercio::find()->where('ruta_diaria_comercio.id !=' . $rutaDiariaComercio->id)->andWhere('ruta_diaria_comercio.id_ruta_diaria!=' . $rutaDiariaComercio->id_ruta_diaria)->andWhere(['ruta_diaria_comercio.id_comercio' => $rutaDiariaComercio->id_comercio])->joinWith(['idRutaDiaria' => function ($query) {
                         //$query->where('MAX(ruta_diaria.fecha)');
                         $query->groupBy('ruta_diaria.id')->having('MAX(ruta_diaria.fecha)')->orderBy('fecha DESC');
                     }])->one();
                     if ($rutaDiariaComercioFecha != null) {
                         //return "existe?:".$stock->id_producto;
                         $stockAnterior = Stock::find()->where(['id_producto' => $stock->id_producto])->andWhere(['id_ruta_diaria_com' => $rutaDiariaComercioFecha->id])->one();
                         $pedidoAnterior = Pedido::find()->where(['id_producto' => $stock->id_producto])->andWhere(['id_ruta_diaria_com' => $rutaDiariaComercioFecha->id])->one();
                         if ($stockAnterior != null) {
                             $vendidos = $stockAnterior->cantidad - $stock->cantidad;
                             if ($pedidoAnterior != null) {
                                 $vendidos = $vendidos + $pedidoAnterior->cantidad;
                             }
                             $compraProducto = new ComercioProducto();
                             $compraProducto->setAttribute('vendidos', $vendidos);
                             $compraProducto->setAttribute('id_comercio', $params['id_comercio']);
                             $compraProducto->setAttribute('id_producto', $stock->id_producto);
                             $compraProducto->setAttribute('fecha', date('Y-m-d'));
                             $compraProducto->save();
                         }
                     }
                 }
                 if ($stock->save()) {
                     $valid = true;
                 } else {
                     $valid = false;
                 }
             } else {
                 throw new BadRequestHttpException(Yii::t('mobile', 'Failed to save orders data...'));
             }
         } else {
             if ($stock->validate()) {
                 $valid = true;
             } else {
                 throw new BadRequestHttpException(Yii::t('mobile', 'Failed to save orders data...'));
             }
         }
     }
     return $valid;
 }
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getStocks()
 {
     return $this->hasMany(Stock::className(), ['id_ruta_diaria_com' => 'id']);
 }