protected function createDataArray() { \Yii::beginProfile('createDataArray'); $data = []; Yii::beginProfile('getData'); if (!$this->config['serverSide']) { $paginator = $this->dataProvider->getPagination(); if ($this->dataProvider instanceof \CActiveDataProvider) { $this->dataProvider->criteria->order = ''; } $this->dataProvider->setPagination(false); $source = $this->dataProvider->getData(true); $this->dataProvider->setPagination($paginator); } else { $source = $this->dataProvider->getData(); } Yii::endProfile('getData'); Yii::beginProfile('renderCells'); // Get column name map. $names = array_map([$this, 'getColumnName'], $this->columns); foreach ($source as $i => $r) { $row = []; foreach ($this->columns as $j => $column) { $name = $names[$j]; $row[$name] = $column->getDataCellContent($i); } $metaRow = []; if ($this->addMetaData !== false) { Yii::beginProfile('addMetaData'); if (is_callable([$r, 'getKeyString'])) { $metaRow['data-key'] = call_user_func([$r, 'getKeyString']); } if (is_array($this->addMetaData)) { foreach ($this->addMetaData as $field) { $metaRow["data-{$field}"] = \CHtml::value($r, $field); } } Yii::endProfile('addMetaData'); } if (isset($this->rowCssClassExpression)) { $metaRow['class'] = $this->evaluateExpression($this->rowCssClassExpression, array('row' => $i, 'data' => $r)); } $row['metaData'] = $metaRow; $data[] = $row; } \Yii::endProfile('renderCells'); \Yii::endProfile('createDataArray'); return $data; }
public function actionFeed() { Yii::import('aiajaya.extensions.efeed.*'); // RSS 2.0 is the default type $feed = new EFeed(); $feed->title = 'Gästebuch von ' . Yii::app()->name; $feed->description = 'Das Gästebuch vom ' . Yii::app()->name; $feed->addChannelTag('language', 'de-de'); $feed->addChannelTag('pubDate', date(DATE_RSS, time())); $feed->addChannelTag('link', $this->createAbsoluteUrl('/page/guestbook/list')); // * self reference $feed->addChannelTag('atom:link', $this->createAbsoluteUrl('/page/guestbook/feed')); $criteria = new CDbCriteria(array('order' => '`createDate` DESC')); $dataProvider = new CActiveDataProvider('Comment', array('pagination' => array('pageSize' => 0), 'criteria' => $criteria)); foreach ($dataProvider->getData() as $comment) { $item = $feed->createNewItem(); $item->title = $comment->getBaseModel()->commentName; $item->link = $this->createAbsoluteUrl('/page/page/get', array('key' => $comment->getBaseModel()->key)); $item->date = $comment->createDate; $item->description = $comment->message; $item->addTag('author', $comment->name); //$item->addTag('guid', 'http://www.ramirezcobos.com/',array('isPermaLink'=>'true')); $feed->addItem($item); } $feed->generateFeed(); Yii::app()->end(); }
public function actionGetBidHistory($id) { $dataAdapter = new CActiveDataProvider('Bidding', array('criteria' => array('condition' => 'fk_user = 1', 'limit' => '10', 'order' => 'id_bidding DESC'))); $this->apiResponse['data'] = $dataAdapter->getData(); $this->apiResponse['success'] = true; $this->sendResponse(); }
/** * Displays a particular model. * @param integer $id the ID of the model to be displayed */ public function actionView($id) { $user = User::model()->findByPk($id); $dataProvider = new CActiveDataProvider('Actions', array('criteria' => array('order' => 'complete DESC', 'condition' => 'assignedTo=\'' . $user->username . '\''))); $actionHistory = $dataProvider->getData(); $this->render('view', array('model' => $this->loadModel($id), 'actionHistory' => $actionHistory)); }
public function actionIndex() { if (Yii::app()->user->isGuest) { Yii::app()->user->loginRequired(); } $settings = array(); // Get user settings. $criteria = new CDbCriteria(array('condition' => 'uid=' . Yii::app()->user->id)); $dataProvider = new CActiveDataProvider('DashboardPortlet', array('criteria' => $criteria)); $data = $dataProvider->getData(); if (isset($data[0])) { $userSettings = unserialize($data[0]->settings); foreach ($userSettings as $class => $properties) { $settings[$properties['column']][$properties['weight']] = array('class' => $class, 'visible' => $properties['visible'], 'weight' => $properties['weight']); } foreach ($settings as $key => $value) { // Sort all portlets in every column by weight. ksort($settings[$key]); } } // Use the default portlets settings if user did not set any portlet before. if (empty($settings)) { $deaultSettings = $this->getModule()->portlets; foreach ($deaultSettings as $class => $properties) { $column = isset($properties['column']) ? $properties['column'] : 0; $settings[$column][$properties['weight']] = array('class' => $class, 'visible' => isset($properties['visible']) ? $properties['visible'] : true, 'weight' => $properties['weight']); } } $this->render('index', array('portlets' => $settings)); }
/** * getListItems - Phương thức dùng để lấy dữ liệu */ public function getListItems($category_id = null) { Yii::import('application.modules.products.models.ProductItem'); $model = new ProductItem('search'); $model->unsetAttributes(); $criteria = new CDbCriteria(); $criteria->order = 'created DESC'; if ($category_id) { Yii::import('application.modules.products.models.ProductCategory'); $categories = ProductCategory::model()->findByPk($category_id); if (!$categories) { return null; } $this->__category = $categories; $descendants = $categories->descendants()->findAll('is_active = 1'); $arrCat = array($category_id); foreach ($descendants as $cat) { $arrCat[] = $cat->id; } $criteria->with = array('categoryitem'); $criteria->together = true; foreach ($arrCat as $cat) { $criteria->compare('categoryitem.category_id', $cat, false, 'OR'); } } $criteria->compare('status', 1); $search = new CActiveDataProvider($model, array('criteria' => $criteria, 'pagination' => array('pageSize' => Yii::app()->getModule('products')->entriesShow))); $data = $search->getData(); $this->__pagination = $search->pagination; return $data; }
/** * Manages all models. */ public function actionDashboard() { /* Wall Post */ $model = new OmmuWalls(); /* Get Walll */ $criteria = new CDbCriteria(); $criteria->condition = 'publish = :publish'; $criteria->params = array(':publish' => 1); $criteria->order = 'creation_date DESC'; $dataProvider = new CActiveDataProvider('OmmuWalls', array('criteria' => $criteria, 'pagination' => array('pageSize' => 5))); $data = ''; $wall = $dataProvider->getData(); if (!empty($wall)) { foreach ($wall as $key => $item) { $data .= Utility::otherDecode($this->renderPartial('/wall/_view', array('data' => $item), true, false)); } } $pager = OFunction::getDataProviderPager($dataProvider); if ($pager[nextPage] != '0') { $summaryPager = 'Displaying 1-' . $pager[currentPage] * $pager[pageSize] . ' of ' . $pager[itemCount] . ' results.'; } else { $summaryPager = 'Displaying 1-' . $pager[itemCount] . ' of ' . $pager[itemCount] . ' results.'; } $nextPager = $pager['nextPage'] != 0 ? Yii::app()->createUrl('wall/get', array($pager['pageVar'] => $pager['nextPage'])) : 0; $this->pageTitle = Yii::t('phrase', 'Welcome') . ', ' . Yii::app()->user->displayname . '!'; $this->pageDescription = Yii::t('phrase', 'Welcome to your social network control panel. Here you can manage and modify every aspect of your social network. Directly below, you will find a quick snapshot of your social network including some useful statistics.'); $this->pageMeta = ''; $this->render('application.webs.admin.admin_dashboard', array('model' => $model, 'data' => $data, 'pager' => $pager, 'summaryPager' => $summaryPager, 'nextPager' => $nextPager)); }
public function actionExcel($id) { $po = $this->loadModel($id); $poItemCriteria = new CDbCriteria(); $poItemCriteria->with = array('material'); $poItemCriteria->compare('po_number', $id); $poItemDataProvider = new CActiveDataProvider('PoItems', array('criteria' => $poItemCriteria, 'pagination' => false)); Yii::import('ext.phpexcel.XPHPExcel'); $objPHPExcel = XPHPExcel::createPHPExcel(); $objReader = PHPExcel_IOFactory::createReader('Excel5'); $objPHPExcel = $objReader->load(Yii::app()->basePath . DIRECTORY_SEPARATOR . 'data' . DIRECTORY_SEPARATOR . "templates" . DIRECTORY_SEPARATOR . "PO_Template.xls"); $objPHPExcel->getProperties()->setCreator(Yii::app()->user->name)->setLastModifiedBy(Yii::app()->user->name)->setTitle("PO Order-" . $id); //->setSubject("Office 2007 XLSX Test Document") //->setDescription("Sales Order#") //->setKeywords("office 2007 openxml php") //->setCategory("Test result file"); // Add the data $objPHPExcel->setActiveSheetIndex(0)->setCellValue('C2', $po->po_number)->setCellValue('C3', Yii::app()->dateFormatter->formatDateTime($po->maturity_date, "short", null))->setCellValue('C4', Yii::app()->dateFormatter->formatDateTime($po->created, "short", null))->setCellValue('C5', Yii::app()->dateFormatter->formatDateTime($po->updated, "short", null))->setCellValue('E2', $po->comp->name)->setCellValue('E3', $po->contact)->setCellValue('E4', $po->contact_telephone)->setCellValue('C6', $po->paymentTerm->description)->setCellValue('C7', $po->is_open ? "Open" : "Closed")->setCellValue('A8', "Comments:\r" . $po->comments); $row = 13; //$i = 1; // Write the sale items now $items = $poItemDataProvider->getData(); foreach ($items as $item) { $objPHPExcel->setActiveSheetIndex(0)->setCellValue("B" . $row, $item->material->cat->description . "-" . $item->material->description)->setCellValue("D" . $row, $item->qty)->setCellValue("E" . $row, $item->qty_units)->setCellValue("F" . $row, $item->unit_price)->setCellValue("G" . $row, $item->price_units)->setCellValue("H" . $row, $item->qty_recieved)->setCellValue("I" . $row, $item->qty_diff); //$i++; $row++; } $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); // Redirect output to a client’s web browser //header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename=' . '"PurchaseOrder-' . $id . '.xls"'); header('Cache-Control: max-age=0'); $objWriter->save('php://output'); }
public function actionIndex() { $with = array('active_keywords'); $whereType = "and t.type='" . Globals::TYPE_REGISTRATION . "' and active_keywords.type='" . Globals::TYPE_ACTIVE . "'"; $this->layout = '//layouts/memberList'; $dataProvider = new CActiveDataProvider('ActiveModel', array('criteria' => array('order' => 't.id DESC', 'with' => $with, 'condition' => "t.wechatId = {$this->wechatInfo->id} {$whereType}", 'together' => true), 'pagination' => array('pageSize' => Page::SIZE, 'pageVar' => 'page'))); $this->render('index', array('data' => $dataProvider->getData(), 'pages' => $dataProvider->getPagination(), 'wechatInfo' => $this->wechatInfo)); }
/** * This is the default 'index' action that is invoked * when an action is not explicitly requested by users. */ public function actionIndex() { //$this->redirect('/card/index'); //$dataProvider=new CActiveDataProvider('Product'); $dataProvider = new CActiveDataProvider('Product', array('pagination' => array('pageSize' => 100))); $products = $dataProvider->getData(); $model = new Order(); $this->render('index', compact('model', 'products')); }
/** * 手机客户端的分页,防止分页重复,与网页显示无关 * @param CActiveDataProvider $dataProvider * */ public function page(CActiveDataProvider &$dataProvider, $more = true) { $total = $dataProvider->getTotalItemCount(); $pageSzie = $dataProvider->getPagination()->getPageSize(); $dataProvider->getPagination()->pageVar = 'page'; $pageCount = ceil($total / $pageSzie); if ($dataProvider->getTotalItemCount() == 0) { $this->send(ERROR_EMPTY, 'data empty', $more); } else { if (isset($_GET['page'])) { if ($pageCount >= $_GET['page']) { $this->send(0, $dataProvider->getData(), $more, array('page' => $pageCount)); } } else { $this->send(ERROR_NONE, $dataProvider->getData(), $more, array('page' => $pageCount)); } } }
/** * @param bool $ajax */ public function actionIndex($ajax = false) { if ($ajax) { $dataProvider = new CActiveDataProvider('SurveillanceSections', ['criteria' => ['condition' => "tool='surveillance'", 'select' => 'sectionId, sectionName, description']]); echo CJSON::encode(['aaData' => $dataProvider->getData()]); return; } $this->render('index'); }
public function getRoomTypeList() { $dataProvider = new CActiveDataProvider('RoomType'); $roomTypes = $dataProvider->getData(); $roomTypesDropdown = array(); foreach ($roomTypes as $roomType) { $roomTypesDropdown[$roomType->id] = $roomType->description; } }
public function actionIndex() { $roleDataProvider = new CActiveDataProvider('AuthItem', array('criteria' => array('condition' => 'type=2'))); echo '<pre>'; var_dump($roleDataProvider->getData()); echo '</pre>'; exit; $this->render('index'); }
public function run($args) { ignore_user_abort(true); set_time_limit(0); $dataProvider = new CActiveDataProvider('Category', array('criteria' => array('order' => 'id ASC'), 'pagination' => false)); foreach ($dataProvider->getData() as $category) { echo $category->name; } }
/** * 将page组装成nav item * Enter description here ... */ public static function getPageItems() { $pageDataProvider = new CActiveDataProvider('BottomText', array('criteria' => array('order' => 'weight asc '))); $items = array(); foreach ($pageDataProvider->getData() as $page) { $item['content'] = $page->content; $items[] = $item; } return $items; }
public function actionFindUser($group, $term) { $dataProvider = new CActiveDataProvider('User', array('criteria' => array('select' => array('id', 'email')), 'pagination' => array('pageSize' => 500))); $criteria = $dataProvider->getCriteria(); $criteria->compare('email', $term, true); $result = CHtml::listData($dataProvider->getData(), 'id', 'email'); $members = Yii::app()->db->createCommand()->select('userid')->from(AuthAssignment::model()->tableName())->where('itemname=:group', array(':group' => $group))->queryColumn(); echo CJSON::encode(array_diff_key($result, array_flip($members))); Yii::app()->end(); }
/** * Lists all models. * @param $ajax bool */ public function actionIndex($ajax = false) { if ($ajax) { $dataProvider = new CActiveDataProvider('EconomicMethods', ['criteria' => ['with' => ['econMethodGroup']]]); // print_r($dataProvider->getData()); die; echo json_encode(['aaData' => ModelToArray::convertModelToArray($dataProvider->getData())]); return; } $this->render('index'); }
/** * Lists all models. * @param $ajax bool */ public function actionIndex($ajax = false) { if ($ajax) { $dataProvider = new CActiveDataProvider('EvaAttributesAssessmentMethods', ['criteria' => ['with' => ['evaAttributes']]]); //print_r(ModelToArray::convertModelToArray($dataProvider->getData())); die; echo json_encode(['aaData' => ModelToArray::convertModelToArray($dataProvider->getData())]); return; } $this->render('index'); }
public function actionUser() { $this->layout = '//layouts/list'; $group = GroupModel::model()->findall(); foreach ($group as $v) { $groupList[$v->group_id] = $v->name; } $dataProvider = new CActiveDataProvider('UserModel', array('criteria' => array('order' => 'uid desc'), 'pagination' => array('pageSize' => Page::SIZE))); $this->render('userList', array('data' => $dataProvider->getData(), 'pages' => $dataProvider->getPagination(), 'group' => $groupList)); }
public function actionIndex($confirm = 0) { $this->layout = '//layouts/column1'; if ($confirm) { $this->render('cvconfirm'); } else { $formModel = new JobForm(); $cvModel = new JobCv(); $job = new Job(); $jobProvider = new CActiveDataProvider('Job', array('criteria' => array('condition' => 'active = 1', 'order' => 'category_id ASC, title ASC'), 'pagination' => false)); $jobCategory = JobCategory::model()->findAll(); foreach ($jobProvider->getData() as $data) { $formModel->{$data['id']} = null; } if (isset($_POST['JobForm'])) { $listJob = '<ul>'; $oneChecked = false; foreach ($_POST['JobForm'] as $key => $item) { if (is_numeric($key) && $item == '1') { $oneChecked = true; $jobChecked = Job::model()->findByPk($key); $listJob .= '<li>' . $jobChecked->title . ' (' . $jobChecked->category->name . ')</li>'; } } $listJob .= '</ul>'; $cvModel->date = date('Y-m-d H:i:s'); $cvModel->cv = $_POST['JobCv']['cv']; if (!$oneChecked) { $cvModel->addError('cv', Yii::t('jobModule.common', 'Vous devez cocher au moins un emploi')); } elseif ($cvModel->save()) { foreach ($_POST['JobForm'] as $attribute => $value) { if (is_numeric($attribute) && $value == '1') { $jobId = (int) $attribute; Yii::app()->db->createCommand('INSERT INTO job_job_cv (job_id, job_cv_id) VALUES (:job_id, :job_cv_id)')->execute(array(':job_id' => $jobId, ':job_cv_id' => $cvModel->id)); } } $subject = 'Postulation pour une offre d’emploi'; $body = ' <p>Bonjour,<br/><br/> Vous avez reçu une candidature pour un ou plusieurs emplois à partir du site Web d`Arianne Phosphate Inc.<br/> ' . $listJob . '<br/> <a href="' . $this->createAbsoluteUrl('admincv/read', array('id' => $cvModel->id)) . '">Voir les détails de la candidature</a><br/><br/> </p> '; $attachment = "./" . $cvModel->cvHandler->dir . "/" . Helper::encodeFileName($cvModel->cv); if (($mailerError = Helper::sendMail($this->module->cvEmail, $subject, $body, $attachment)) !== true) { throw new CHttpException(500, $mailerError); } $this->redirect($this->createUrl('index', array('confirm' => 1))); } } $this->render('index', array('jobProvider' => $jobProvider, 'categories' => $jobCategory, 'formModel' => $formModel, 'cvModel' => $cvModel)); } }
public function actionSelfquestion() { $criteria = new CDbCriteria(); $criteria->order = 'ID DESC'; $criteria->addCondition("Promoter = '" . Yii::app()->user->getOrganID() . "'"); //接收表单数据(查询条件) $title = Yii::app()->request->getParam("Title"); $organName = Yii::app()->request->getParam("OrganName"); $state = Yii::app()->request->getParam("State"); if (!empty($title)) { $criteria->addSearchCondition("Title", "{$title}"); } if (!empty($organName)) { $criteria->addSearchCondition("OrganName", "{$organName}"); } if (!empty($state)) { $criteria->addCondition("State = {$state}"); } $dataProvider = new CActiveDataProvider('Question', array('criteria' => $criteria, 'pagination' => array('pageSize' => '15'))); $data = $dataProvider->getData(); foreach ($data as $key => $val) { $val['SubmitTime'] = date("Y-m-d h:i:s", $val['SubmitTime']); //状态 if ($val['State'] == 1) { $val['State'] = "待分配"; } elseif ($val['State'] == 2) { $val['State'] = "待解答"; } elseif ($val['State'] == 3) { $val['State'] = "待反馈"; } elseif ($val['State'] == 4) { $val['State'] = "完结"; } elseif ($val['State'] == 5) { $val['State'] = "重新开启"; } elseif ($val['State'] == 6) { $val['State'] = "待回访"; } //类型 if ($val['Type'] == 1) { $val['Type'] = "账号问题"; } elseif ($val['Type'] == 2) { $val['Type'] = "交易问题"; } elseif ($val['Type'] == 3) { $val['Type'] = "商品问题"; } elseif ($val['Type'] == 4) { $val['Type'] = "数据问题"; } elseif ($val['Type'] == 5) { $val['Type'] = "意见和建议"; } elseif ($val['Type'] == 6) { $val['Type'] = "其他"; } } $this->render("selfquestion", array('dataProvider' => $dataProvider, 'title' => $title, 'organName' => $organName, 'state' => $state)); }
/** * Lists all models. */ public function actionIndex($controller, $alias = NULL) { if ($alias != NULL) { $model = new News(); $criteria = new CDbCriteria(); $criteria->join = 'INNER JOIN menu c ON c.id = t.idmenu'; $criteria->condition = 'c.alias="' . $alias . '"' . ' AND c.controller ="' . $controller . '"'; $criteria->order = 'datecreate DESC'; $dataProvider = new CActiveDataProvider('News', array('criteria' => $criteria, 'pagination' => array('pageSize' => 3))); $model = $dataProvider->getData(); $this->render('index', array('dataProvider' => $dataProvider, 'model' => $model)); } }
protected function getArticleTags($id) { $tag = array(); $criteria = new CDbCriteria(array('alias' => '_articletags', 'condition' => '_articletags.article_id=' . $id, 'with' => array('tags' => array('alias' => '_tags', 'order' => 'tag')))); $dataProvider = new CActiveDataProvider('Articletags', array('criteria' => $criteria)); foreach ($dataProvider->getData() as $tags) { $_tagsId = $tags['tags']['tag_id']; $_tagName = $tags['tags']['tag']; $tag[$_tagsId] = $_tagName; } $tag = implode($tag, ','); return $tag; }
/** * Displays a particular model. * @param integer $id the ID of the model to be displayed */ public function actionView($id) { $model = $this->loadModel($id); $criteria = new CDbCriteria(); $criteria->compare('invoice_id', $id); $invoice_transaction = new CActiveDataProvider('Transaction', array('criteria' => $criteria)); $total_amount = 0; foreach ($invoice_transaction->getData() as $key) { $total_amount = $total_amount + $key->total; } $criteriaCustomer = new CDbCriteria(); $criteriaCustomer->compare('id', $model->customer_id); $customer = new CActiveDataProvider('Customer', array('criteria' => $criteriaCustomer)); $this->render('view', array('customer' => $customer, 'model' => $model, 'invoice_transaction' => $invoice_transaction, 'total_amount' => $total_amount)); }
public function actionIndex($to_user_id = null) { $to_user = User::model()->throw404IfNull()->findByPk($to_user_id); $user_id = Yii::app()->user->id; $criteria = new CDbCriteria(); $criteria->order = 'date_create DESC'; $criteria->addCondition("to_user_id = {$user_id} OR from_user_id = {$user_id}"); if ($to_user_id) { $criteria->addCondition("to_user_id = {$to_user_id} OR from_user_id = {$to_user_id}"); } $data_provider = new CActiveDataProvider('Message', array('criteria' => $criteria)); $messages = $data_provider->getData(); krsort($messages); $this->render('index', array('messages' => $messages, 'to_user' => $to_user)); }
public function renderKanban() { $data = $this->dataProvider->getData(); $n = count($data); echo "<ul class=\"kanban-ul\">\n"; if ($n > 0) { for ($i = 0; $i < $n; ++$i) { $this->renderCard($i); } } else { $this->renderEmptyText(); } echo "</ul>\n"; echo "<div class=\"clearfix\"></div>\n"; }
public function actionIndex() { $OrganID = Yii::app()->user->getOrganID(); $criteria = new CDbCriteria(); $arr['LicensePlate'] = Yii::app()->request->getParam("LicensePlate"); $arr['ReserveTime'] = Yii::app()->request->getParam("ReserveTime"); $ReserveTime = strtotime($arr['ReserveTime']); $arr['ReserveNum'] = Yii::app()->request->getParam("ReserveNum"); // $arr['Make'] = Yii::app()->request->getParam("Make"); $arr['Car'] = Yii::app()->request->getParam("Car"); $arr['Code'] = Yii::app()->request->getParam("Code"); // $arr['Engine'] = Yii::app()->request->getParam("Engine"); if (!empty($arr['LicensePlate'])) { // 车牌号 $criteria->addSearchCondition('licenseplate', "{$arr['LicensePlate']}", "AND"); } // if (!empty($arr['Make'])) {// 厂家 // $criteria->addSearchCondition('Make', "{$arr['Make']}", "AND"); // } if (!empty($arr['Code'])) { // 车型编码 $criteria->addCondition("Code = '{$arr['Code']}'", "AND"); } // if (!empty($arr['Engine'])) {// 发动机 // $criteria->addSearchCondition('Engine', "{$arr['Engine']}", "AND"); // } if (!empty($arr['ReserveTime'])) { // 预约时间 $criteria->addSearchCondition('ReserveTime', "{$ReserveTime}", "AND"); } if (!empty($arr['ReserveNum'])) { // 预约号 $criteria->addSearchCondition('ReserveNum', "{$arr['ReserveNum']}", "AND"); } $criteria->order = "t.ID DESC"; //排序条件:t.CreateTime,t.ID倒叙 $criteria->addCondition("t.OrganID = {$OrganID}"); $dataProvider = new CActiveDataProvider('ServiceReserve', array('criteria' => $criteria, 'pagination' => array('pageSize' => '10'))); $data = $dataProvider->getData(); //var_dump($data);die; foreach ($data as $key => $val) { $val['ReserveTime'] = date("Y-m-d", $val['ReserveTime']) . " " . $val['BeginTime'] . ":00-" . $val['EndTime'] . ":00"; } $dataProvider->setData($data); $this->render('index', array('dataProvider' => $dataProvider, 'arr' => $arr)); }
public function actionReplay() { $this->layout = '/layouts/memberList'; $type = Yii::app()->request->getParam('type'); $type = $type ? $type : GiftModel::TYPE_KEYWORDS; switch ($type) { case GiftModel::TYPE_KEYWORDS: $with = array('open_keywords', 'open_openPlatForm'); $whereType = " and t.type ='" . GiftModel::TYPE_KEYWORDS . "' and open_keywords.type='" . OpenReplayModel::OPEN_TYPE . "'"; break; case GiftModel::TYPE_MENU: $with = array('open_menuaction', 'open_openPlatForm'); $whereType = " and t.type ='" . GiftModel::TYPE_MENU . "'"; break; } $dataProvider = new CActiveDataProvider('OpenReplayModel', array('criteria' => array('order' => 't.id DESC', 'with' => $with, 'condition' => "t.wechatId = {$this->wechatInfo->id} {$whereType}", 'together' => true), 'pagination' => array('pageSize' => Page::SIZE, 'pageVar' => 'page'))); $this->render('replay', array('data' => $dataProvider->getData(), 'pages' => $dataProvider->getPagination(), 'type' => $type, 'wechatInfo' => $this->wechatInfo)); }
public function actionIndex() { $type = Yii::app()->request->getParam('type'); $type = $type ? $type : Globals::TYPE_KEYWORDS; switch ($type) { case Globals::TYPE_KEYWORDS: $with = array('wheel_keywords'); $whereType = "and t.type='" . Globals::TYPE_KEYWORDS . "'\n and wheel_keywords.type='" . Globals::TYPE_WHEEL . "'"; break; case Globals::TYPE_MENU: $with = array('wheel_menuaction'); $whereType = "and t.type='" . Globals::TYPE_MENU . "'"; break; } $this->layout = '//layouts/memberList'; $dataProvider = new CActiveDataProvider('WheelModel', array('criteria' => array('order' => 't.id DESC', 'with' => $with, 'condition' => "t.wechatId = {$this->wechatInfo->id} {$whereType}", 'together' => true), 'pagination' => array('pageSize' => Page::SIZE, 'pageVar' => 'page'))); $this->render('index', array('data' => $dataProvider->getData(), 'pages' => $dataProvider->getPagination(), 'type' => $type, 'wechatInfo' => $this->wechatInfo)); }