public function loadModel($id) { $model = Calendar::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
public function getGroupCalendars() { $findParams = \GO\Base\Db\FindParams::newInstance()->select('t.*')->criteria(\GO\Base\Db\FindCriteria::newInstance()->addCondition('view_id', $this->id, '=', 'vgr')); $findParams->joinModel(array('model' => 'GO\\Base\\Model\\User', 'localField' => 'user_id', 'tableAlias' => 'usr')); $findParams->joinModel(array('model' => 'GO\\Base\\Model\\UserGroup', 'localField' => 'user_id', 'foreignField' => 'user_id', 'tableAlias' => 'usg')); $findParams->joinModel(array('model' => 'GO\\Base\\Model\\Group', 'localField' => 'group_id', 'localTableAlias' => 'usg', 'tableAlias' => 'grp')); $findParams->joinModel(array('model' => 'GO\\Calendar\\Model\\ViewGroup', 'localField' => 'id', 'localTableAlias' => 'grp', 'foreignField' => 'group_id', 'tableAlias' => 'vgr', 'criteria' => \GO\Base\Db\FindCriteria::newInstance()->addCondition('view_id', $this->id, '=', 'vgr'))); return Calendar::model()->find($findParams); }
/** * Constructor * * @param string $startDate * @param string $endDate */ public function __construct($startDate, $endDate) { $this->startDate = $startDate; $this->endDate = $endDate; $this->calendars = Calendar::model()->find()->fetchAll(); $findParams = \GO\Base\Db\FindParams::newInstance()->join('cal_events', \GO\Base\Db\FindCriteria::newInstance()->addRawCondition('t.id', 'e.category_id'), 'e')->group('t.id')->having('count(*)>0'); $calendars = array(0); foreach ($this->calendars as $calendar) { $calendars[] = $calendar->id; } $findParams->getCriteria()->addInCondition('calendar_id', $calendars); $this->categories = Category::model()->find($findParams)->fetchAll(); //GLOBAL }
public function actionUpdatedue() { if (Project::model()->updateByPk($_GET['id'], array('due_date' => "{$_GET['nilai']}"))) { $data = Calendar::model()->find("project_id = {$_GET['id']} and type='due' "); $data->due_date = $_GET['nilai']; if ($data->save()) { echo "sukses"; } } else { echo "id : " . $_REQUEST['id']; echo "nilai : " . $_REQUEST['nilai']; } }
echo '<a href="/id' . $data->id . '" class="cat-photo-img__link last"><img class="cat-photo-img" src="/img/zaglushka.png" alt="' . $data->name . ' - ' . Occupation::getName($data->occupation_id) . '"></a>'; } else { echo '<a href="/id' . $data->id . '" class="cat-photo-img__link"><img class="cat-photo-img" src="/img/zaglushka.png" alt="' . $data->name . ' - ' . Occupation::getName($data->occupation_id) . '"></a>'; } $i++; } } ?> </div> </section> <?php } //if($res==0) echo Yii::t('category','No results found.'); } else { if (!empty($_POST['calend'])) { $is_busy = Calendar::model()->countByAttributes(array('uid' => $data->id, 'day' => $_POST['calend'])); if ($is_busy <= 0) { $_SESSION['res_'] = $_SESSION['res_'] + 1; ?> <section class="wrapper photo-item"> <div class="container"> <div class="cat-item-header"> <a href="/id<?php echo $data->id; ?> "><h4 class="cat-item-user"><?php echo $data->name; ?> </h4></a> <div class="cat-item-accaunt <?php echo $data->member_type;
/** * Get's the participant's default calendar if it has one. * @return Calendar */ public function getDefaultCalendar() { if (empty($this->user_id)) { return false; } return Calendar::model()->findDefault($this->user_id); }
echo Yii::app()->homeUrl; ?> xo-so-mien-trung.html" class="btn btn-trung">Xổ Số Miền Trung</a> <div class="clearfix"></div> <?php $this->renderPartial("_tablemien"); ?> <br /> <?php $day = date("l", time()); $date = date("d-m-Y", time()); if (date("H", time()) < 16 || date("H", time()) == 16 && date("i", time()) <= 10) { $day = date("l", time() - 86400); $date = date("d-m-Y", time() - 86400); } $data = Calendar::model()->find("thu = :thu", array(":thu" => $day)); $nam = explode(",", $data->nam); $trung = explode(",", $data->trung); $bac = explode(",", $data->bac); //nam $criterianam = new CDbCriteria(); $criterianam->condition = 'date=:date'; $criterianam->params = array(':date' => $date); $criterianam->addInCondition("provice", $nam); $nam = KqxsNam::model()->findAll($criterianam); ?> <div class="panel panel-danger kq"> <div class="panel-heading">Kết quả xổ số Miền Nam - <?php echo $date; ?>
public function actionOnlinebac() { $day = date("l", time()); $date = date("d-m-Y", time()); $data = Calendar::model()->find("thu = :thu", array(":thu" => $day)); $nam = explode(",", $data->nam); $trung = explode(",", $data->trung); $bac = explode(",", $data->bac); //nam $criterianam = new CDbCriteria(); $criterianam->condition = 'date=:date'; $criterianam->params = array(':date' => $date); $criterianam->addInCondition("provice", $bac); $resultnam = KqxsBac::model()->findAll($criterianam); $this->render("onlinemienbac", array('bac' => $resultnam)); }
public function actionMn() { $day = date("l", time()); $data = Calendar::model()->find("thu = :thu", array(":thu" => $day)); $nam = explode(",", $data->nam); $trung = explode(",", $data->trung); $bac = explode(",", $data->bac); $url = 'http://minhngoc.net.vn/xstt/MN/MN.php?visit=0'; $content = file_get_contents($url); $arr = explode(";", $content); $ret = array(); foreach ($arr as $item) { $tmp = explode('=', $item); $key = $tmp[0]; $key = str_replace('kqxs["', '', $key); $key = str_replace('"]', '', $key); $key = str_replace("\r\n", '', $key); $value = end($tmp); $value = str_replace('"', '', $value); $value = preg_replace('/[^0-9]/', '', $value); $ret[$key] = $value; } if (date("d-m-Y", $ret["newtime"]) == date("d-m-Y", time())) { $tinh = explode(",", $ret["listtinhnew"]); $date = date("d-m-Y", time()); foreach ($nam as $province) { $pro = CommonHelper::maprev($province); unset($ret["\r\nT" . $pro . "_LV"]); unset($ret["\r\n"]); $proexist = KqxsNam::model()->find("date=:date and provice=:provice", array(":date" => $date, ":provice" => $province)); if (!$proexist) { $model = new KqxsNam(); $model->date = $date; $model->provice = $province; $model->db = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_Gdb"]); $model->nhat = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G1"]); $model->nhi = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G2"]); $model->ba1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_1"]); $model->ba2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_2"]); $model->tu1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_1"]); $model->tu2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_2"]); $model->tu3 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_3"]); $model->tu4 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_4"]); $model->tu5 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_5"]); $model->tu6 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_6"]); $model->tu7 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_7"]); $model->nam = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G5"]); $model->sau1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G6_1"]); $model->sau2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G6_2"]); $model->sau3 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G6_3"]); $model->bay = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G7"]); $model->tam = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G8"]); $model->insert(); } else { $proexist->db = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_Gdb"]); $proexist->nhat = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G1"]); $proexist->nhi = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G2"]); $proexist->ba1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_1"]); $proexist->ba2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_2"]); $proexist->tu1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_1"]); $proexist->tu2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_2"]); $proexist->tu3 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_3"]); $proexist->tu4 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_4"]); $proexist->tu5 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_5"]); $proexist->tu6 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_6"]); $proexist->tu7 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_7"]); $proexist->nam = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G5"]); $proexist->sau1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G6_1"]); $proexist->sau2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G6_2"]); $proexist->sau3 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G6_3"]); $proexist->bay = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G7"]); $proexist->tam = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G8"]); $proexist->update(); } } } $this->renderJSON($ret); }
public function actionCalendarChange() { $action = Yii::app()->request->getParam('action', ''); $date = Yii::app()->request->getParam('date', ''); $m = Yii::app()->request->getParam('m', ''); $returnArray = array(); $status = false; $switch = false; $msg = ''; $dateObject = DateTime::createFromFormat('Y-m-d', $date); if ($dateObject) { $modelDate = new DateTime($date); switch ($action) { case 'makeUnavailable': $switch = true; $modelStatus = 1; $modelType = 3; break; case 'makeAvailable': $switch = true; $modelStatus = 0; $modelType = 3; break; case 'removeFlag': $switch = true; $modelStatus = 0; $modelType = 1; break; case 'addFlag': $switch = true; $modelStatus = 1; $modelType = 1; break; } if ($switch) { $model = Calendar::model()->find('calendar_date = "' . $modelDate->format('Y-m-d H:i:s') . '" AND calendar_type = "' . $modelType . '" AND created_by = ' . Yii::app()->user->getInfo()); if ($model == null) { $model = new Calendar(); } $model->status = $modelStatus; $model->message = $m; $model->calendar_type = $modelType; $model->calendar_date = $modelDate->format('Y-m-d H:i:s'); $model->created_by = Yii::app()->user->getInfo(); if ($model->save()) { $status = true; $msg = 'Success'; } else { $msg = $model->getErrors(); } } } $returnArray['status'] = $status; $returnArray['msg'] = $msg; header('Content-Type: application/json'); $return = json_encode($returnArray); echo $return; Yii::app()->end(); }
foreach ($row as $i => $v) { if ($i == 5 || $i == 6) { if (!empty($v)) { $cl = 'weekend__day'; } else { $cl = 'other-month__day'; } } else { if (!empty($v)) { $cl = ''; } else { $cl = 'other-month__day'; } } if (!empty($v)) { if (Calendar::model()->countByAttributes(array('uid' => $model->id, 'day' => $year_plus . "-" . $month . "-" . $v)) > 0) { $cl .= " reserv__day"; $del1 = "1"; } else { $del1 = "0"; } } else { $del1 = "0"; } ?> <td class="<?php echo $cl; ?> "> <?php echo $v ? $v : " ";
public function actionCalendar() { // $this->layout = "//layouts/calendar"; Yii::app()->clientScript->registerCssFile(Yii::app()->theme->baseUrl . "/css/my-calendar.css"); Yii::app()->clientScript->registerCssFile(Yii::app()->theme->baseUrl . "/css/my-calendar-resp.css"); Yii::app()->clientScript->registerScriptFile(Yii::app()->theme->baseUrl . "/js/plugins/jQuery/jquery-ui.min.js", CClientScript::POS_HEAD); Yii::app()->clientScript->registerScriptFile(Yii::app()->theme->baseUrl . "/js/plugins/fullcalendar/fullcalendar.js", CClientScript::POS_END); Yii::app()->clientScript->registerScriptFile(Yii::app()->theme->baseUrl . "/js/plugins/spin/spin.js", CClientScript::POS_END); Yii::app()->clientScript->registerScriptFile(Yii::app()->theme->baseUrl . "/js/main.js", CClientScript::POS_END); Yii::app()->clientScript->registerScriptFile(Yii::app()->theme->baseUrl . "/js/my-calendar.js", CClientScript::POS_END); $returnArray = array(); $day = 60 * 60 * 24; $time = time(); $from = Yii::app()->request->getParam('from', ''); $to = Yii::app()->request->getParam('to', ''); $criteria = new CDbCriteria(); $criteria->addCondition('mstRequestUsers.user_id = ' . Yii::app()->user->getInfo()); $criteria->addCondition('mstRequestUsers.archived = 0'); // $criteria->addCondition('booking_type > 0'); if (!empty($from)) { $criteria->addCondition('bookingDate >= ' . $from); } if (!empty($to)) { $criteria->addCondition('bookingDate < ' . $to); } $criteria->with = array('mstRequestUsers'); $modelArray = Requests::model()->findAll($criteria); $eventsArray = array(); $requestsTempArray = array(); foreach ($modelArray as $model) { if ($model->booking_type > 0) { $criteria = new CDbCriteria(); $criteria->select = 'sum(amount) as amount'; $criteria->addCondition('request_id = ' . $model->id); $criteria->addCondition('status = 1'); $modelSum = Payments::model()->find($criteria); $moneyPaid = (int) $modelSum->amount; $eventsArray[] = array('id' => $model->id, 'creator' => $model->createdBy->firstName . ' ' . $model->createdBy->lastName, 'title' => ComponentString::showPart($model->map->name, 14), 'map' => ComponentString::showPart($model->map->name, 28), 'event_type' => $model->eventType->name, 'start_time' => date('H:i A', strtotime($model->start_time)), 'end_time' => date('H:i A', strtotime($model->end_time)), 'start' => $model->eventDate, 'dateName' => date('l, F d, Y', strtotime($model->eventDate)), 'allDay' => true, 'type' => $model->booking_type, 'daysTotal' => ceil((strtotime($model->eventDate) - strtotime($model->created_on)) / $day), 'daysLeft' => ceil((strtotime($model->eventDate) - $time) / $day), 'moneyPaid' => $moneyPaid, 'moneyTotal' => $model->amount); } else { $requestsTempArray[date('d-m-Y', strtotime($model->eventDate))][] = 1; } } $criteria = new CDbCriteria(); $criteria->addCondition(' (LOWER(calendarType.name) = "flag" AND t.created_by = ' . Yii::app()->user->getInfo() . ') OR (LOWER(calendarType.name) = "unavailable" AND t.created_by = ' . Yii::app()->user->getInfo() . ') OR (LOWER(calendarType.name) = "holiday") '); $criteria->addCondition('calendarType.status = 1'); $criteria->addCondition('t.status = 1'); $criteria->with = array('calendarType'); $modelArray = Calendar::model()->findAll($criteria); $flagsArray = array(); $holidaysArray = array(); $unavailableArray = array(); foreach ($modelArray as $model) { switch (strtolower($model->calendarType->name)) { case 'flag': $flagsArray[] = array('id' => $model->id, 'title' => ComponentString::showPart($model->message, 30), 'start' => $model->calendar_date); break; case 'holiday': $holidaysArray[] = array('id' => $model->id, 'title' => $model->message, 'start' => $model->calendar_date); break; case 'unavailable': $unavailableArray[] = array('id' => $model->id, 'title' => $model->message, 'start' => $model->calendar_date); break; } } $requestsArray = array(); foreach ($requestsTempArray as $key => $request) { $requestsArray[$key] = count($request); } $returnArray['events'] = $eventsArray; $returnArray['flags'] = $flagsArray; $returnArray['requests'] = $requestsArray; $returnArray['holidays'] = $holidaysArray; $returnArray['unavailable'] = $unavailableArray; $json = json_encode($returnArray); Yii::app()->clientScript->registerScript('mapvar10', "var json='" . $json . "';", CClientScript::POS_HEAD); $this->render('calendar'); }