Пример #1
0
 /**
  * load controller model
  * @param int $id
  * @return PfOrderItemNotes
  * @throws CHttpException|
  */
 public function loadModel($id)
 {
     $m = PfOrderItemNotes::model();
     // apply scope, if available
     $scopes = $m->scopes();
     if (isset($scopes[$this->scope])) {
         $m->{$this->scope}();
     }
     $model = $m->findByPk($id);
     if ($model === null) {
         throw new CHttpException(404, Yii::t('LdmModule.crud', 'The requested page does not exist.'));
     }
     return $model;
 }
Пример #2
0
 * person list for 
 */
pfOrder::$lists['pprs'] = CHtml::listData(PprsPerson::model()->findAll(), 'pprs_id', 'itemLabel');
/**
 * order items list
 */
$criteria = new CDbCriteria();
$criteria->compare('order_id', $model->primaryKey);
$orderItems = PfOrderItems::model()->searchClient($criteria)->getData();
unset($criteria);
$tableRows = [];
/**
 * for notes filter
 */
$userPersonId = Yii::app()->getModule('user')->user()->profile->person_id;
$header = ['manufakturer_ccmp_id' => 'Manufacturer', 'planed_ready_date' => 'Planed ready date', 'load_meters' => 'Load meters', 'm3' => 'Cubic meters', 'notes' => 'Notes'];
foreach ($orderItems as $oi) {
    $tableRows[] = ['manufakturer_ccmp_id' => pfOrder::$lists['ccmp'][$oi->manufakturer_ccmp_id], 'planed_ready_date' => $oi->planed_ready_date, 'load_meters' => $oi->load_meters, 'm3' => $oi->m3, 'notes' => $oi->notes];
    $notesCriteria = new CDbCriteria();
    $notesCriteria->condition = "t.from_pprs_id = " . $userPersonId . " OR t.to_pprs_id=" . $userPersonId;
    $notesCriteria->compare('t.order_item_id', $oi->primaryKey);
    $notes = PfOrderItemNotes::model()->findAll($notesCriteria);
    $noteRows = [];
    foreach ($notes as $note) {
        $noteRows[] = ['created' => $note->created, 'from_pprs_id' => pfOrder::$lists['pprs'][$note->from_pprs_id], 'to_pprs_id' => pfOrder::$lists['pprs'][$note->to_pprs_id], 'message' => $note->message, 'readed' => $note->readed];
    }
    if (!empty($noteRows)) {
        $tableRows[] = ['manufakturer_ccmp_id' => null, 'planed_ready_date' => ['type' => tlbExcel::DATA_TYPE_TABLE, 'header' => ['created' => 'Created', 'from_pprs_id' => 'From', 'to_pprs_id' => 'To', 'message' => 'Message', 'readed' => 'Readed'], 'rows' => $noteRows]];
    }
}
$this->widget('tlbExcel', ['id' => 'excel-grid', 'title' => $title, 'creator' => Yii::app()->user->first_name . ' ' . Yii::app()->user->last_name, 'filename' => 'Orders_ ' . $model->number . '_' . date('Ymd_His'), 'subject' => mb_convert_encoding($title, 'ISO-8859-1', 'UTF-8'), 'lastModifiedBy' => Yii::app()->user->first_name . ' ' . Yii::app()->user->last_name, 'sheetTitle' => $title, 'keywords' => '', 'category' => '', 'landscapeDisplay' => true, 'A4' => true, 'pageFooterText' => '&RThis is page no. &P of &N pages', 'decimalSeparator' => '.', 'thousandsSeparator' => '', 'borderColor' => '000000', 'bgColor' => 'FFFFFF', 'textColor' => '000000', 'rowHeight' => 20, 'headerBorderColor' => '000000', 'headerBgColor' => 'FFFF00', 'headerTextColor' => '0000FF', 'headerHeight' => 30, 'footerBorderColor' => '000000', 'footerBgColor' => 'FFFF00', 'footerTextColor' => '000000', 'footerHeight' => 30, 'zoomScale' => 100, 'caption' => '', 'data' => [['type' => tlbExcel::DATA_TYPE_CAPTION, 'x' => 1, 'y' => 1, 'width' => 9, 'caption' => $title], ['type' => tlbExcel::DATA_TYPE_VIEW_MODEL, 'x' => 1, 'y' => 3, 'model' => $model, 'attributes' => [['name' => 'number'], ['name' => 'client_ccmp_id'], ['name' => 'order_date'], ['name' => 'desired_date'], ['name' => 'planed_delivery_type', 'value' => $model->clientCcmp ? $model->clientCcmp->ccmp_name : ''], ['name' => 'groupage'], ['name' => 'loading_meters'], ['name' => 'm3'], ['name' => 'planed_dispatch_date'], ['name' => 'planed_delivery_date'], ['name' => 'status', 'value' => $model->getEnumColumnLabel('status')], ['name' => 'loading_meters'], ['name' => 'notes']]], ['type' => tlbExcel::DATA_TYPE_TABLE, 'x' => 3, 'y' => 3, 'header' => $header, 'rows' => $tableRows]]]);