/** * 进行登录 */ public function todoAction() { // 参数检查 try { $request = $this->getRequest(); $username = $request->get('username'); $password = $request->get('password'); } catch (\Exceptions\Multi $e) { $this->json(FALSE, '手机号或密码格式不正确', 20001); } // 用户检查 $adminModel = new \AdminModel(); $adminArr = $adminModel->where('username=:u and password=:p and status=1', $username, $adminModel->enctypePassword($password))->limit(1)->select()->fetchRow(); if (!$adminArr) { $this->json(FALSE, '手机号或密码错误', 20002, $adminModel->enctypePassword($password)); } // 获取用户权限 $groupModel = new \GroupModel(); $groupArr = $groupModel->where('id=:id', $adminArr['group_id'])->select()->fetchRow(); // 计算用户权限 if ($groupArr['id'] != '*') { $rules = $adminArr['attach_rules'] ? explode(',', $adminArr['attach_rules']) : array(); $rules = implode(',', array_merge(explode(',', $groupArr['rules']), $rules)); } // 保存用户权限 $session = $this->getSession(); $session->set('admin.uid', $adminArr['id']); $session->set('admin.name', $adminArr['nickname']); $session->set('admin.ip', IP::client()); $session->set('admin.time', time()); $session->set('admin.avatar', $adminArr['avatar']); $session->set('admin.rules', $rules); // 登录成功返回 $this->json(TRUE, '登录成功', 20010); }
static function add($data) { if (!$data) { return false; } $model = new GroupModel(); $result = $model->add($data); return $result; }
public function IndexAction() { Site::$keywords = $this->company->tags; Site::$title = $this->company->name . ' на PromSpace'; $group_tags_array = GroupModel::GetList(); $region_tags_array = RegionModel::GetList(); $region_tags_array[0] = 'Вся Россия'; $group_tags_array[0] = 'Не определено'; $products = ProductModel::GetAll()->where('company_id = ?', [0 => $this->company->id]); $contacts = array(); if (!User::isLogged()) { if ($this->company->open == 2) { $contacts = ContactsModel::GetAll()->where('company_id = ?', [0 => $this->company->id]); } $this->render('nologged', ['company' => $this->company, 'group_tags' => $group_tags_array, 'region_tags' => $region_tags_array, 'contacts' => $contacts, 'products' => $products, 'simmilar' => $this->GetSimmilar()]); } elseif ($this->company->id == User::company() or User::admin()) { if ($this->company->logo == '') { Site::Message('Мы рекомендуем Вам установить логтип для профиля, это сделает его более привлекательным для клиентов'); } $contacts = ContactsModel::GetAll()->where('company_id = ?', [0 => $this->company->id]); $this->render('edit', ['company' => $this->company, 'group_tags' => $group_tags_array, 'region_tags' => $region_tags_array, 'contacts' => $contacts, 'products' => $products, 'simmilar' => $this->GetSimmilar()]); } else { if ($this->company->open == 0 and FavoriteModel::i_friend($this->company->id) or $this->company->open > 0) { $contacts = ContactsModel::GetAll()->where('company_id = ?', [0 => $this->company->id]); } $this->render('index', ['company' => $this->company, 'group_tags' => $group_tags_array, 'region_tags' => $region_tags_array, 'favorite' => FavoriteModel::my_friend($this->company->id) ? 'favorite.png' : 'star.png', 'contacts' => $contacts, 'products' => $products, 'simmilar' => $this->GetSimmilar()]); } }
/** * url GET /v2/groups * @api * @return string * @throws ApiException */ public function groupsAction() { $allowFilters = ['offset' => true, 'limit' => true]; $allowSearch = ['query' => true]; $params = $this->_fc->getParams(); $filter = $this->_fc->getFilter(); $search = $this->_fc->getSearch(); // check filter if ($filter != null) { Utilities::checkFilters($filter, $allowFilters); } if ($search != null) { Utilities::checkFilters($search, $allowSearch); } if (isset($params[0])) { if ($search == null) { $this->data = GroupModel::getByNameOrId($params[0]); } } else { if ($search == null) { $data = GroupModel::getAll($filter['offset'], $filter['limit']); $this->data = $data['data']; $this->meta = $data['meta']; } else { $search['query'] = str_replace('%', '', $search['query']); $search['query'] = urldecode($search['query']); $this->data = GroupModel::searchByName($search['query']); } } return $this->send(200); }
/** * @desc 分享联赛数据 */ public function actionLeagueData() { $leagueId = Yii::app()->request->getQuery('league', ''); $teamModel = new TeamModel(); //找到联赛中的球队 $leagueTeams = $teamModel->findRowsByRelation("teams", "League", $leagueId); $groupModel = new GroupModel(); $leagueStatModel = new LeagueScoreStatModel(); $groupTeams = array(); $groupTeamsArr = array(); //先找到联赛中的组 $groupRows = $groupModel->findGroupTeamsByLeague($leagueId); //查找联赛中球队的积分信息 $leagueStatTeams = $leagueStatModel->findTeamByLeagueId($leagueId); if (isset($leagueStatTeams[0]->league->name)) { $leagueName = $leagueStatTeams[0]->league->name; } else { $leagueName = '未知联赛'; } foreach ($groupRows as $group) { $groupId = $group->objectId; //找到每个组的球队 $groupRelTeams = $teamModel->findRowsByRelation("teams", "Group", $groupId); $groupSortTeams = array(); foreach ($leagueStatTeams as $statTeam) { foreach ($groupRelTeams as $team) { $team->groupName = $group->name; $team->groupObjectId = $group->objectId; foreach ($leagueTeams as $lTeam) { if ($lTeam->objectId == $team->objectId) { $lTeam->selected = 1; } } if (isset($statTeam->team->objectId)) { if ($statTeam->team->objectId == $team->objectId) { $team->stat = $statTeam; array_push($groupSortTeams, $team); } } } } $group->relteams = $groupSortTeams; $groupTeamsArr = $groupRelTeams; array_push($groupTeams, $groupTeamsArr); } $this->render('leagueData', array('leagueTeams' => $leagueTeams, 'groupRows' => $groupRows, "groupTeams" => $groupTeams, 'leagueName' => $leagueName)); }
private static function getAuthInfo() { if (!isset($_SESSION['authority'])) { Sys::D('Group'); $_SESSION['authority'] = GroupModel::getInheritRule($_SESSION['userinfo']['group_id']); } return true; }
private function ShowList($list) { $groups_array = GroupModel::GetList(); $groups_array[0] = 'Не определено'; $regions_array = RegionModel::GetList(); $regions_array[0] = 'Вся Россия'; $companys = SQL::Query('SELECT * FROM `companys` WHERE `id` IN (' . $list . ') ORDER BY `rate` DESC')->fetchAll(PDO::FETCH_OBJ); $this->Render('index', ['company' => $this->company, 'companys' => $companys, 'group_tags' => $groups_array, 'region_tags' => $regions_array]); }
public function IndexAction() { $top = CompanyModel::GetAll('id, name')->order('rate DESC', 10); $top_groups = GroupModel::GetAll('id, name')->order('qty DESC', 10); $last_company = CompanyModel::GetObj()->where('id = (select max(id) from companys)'); $products = SQL::Query('SELECT * FROM `products` ORDER BY id DESC LIMIT 3')->fetchAll(PDO::FETCH_OBJ); $company_count = SQL::Query('SELECT count(*) as total FROM `companys`')->fetch(PDO::FETCH_OBJ)->total; $groups_count = SQL::Query('SELECT count(*) as total FROM `groups`')->fetch(PDO::FETCH_OBJ)->total; Site::$sub = '<div class="div30 center">' . "\n" . 'Компаний на портале <h1><a href="' . Site::Link('list') . '">' . $company_count . '</a></h1>' . "\n" . '</div>' . "\n" . '<div class="div30 center">' . "\n" . 'Сфер деятельности <h1><a href="' . Site::Link('list/setgroup') . '">' . $groups_count . '</a></h1>' . "\n" . '</div>' . "\n"; $this->render('index', ['top_arr' => $top, 'top_groups' => $top_groups, 'last' => $last_company, 'products' => $products]); }
/** * @desc 删除球队 */ public function actionDeleteTeam() { $masterId = CommonFunction::getUserId(); $leagueId = Yii::app()->request->getPost('leagueId'); $teamId = Yii::app()->request->getPost('teamId'); if (empty($leagueId) || empty($teamId)) { CommonFunction::ajaxResult(State::$SYS_PARAM_ERROR_CODE, State::$SYS_PARAM_ERROR_MSG); } $leagueModel = new LeagueModel(); $groupModel = new GroupModel(); $Groups = $groupModel->findByLeagueId($leagueId); if (empty($Groups)) { $res = $leagueModel->removeRelation('teams', 'Team', $leagueId, $teamId); if (isset($res->updatedAt)) { $resM = $leagueModel->findByMaster($masterId, 1); $teamModel = new TeamModel(); $leagueTeams = $teamModel->findRowsByRelation("teams", "League", $resM[0]->objectId); $deleteTeam = $teamModel->findTeamByObjectId($teamId); if (isset($deleteTeam[0]->captain->username)) { $uid = $deleteTeam[0]->captain->username; $pushMsg = '你的球队:' . $deleteTeam[0]->name . ',已被联赛【' . $resM[0]->name . '】移除出联赛'; CommonFunction::pushAppMsg($uid, $pushMsg); // $device = new InstallationModel(); // $msg = $device->findByUid($uid); // if(isset($msg[0]) && !empty($msg[0])){ // $deviceMsg = $msg[0]; // $push = new PushMsgModel(); // $pushMsg = '你的球队:'.$deleteTeam[0]->name.',已被联赛【'.$resM[0]->name.'】移除出联赛'; // if(isset($deviceMsg->deviceToken) && isset($deviceMsg->deviceType) && $deviceMsg->deviceType == 'ios'){ // $push->createIosPush($deviceMsg->deviceToken,$pushMsg); // }elseif(isset($deviceMsg->installationId) && isset($deviceMsg->deviceType) && $deviceMsg->deviceType == 'android'){ // $push->createAndroidPush($deviceMsg->installationId,$pushMsg); // } // } } } CommonFunction::ajaxResult(State::$SUSSION_CODE, State::$SUSSION_MSG, array('leagueTeams' => $leagueTeams)); } else { CommonFunction::ajaxResult(State::$TEAM_DELETE_ERROR_CODE, State::$TEAM_DELETE_ERROR_MSG); } }
public function DeletemyaccountAction() { if (!UserModel::CheckPassword(User::GetID(), Request::post('oldpass'))) { Site::Message('Пароль указан не верно'); $this->Render('index', ['company' => $this->company]); } else { GroupModel::Dec($this->company->group_id); CompanyModel::DeleteCompany($this->company->id); Site::Message('Ваш профиль был полностью удалён с сайта, мы очень сожалеем =( '); $this->route(); } }
public function DeleteAction() { $id = Request::get('id', 0); $company = CompanyModel::GetObj()->id($id); if ($company->id > 0) { GroupModel::Dec($company->group_id); CompanyModel::DeleteCompany($company->id); Site::Message('Компания ' . $company->name . ' успешно удалена'); $this->route('list'); } else { Site::Message('Ошибочный идентификатор компании'); $this->route(); } }
public function beforeAction($action) { if (parent::beforeAction($action)) { if (Yii::app()->user->isGuest) { $this->redirect(array('site/login')); } else { $userInfo = MemberModel::model()->find('username=:username', array(':username' => Yii::app()->user->name)); foreach (GroupModel::model()->findAll() as $g) { $group[$g->id] = $g; } Yii::app()->session['group'] = $group; Yii::app()->session['userInfo'] = array('uid' => $userInfo->uid, 'username' => $userInfo->username, 'nickname' => $userInfo->nickname, 'lv' => $userInfo->lv, 'groupId' => $userInfo->groupId); } } return true; }
public static function GetUserMenu() { $userInfo = Yii::app()->session['userInfo']; $groupInfo = GroupModel::model()->find(array('condition' => 'group_id=:group_id', 'params' => array('group_id' => $userInfo['group_id']))); $actionArray = explode(',', $groupInfo->action); $menuList = self::$menuList; foreach ($menuList as $k => $m) { if (!in_array($m['act'], $actionArray)) { unset($menuList[$k]); foreach ($m['action'] as $sk => $subMenu) { if (!in_array($subMenu['act'], $actionArray)) { unset($menuList[$k]['action'][$sk]); } } } } return $menuList; }
public function getPurviewsByOwner($group_id, $user_id) { $_r = array(); // $role = GroupModel::inst()->getGroupsByCache($group_id); $group_purviews = json_decode($role['purviews'], true); // $user = UserModel::inst()->getUserById($user_id); $user_purviews = json_decode($user['purviews'], true); //合并权限 $purviews = is_array($group_purviews) ? array_merge($group_purviews, $user_purviews) : $user_purviews; // $_r = array(); foreach ($this->getPurviewsByCache() as $_k => $_v) { if ($role['purviews'] == 'all' || in_array($_v['purview_id'], $purviews)) { $_r[] = $_v; } } return $_r; }
/** * Updates a particular model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id the ID of the model to be updated */ public function updateAction($id) { $user = UserModel::getUserById($id); if ($user) { $user['purviews'] = $user['purviews'] ? json_decode($user['purviews'], true) : array(); $user['purviews'] = is_array($user['purviews']) ? array($user['purviews']) : array(); } if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['Admin'])) { $administrator = $user['user_name']; $_POST['Admin']['purviews'] = isset($_POST['Admin']['purviews']) ? json_encode($_POST['Admin']['purviews']) : json_encode(array()); $password = empty($_POST['Admin']['password']) ? $user['password'] : md5(md5($_POST['Admin']['password']) . $user['salt']); $allow_groups = GroupModel::getGroupsByOwner($this->user->group_id); if ($user['user_id'] == $this->user->id) { $update_data = array('user_name' => $_POST['Admin']['user_name'], 'realname' => $_POST['Admin']['realname'], 'email' => $_POST['Admin']['email'], 'password' => $password, 'lasttime' => $_SERVER['REQUEST_TIME']); } else { $allow_groups = GroupModel::getGroupsByOwner($this->user->group_id); if ($allow_groups[$this->user->group_id]['purviews'] != 'all' && (!isset($allow_groups[$_POST['Admin']['group_id']]) || $_POST['Admin']['group_id'] == $this->user->group_id)) { $this->redirect[] = array('text' => '', 'href' => $this->forward); $this->message('您无权限在该角色组下添加新用户', self::MSG_ERROR, true); } $update_data = array('user_name' => $_POST['Admin']['user_name'], 'realname' => $_POST['Admin']['realname'], 'email' => $_POST['Admin']['email'], 'password' => $password, 'group_id' => isset($_POST['Admin']['group_id']) ? $_POST['Admin']['group_id'] : $user['group_id'], 'purviews' => isset($_POST['Admin']['purviews']) ? $_POST['Admin']['purviews'] : $user['purviews'], 'user_rank' => isset($_POST['Admin']['user_rank']) ? $_POST['Admin']['user_rank'] : $user['user_rank'], 'status' => isset($_POST['Admin']['status']) ? $_POST['Admin']['status'] : $user['status'], 'lasttime' => $_SERVER['REQUEST_TIME']); } $flag = $this->db->update('{{admin}}', $update_data, 'user_id=:user_id', array(':user_id' => $id)); if ($flag) { //记录操作日志 $message = '{user_name}修改了管理员{administrator}信息'; if ($administrator != $_POST['Admin']['user_name']) { $message .= ',改名为:{new_administrator}'; } $data = array('administrator' => $administrator, 'new_administrator' => $_POST['Admin']['user_name'], 'data' => $_POST['Admin']); UserLogsModel::inst()->add('Admin/Admin', $id, 'Insert', 'success', $message, $data); $this->redirect[] = array('text' => '', 'href' => $this->forward); $this->message('修改管理员资料完成', self::MSG_SUCCESS, true); } } $groups = Group::getGroupsByOwner($this->user->group_id); $purviews = PurviewModel::getPurviewsByOwner($this->user->group_id, $this->user->id); $this->render('update', array('user' => $user, 'groups' => $groups, 'purviews' => $purviews)); }
private function getAllGroups($offset, $limit) { $this->data = GroupModel::getAll($offset, $limit); return $this->send(200); }
/** * @param integer pagesize * @param integer CID * @param integer CState * @param integer GState * * @param string order * * @return array $rows */ public function Pages($params = array()) { //设置默认参数 $_defaults_params = array('allow_cache' => false, 'page' => isset($_GET['page']) ? intval($_GET['page']) : 1, 'pagesize' => 15); $params = array_merge($_defaults_params, $params); //有开启缓存功能,则从缓存中取数据, 如果有数据,则直接返回结果 if ($params['allow_cache'] && isset($this->cache)) { $cache_key = 'user.pages.' . serialize($params); $ret = $this->cache->get($_cache_key); if ($ret && is_array($ret)) { return $ret; } } //添加条件 $builds = array('select' => 'COUNT(u.user_id) AS COUNT', 'from' => array('{{user}}', 'u'), 'leftJoin' => array('{{group}}', 'g', '`g`.`group_id`=`u`.`group_id`')); if (isset($params['status']) && !empty($params['status'])) { $builds['where'][] = array('AND', 'u.status=:status'); $sql_params = array(':status' => $params['status']); } else { $builds['where'][] = array('AND', 'u.status>:status'); $sql_params = array(':status' => self::STAT_STATUS_DELETED); } if (isset($params['group_id']) && !empty($params['group_id'])) { $groups = GroupModel::inst()->getGroupsByOwner($params['group_id']); $group_ids = array(); $_addons_groups = array(); foreach ($groups as $_k => $_v) { $_addons_groups[] = array("OR", "`u`.`group_id`=:group_id_{$_k}"); $sql_params[":group_id_{$_k}"] = $_v['group_id']; } $builds['where'][] = array('AND', $_addons_groups); } if (isset($params['search_key']) && $params['search_key']) { $builds['where'][] = array('AND', array('OR LIKE', 'u.user_name', ':search_key_1'), array('OR LIKE', 'u.realname', ':search_key_2'), array('OR LIKE', 'u.email', ':search_key_3')); $sql_params[':search_key_1'] = "%{$params['search_key']}%"; $sql_params[':search_key_2'] = "%{$params['search_key']}%"; $sql_params[':search_key_3'] = "%{$params['search_key']}%"; } $sql = $this->buildQuery($builds); //统计数量 $count = $this->db->queryScalar($sql, $sql_params); //分页处理 $pages = new CPagination($count); //设置分页大小 $pages->pageSize = $params['pagesize']; //清空前面执行过的SQL if (isset($params['orderby']) && $params['orderby']) { $builds['order'] = $params['orderby']; } else { $builds['order'] = array('`r`.`role_rank` ASC', '`u`.`user_rank` ASC', '`u`.`user_id` ASC'); } $builds['select'] = 'u.user_id, u.user_name, u.realname, u.email, u.user_id, u.group_id, g.group_name, u.logintimes, u.lastvisit, u.lastip, u.user_rank, u.lasttime, u.dateline, u.is_system, u.status'; $pages->applyLimit($builds); $sql = $this->buildQuery($builds); $result['pages'] = $pages; $result['rows'] = $this->db->queryAll($sql, $sql_params); //有开启缓存,则把结果添加到缓存中 if ($params['allow_cache'] && isset($this->cache)) { $cache_time_out = SettingModel::inst()->getSettingCache('ADMIN_LOGS_TIME_OUT'); $this->cache->add($cache_key, $result, $cache_time_out); unset($cache_time_out, $cache_key); } return $result; }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer the ID of the model to be loaded */ public function loadModel($id) { $model = GroupModel::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
/** * url GET /v2/groups * @api * @return string * @throws ApiException */ public function groupsAction() { $allowFilters = ['offset' => true, 'limit' => true, 'showAll' => true, 'showProperties' => true, 'simpleResult' => true]; $allowSearch = ['query' => true]; $params = $this->_fc->getParams(); $filter = $this->_fc->getFilter(); $search = $this->_fc->getSearch(); // check filters Utilities::checkFilters($filter, $allowFilters); Utilities::checkFilters($search, $allowSearch); if (isset($params[0])) { if ($search == null) { $this->data = GroupModel::getByNameOrId($params[0]); } } else { if ($search == null) { $showProperties = null; $hideProperties = null; $hidePropertyNames = false; if (isset($filter["showAll"])) { $offset = null; $limit = null; //$showProperties = ['group_full_name'=>true]; $showProperties = is_array($filter["showProperties"]) ? $filter["showProperties"] : []; $hidePropertyNames = isset($filter["simpleResult"]) ? $filter["simpleResult"] : false; } else { $offset = isset($filter['offset']) ? abs(intval($filter['offset'])) : 0; $limit = isset($filter['limit']) ? abs(intval($filter['limit'])) : 100; if ($limit < 1) { $limit = 1; } if ($limit > 100) { $limit = 100; } } $data = GroupModel::getAll($offset, $limit, $showProperties, $hideProperties, $hidePropertyNames); $this->data = $data['data']; $this->meta = $data['meta']; } else { $search['query'] = str_replace('%', '', $search['query']); $search['query'] = urldecode($search['query']); $this->data = GroupModel::searchByName($search['query']); } } return $this->send(200); }
/** * Reads the Help articles from default db and returns the array of pages. */ function getWikiHelpPages() { $help_pages = array(); require_once BASE_DIR . "/models/datasources/sqlite3_manager.php"; $default_dbm = new Sqlite3Manager(); $default_dbm->connect("", "", "", BASE_DIR . "/data/default.db"); if (!$default_dbm) { return false; } $group_model = new GroupModel(DB_NAME, true); $group_model->db = $default_dbm; $page_list = $group_model->getPageList(HELP_GROUP_ID, "en-US", '', 0, 200); foreach ($page_list[1] as $page) { if (isset($page['TITLE'])) { $page_info = $group_model->getPageInfoByName(HELP_GROUP_ID, $page['TITLE'], "en-US", "api"); $page_content = str_replace("&", "&", $page_info['PAGE']); $page_content = html_entity_decode($page_content, ENT_QUOTES, "UTF-8"); $help_pages[$page['TITLE']] = $page_content; } } return $help_pages; }
public function actionUserUpdate($id) { $model = UserModel::model()->findByPk($id); $group = GroupModel::model()->findall(); foreach ($group as $v) { $groupList[$v->group_id] = $v->name; } if (isset($_POST['UserModel'])) { $model->attributes = $_POST['UserModel']; $model->scenario = 'update'; if ($model->validate()) { if ($_POST['UserModel']['newPswd']) { $model->pswd = md5($_POST['UserModel']['newPswd']); } $model->save(); $this->redirect(array('group/user')); } } $this->render('userUpdate', array('model' => $model, 'group' => $groupList)); }
/** * Updates a particular model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id the ID of the model to be updated */ public function actionUpdate($id) { $model = $this->loadModel($id); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['CldModel'])) { $model->attributes = $_POST['CldModel']; if ($model->save()) { $this->redirect(array('view', 'id' => $model->id)); } } $tmpArr = GroupModel::model()->findAll(); $smsGroup = array(); foreach ($tmpArr as $smsG) { $smsGroup[$smsG->id] = $smsG->name; } $this->render('update', array('model' => $model, 'smsGroup' => $smsGroup, 'group_id' => $model->group_id)); }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model = new PhoneModel(); $message = ""; $errorList = array(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['source_name'], $_POST['group_id'])) { $fileName = _APP_PATH_ . DS . "data" . DS . "tmp" . DS . $_POST['source_name']; $group_id = $_POST['group_id']; //$fileName = "D:\\chacha_cloud\\src\\trunk\chacha\data\\tmp\\20120713170547_phone_list.xls"; try { require_once 'excel_reader2.php'; $data = new Spreadsheet_Excel_Reader($fileName, true, "UTF-8"); // khoi tao doi tuong doc file excel $rowsnum = $data->rowcount($sheet_index = 0); // lay so hang cua sheet $colsnum = $data->colcount($sheet_index = 0); // lay so cot cua sheet for ($i = 2; $i <= $rowsnum; $i++) { // doc tu hang so 2 vi hang 1 la tieu de roi! $phoneNum = $data->val($i, 1); // xuat cot so 1 va cot so 2 tren cung 1 hang // check so dien thoai xem co dung cua Vinaphone ko try { $phoneNum = Formatter::formatPhone($phoneNum); if (Formatter::isVinaphoneNumber($phoneNum)) { $model->phone = "{$phoneNum}"; $model->group_id = $group_id; $model->status = 0; $model->created_time = date("Y-m-d H:i:s"); var_dump($model->phone); try { if ($model->save()) { $message = yii::t('SpamModule', 'Upload thành công'); } else { print_r($model->getErrors()); exit; } } catch (Exception $exc) { echo $exc->getTrace(); } } else { //echo so dien thoai ko dung $errorList[] = $phoneNum; } } catch (Exception $exc) { echo $exc->getMessage(); } } } catch (Exception $exc) { echo $exc->getMessage(); } } $uploadModel = new XUploadForm(); $tmpArr = GroupModel::model()->findAll(); $smsGroup = array(); foreach ($tmpArr as $smsG) { $smsGroup[$smsG->id] = $smsG->name; } $this->render('create', array('model' => $model, 'uploadModel' => $uploadModel, 'message' => $message, 'smsGroup' => $smsGroup, 'errorList' => $errorList)); }
/** * @param string|int $teacher_name * @param string $cond * @return array * @throws ApiException */ public static function getAllByTeacherNameOrTeacherId($teacher_name, $cond = "") { $result = array(); //hide some properties $hideFilter = array('group_id' => true); Registry::set('LessonModelHideFilter', $hideFilter); $teacher_name = urldecode(trim($teacher_name)); /** @var PDO $db */ $db = Registry::get('db'); $teacher_id = $db->query("\r\n SELECT teacher_id FROM " . TeacherModel::TABLE . "\r\n WHERE (teacher_name = " . $db->quote($teacher_name) . " OR teacher_id = " . $db->quote($teacher_name) . ")\r\n ")->fetchColumn(); $count = 0; if ($teacher_id) { $count = $db->query("\r\n SELECT COUNT(*) FROM " . LessonModel::TABLE . " AS t1\r\n JOIN " . TeacherModel::RELATION_TABLE . " as t2 USING(" . LessonModel::PRIMARY_KEY . ")\r\n WHERE t2." . TeacherModel::PRIMARY_KEY . " = '" . abs(intval($teacher_id)) . "' {$cond}\r\n ")->fetchColumn(); } if ($count > 0) { $query = $db->query("\r\n SELECT *\r\n FROM " . LessonModel::TABLE . " AS t1\r\n JOIN " . TeacherModel::RELATION_TABLE . " as t2 USING(" . LessonModel::PRIMARY_KEY . ")\r\n WHERE t2." . TeacherModel::PRIMARY_KEY . " = '" . abs(intval($teacher_id)) . "' {$cond}\r\n GROUP BY t1.day_number,t1.lesson_number,t1.lesson_week\r\n ORDER BY t1.lesson_week,t1.day_number,t1.lesson_number ASC\r\n "); while ($data = $query->fetch(PDO::FETCH_ASSOC)) { $lessonModel = new LessonModel(); $lessonModel->unpack($data); //$lessonModel->teachers = TeacherModel::getAllByLessonId($lessonModel->lesson_id); //load rooms $lessonModel->rooms = RoomModel::getAllByLessonId($lessonModel->lesson_id); //load groups $q = $db->query("\r\n SELECT t1.* FROM " . GroupModel::TABLE . " as t1\r\n JOIN " . LessonModel::TABLE . " as t2 USING(" . GroupModel::PRIMARY_KEY . ")\r\n WHERE t2.day_number = '" . $lessonModel->day_number . "'\r\n AND t2.lesson_number = '" . $lessonModel->lesson_number . "'\r\n AND t2.teacher_name = " . $db->quote($lessonModel->teacher_name) . "\r\n AND t2.lesson_week = '" . $lessonModel->lesson_week . "'\r\n "); $groupsRes = array(); while ($groupsData = $q->fetch(PDO::FETCH_ASSOC)) { $group = new GroupModel(); $group->unpack($groupsData); $groupsRes[] = $group->toArray(); } $m = $lessonModel->toArray(); $m["groups"] = $groupsRes; $result[] = $m; } } else { throw new ApiException("Lessons not found"); } return $result; }
public function NewgroupAction() { $newgroup = Request::post('group'); if (mb_strlen($newgroup) < 5) { Site::Message('Название группы не может быть менее 5-и символов'); $this->GroupAction(); } elseif (GroupModel::isExists($newgroup, 'name')) { $group = GroupModel::GetObj()->where('name = ?', [0 => $newgroup]); $group->qty++; $group->save(); $this->company->group_id = $group->id; $this->company->save(); $this->RegionAction(); } else { $group = new GroupModel(); $group->name = $newgroup; $group->qty = '1'; $group->save(); $group = GroupModel::GetObj()->where('name = ?', [0 => $newgroup]); $this->company->group_id = $group->id; $this->company->save(); $this->RegionAction(); } }
public function setGroup(GroupModel $group) { $this->group_id = $group->getId(); }
public function indexAction() { $this->getView()->assign(array('groups' => GroupModel::inst()->getGroupsByOwner($this->user->group_id))); }
/** * @param string $query * @return array * @throws ApiException */ public static function searchByQuery($query) { $result = array(); /** @var PDO $db */ $db = Registry::get('db'); $query = $db->query($query); while ($data = $query->fetch(PDO::FETCH_ASSOC)) { $groupModel = new GroupModel(); $groupModel->unpack($data); $result[] = $groupModel->toArray(); } if (!count($result)) { throw new ApiException("Groups not found"); } return $result; }
</tr> <tr> <td> <fieldset> <input id="quicksearch" type="text" style="display:none;margin:4px 0" name="search" value="" id="id_search" placeholder="Tìm nhóm Spam" autofocus /> </fieldset> </td> </tr> </table> <br> <div id="group" style="display:none;height: 200px; overflow-y: scroll; width: 100%; padding-top: 10px; border-top: 2px solid rgb(51, 51, 51);"> <?php $cri = new CDbCriteria(); $cri->condition = " id != {$group_id}"; $group = GroupModel::model()->findAll($cri); foreach ($group as $gr) { echo "<div class='igroup'><input type='checkbox' name='group_list[]' value={$gr->id} ><span>" . $gr->name . "</span></div>"; } ?> </div> <br> <table style="float:left;width:100%;"> <tr> <td style="vertical-align: middle;" ><b><?php echo CHtml::label(Yii::t('admin', 'Thời gian'), ""); ?> </b></td> <td style="vertical-align: middle;"> <div class="row created_time" style="position: relative;float:left">
/** * @desc 编辑赛事结果 */ public function actionResultManage() { $masterId = CommonFunction::getUserId(); $leagueModel = new LeagueModel(); //判断用户是否有管理联赛的权限 $res = $leagueModel->allowEditLeague($masterId); $leagueId = $res[0]->objectId; $teamModel = new TeamModel(); $tournamentModel = new TournamentModel(); $playScoreModel = new PlayerScoreModel(); $groupModel = new GroupModel(); $leagueTeams = $teamModel->findRowsByRelation("teams", "League", $leagueId); //先找到联赛中的组 $groupRows = $groupModel->findByLeagueId($leagueId); //var_dump($gruopRows);exit; $groupTeams = array(); $groupTeamsArr = array(); if (!empty($groupRows)) { foreach ($groupRows as $group) { $groupId = $group->objectId; $groupRelTeams = $teamModel->findRowsByRelation("teams", "Group", $groupId); foreach ($groupRelTeams as $team) { $team->groupName = $group->name; $team->groupObjectId = $group->objectId; foreach ($leagueTeams as $lTeam) { if ($lTeam->objectId == $team->objectId) { $lTeam->selected = 1; } } } $groupTeamsArr = $groupRelTeams; array_push($groupTeams, $groupTeamsArr); } } //var_dump($groupTeams);exit; $games = array(); $games = $tournamentModel->findByLeague($leagueId); $leagueGamesData = $playScoreModel->findByLeague($leagueId); //var_dump($leagueGamesData);exit; foreach ($games as $k => $game) { if (isset($game->start_time->iso)) { $fromStartTime = time() - strtotime($game->start_time->iso); // echo $fromStartTime.'||'.$game->start_time->iso.'||'.date ( "Y-m-d H:i:s" ).'||'.strtotime($game->start_time->iso).'<br/>'; if ($fromStartTime > 7200 && (!isset($game->isVerify) || !$game->isVerify)) { $game->allowResultEdit = true; } else { $game->allowResultEdit = false; } //比赛开始后2小时,认为比赛结束 if ($fromStartTime < 7200) { //echo (time() - strtotime($game->start_time->iso)).'<br/>'.$game->start_time->iso; unset($games[$k]); } else { foreach ($leagueGamesData as $k => $gameData) { if (isset($gameData->competition->objectId) && isset($game->objectId) && isset($gameData->team->objectId) && isset($game->home_court->objectId) && $gameData->competition->objectId == $game->objectId && $gameData->team->objectId == $game->home_court->objectId) { //这场比赛的主队球员进球情况 $game->home_court->playerscore[] = array('player' => empty($gameData->player->nickname) ? '匿名' : $gameData->player->nickname, 'score' => $gameData->goals); } elseif (isset($gameData->competition->objectId) && isset($game->objectId) && isset($gameData->team->objectId) && isset($game->opponent->objectId) && $gameData->competition->objectId == $game->objectId && $gameData->team->objectId == $game->opponent->objectId) { //这场比赛的客队球员进球情况 $game->opponent->playerscore[] = array('player' => empty($gameData->player->nickname) ? '匿名' : $gameData->player->nickname, 'score' => $gameData->goals); } } } } else { unset($games[$k]); } } $this->render('resultManage', array('leagueTeams' => $leagueTeams, 'groupTeams' => $groupTeams, 'games' => $games)); }