/**
  * Lists all Listofgoods models.
  * @return mixed
  */
 public function actionIndex()
 {
     $searchModel = new ListofgoodsSearch();
     $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
     return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]);
 }
Exemple #2
0
 public function actionDbtofile()
 {
     $filename = 'OrdersFile/test.txt';
     //модель и провайдер для передачи во view
     $orderSearch = new OrdersSearch();
     $dpOrder = $orderSearch->search(Yii::$app->request->queryParams);
     //модель для работы с текущими заказами
     $orders = Orders::find()->where(['status' => 'Размещен'])->all();
     $w = fopen($filename, 'w');
     //открываем файл для записи
     foreach ($orders as $dt) {
         //echo $dt['order_id'];
         $sm = new ListofgoodsSearch();
         $dp = $sm->search(Yii::$app->request->queryParams, $dt['order_id']);
         foreach ($dp->models as $mod) {
             $strtofile = '';
             $strtofile .= $dt['order_id'] . ';';
             $strtofile .= $dt['order_timestamp'] . ';';
             $strtofile .= $dt['customersCustomer']['customer_name'] . ';';
             $strtofile .= $mod['goodsGoodId']['good_name'] . ';';
             $good_price = $mod['goodsGoodId']['good_price'] / 100;
             $strtofile .= $good_price . ';';
             $strtofile .= $mod['good_count'] . ';';
             $strtofile .= "\r\n";
             fputs($w, $strtofile);
             //пишем в файл строку
         }
         $dt->status = 'Обработан';
         $dt->save();
     }
     fclose($w);
     //закрываем файл
     //$this->fileDownload();
     return $this->render('index_adm', ['searchModel' => $orderSearch, 'dataProvider' => $dpOrder, 'getFile' => TRUE]);
 }
Exemple #3
0
    } else {
        return ['onclick' => 'window.location.href="' . Url::toRoute(['orders/view', 'id' => $model->order_id]) . '"; return false', 'style' => 'cursor:pointer'];
    }
}, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'order_id', 'order_timestamp', ['attribute' => 'user_id', 'value' => 'usersUser.fullname'], ['attribute' => 'customers_customer_id', 'value' => 'customersCustomer.customer_name'], ['attribute' => 'order_amount', 'value' => function ($model) {
    return $model->order_amount / 100;
}], 'status']]);
?>
    <?php 
Pjax::end();
?>
    <?php 
//тут я тренируюсь выгружать данные в файл
$order = new Orders();
$orders = $order->find()->where(['status' => 'Размещен'])->all();
foreach ($orders as $dt) {
    //print_r($dt);
    $sm = new ListofgoodsSearch();
    $dp = $sm->search(Yii::$app->request->queryParams, $dt['order_id']);
    foreach ($dp->models as $mod) {
        echo ' ' . $dt['order_id'];
        echo ' ' . $dt['customersCustomer']['customer_name'];
        echo ' ' . $mod['goodsGoodId']['good_name'];
        $good_price = $mod['goodsGoodId']['good_price'] / 100;
        echo ' ' . $good_price;
        echo '<br>';
    }
}
?>

</div>