| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220 |
- <?php
- /*
- * FecShop file.
- *
- * @link http://www.fecshop.com/
- * @copyright Copyright (c) 2016 FecShop Software LLC
- * @license http://www.fecshop.com/license/
- */
- namespace fecshop\services\admin;
- //use fecshop\models\mysqldb\cms\StaticBlock;
- use Yii;
- use fecshop\services\Service;
- /**
- * @author Terry Zhao <2358269014@qq.com>
- * @since 1.0
- */
- class RoleUrlKey extends Service
- {
- public $numPerPage = 20;
- protected $_modelName = '\fecshop\models\mysqldb\admin\RoleUrlKey';
- protected $_model;
- /**
- * language attribute.
- */
- protected $_lang_attr = [
- ];
- public function init()
- {
- parent::init();
- list($this->_modelName, $this->_model) = Yii::mapGet($this->_modelName);
- }
- public function getPrimaryKey()
- {
- return 'id';
- }
- public function getByPrimaryKey($primaryKey)
- {
- if ($primaryKey) {
- $one = $this->_model->findOne($primaryKey);
- foreach ($this->_lang_attr as $attrName) {
- if (isset($one[$attrName])) {
- $one[$attrName] = unserialize($one[$attrName]);
- }
- }
- return $one;
- } else {
- return new $this->_modelName();
- }
- }
- /*
- * example filter:
- * [
- * 'numPerPage' => 20,
- * 'pageNum' => 1,
- * 'orderBy' => ['_id' => SORT_DESC, 'sku' => SORT_ASC ],
- 'where' => [
- ['>','price',1],
- ['<=','price',10]
- * ['sku' => 'uk10001'],
- * ],
- * 'asArray' => true,
- * ]
- */
- public function coll($filter = '')
- {
- $query = $this->_model->find();
- $query = Yii::$service->helper->ar->getCollByFilter($query, $filter);
- $coll = $query->all();
- if (!empty($coll)) {
- foreach ($coll as $k => $one) {
- foreach ($this->_lang_attr as $attr) {
- $one[$attr] = $one[$attr] ? unserialize($one[$attr]) : '';
- }
- $coll[$k] = $one;
- }
- }
- //var_dump($one);
- return [
- 'coll' => $coll,
- 'count'=> $query->limit(null)->offset(null)->count(),
- ];
- }
- /**
- * @param $one|array
- * save $data to cms model,then,add url rewrite info to system service urlrewrite.
- */
- public function save($one)
- {
- $currentDateTime = \fec\helpers\CDate::getCurrentDateTime();
- $primaryVal = isset($one[$this->getPrimaryKey()]) ? $one[$this->getPrimaryKey()] : '';
- if (!($this->validateUrlKeyRoleId($one))) {
- Yii::$service->helper->errors->add('The url key && role id exists, you must define a unique url key && role id');
- return;
- }
- if ($primaryVal) {
- $model = $this->_model->findOne($primaryVal);
- if (!$model) {
- Yii::$service->helper->errors->add('Role Url Key {primaryKey} is not exist', ['primaryKey' => $this->getPrimaryKey()]);
- return;
- }
- } else {
- $model = new $this->_modelName();
- $model->created_at = time();
- }
- $model->updated_at = time();
- foreach ($this->_lang_attr as $attrName) {
- if (is_array($one[$attrName]) && !empty($one[$attrName])) {
- $one[$attrName] = serialize($one[$attrName]);
- }
- }
- $primaryKey = $this->getPrimaryKey();
- $model = Yii::$service->helper->ar->save($model, $one);
- $primaryVal = $model[$primaryKey];
- return true;
- }
- /**
- * @param int $roleId
- * @param array $url_key_ids
- * 先删除该role_id 对应的所有的数据,然后将这些数据依次插入到表中
- */
- public function repeatSaveRoleUrlKey($roleId, $url_key_ids){
- if ($roleId && is_array($url_key_ids) && !empty($url_key_ids)) {
- $this->_model->deleteAll([
- 'role_id' => $roleId
- ]);
- foreach ($url_key_ids as $url_key_id) {
- $model = new $this->_modelName();
- $model->created_at = time();
- $model->updated_at = time();
- $model->url_key_id = $url_key_id;
- $model->role_id = $roleId;
- $model->save();
- }
- return true;
- }
- return false;
- }
- protected function validateUrlKeyRoleId($one)
- {
- $url_key_id = $one['url_key_id'];
- $role_id = $one['role_id'];
- $id = $this->getPrimaryKey();
- $primaryVal = isset($one[$id]) ? $one[$id] : '';
- $where = [
- 'url_key_id' => $url_key_id,
- 'role_id' => $role_id,
- ];
- $query = $this->_model->find()->asArray();
- $query->where($where);
- if ($primaryVal) {
- $query->andWhere(['<>', $id, $primaryVal]);
- }
- $one = $query->one();
- if (!empty($one)) {
- return false;
- }
- return true;
- }
- /**
- * @param $url_key_id int
- * @return bool
- * 按照$url_key_id为条件进行删除,一般是url_key进行删除操作的时候,删除这里的数据
- */
- public function removeByUrlKeyId($url_key_id){
- $this->_model->deleteAll(['url_key_id' => $url_key_id]);
- return true;
- }
- /**
- * @param $url_key_id int
- * @return bool
- * 按照$role_id为条件进行删除,一般是role进行删除操作的时候,删除这里的数据
- */
- public function removeByRoleId($role_id){
- $this->_model->deleteAll(['role_id' => $role_id]);
- return true;
- }
- public function remove($ids)
- {
- if (!$ids) {
- Yii::$service->helper->errors->add('remove id is empty');
- return false;
- }
- if (is_array($ids) && !empty($ids)) {
- foreach ($ids as $id) {
- $model = $this->_model->findOne($id);
- $model->delete();
- }
- } else {
- $id = $ids;
- $model = $this->_model->findOne($id);
- $model->delete();
- }
- return true;
- }
- }
|