public function uninstall($code) { $row = (new \yii\db\Query())->select(['id', 'shipping_name', 'print_bg'])->from(self::tableName())->where(['shipping_code' => $code])->limit(1)->one(); if (!$row) { return true; } $shipping_id = $row['id']; $shipping_name = $row['shipping_name']; //获取配送地区id $rows = (new \yii\db\Query())->select(['id'])->from(ShippingArea::tableName())->where(['shipping_id' => $shipping_id])->all(); $all = UtilD::getCol($rows); $in = UtilD::db_create_in(join(',', $all)); $conn = \Yii::$app->getDb(); $transaction = $conn->beginTransaction(); try { $sql1 = "DELETE FROM " . AreaRegion::tableName() . " WHERE shipping_area_id " . $in; $sql2 = "DELETE FROM " . ShippingArea::tableName() . " WHERE id=" . $shipping_id; $sql3 = "DELETE FROM " . Shipping::tableName() . " WHERE id=" . $shipping_id; $conn->createCommand($sql1)->execute(); $conn->createCommand($sql2)->execute(); $conn->createCommand($sql3)->execute(); $transaction->commit(); } catch (\Exception $e) { $transaction->rollBack(); return false; } //删除上传的非默认快递单 if ($row['print_bg'] != '' && !UtilD::is_print_bg_default($row['print_bg'])) { @unlink(\Yii::getAlias('@web') . DIRECTORY_SEPARATOR . $row['print_bg']); } AdminLog::admin_log(addslashes($shipping_name), 'uninstall', 'shipping'); return true; }
/** * get user row data * @return array userInfo */ private function getUserInfo() { $user_id = $this->getId(); $key = md5(self::USER_KEY . $user_id); $data = UtilD::getCache(__CLASS__, $key); if (!$data) { $data = Yii::$app->getDb()->createCommand("SELECT * FROM {{%admin}} WHERE id=" . $user_id . " AND status=" . Admin::STATUS_ACTIVE)->queryOne(); if ($data) { UtilD::setCache(__CLASS__, $key, $data); } } return $data; }
/** * 对访问的方法进行权限验证 */ protected function Permission() { $route = strtolower($this->getRouteAbsolute()); if (\Yii::$app->user->isGuest) { if (!in_array($route, \yii::$app->params['notNeedLogin'])) { //判断是否是ajax访问 if (\Yii::$app->request->getIsAjax()) { exit(UtilD::toJson(false, '未登录,无操作权限')); } else { return $this->redirect('/admin/login'); } } } }
public function actionSavePost() { $today = date('Y-m-d'); $domain = UtilD::getSiteDomain(); $sm =& new GoogleSitemap(); $smi =& new GoogleSitemapItem($domain, $today, $_POST['homepage_changefreq'], $_POST['homepage_priority']); $sm->add_item($smi); $config = ['homepage_changefreq' => $_POST['homepage_changefreq'], 'homepage_priority' => $_POST['homepage_priority'], 'category_changefreq' => $_POST['category_changefreq'], 'category_priority' => $_POST['category_priority'], 'content_changefreq' => $_POST['content_changefreq'], 'content_priority' => $_POST['content_priority']]; $status = ShopConfig::updateConfigSitemap($config, $sm, $domain, $today); if (!$status) { exit(UtilD::handleResult(false, \Yii::t('common', 'attradd_error'))); } exit(UtilD::handleResult(true, \Yii::t('common', 'attradd_succed'))); }
public function actionPost() { if (!\Yii::$app->request->getIsPost()) { throw new yii\base\InvalidCallException("无效请求"); } $model = new LoginForm(); $model->username = $_POST['username']; $model->password = $_POST['password']; $model->rememberMe = isset($_POST['rememberMe']) && $_POST['rememberMe'] == 'on' ? true : false; $model->verifyCode = $_POST['verifyCode']; if ($model->login()) { exit(UtilD::handleResult(true, '登陆成功')); } else { exit(UtilD::handleResult(false, '登陆失败,账号或密码错误')); } }
public function getShipingAreaList($shipping_id, $page = 1, $pageSize = 10) { $q = (new yii\db\Query())->select('*')->from(self::tableName()); if ($shipping_id) { $q->where(['id' => $shipping_id]); } $pages = new Pagination(['totalCount' => $q->count(), 'defaultPageSize' => $pageSize]); $result = $q->offset($pages->offset)->limit($pages->limit)->all(); $list = []; foreach ($result as $key => $row) { $sql = "SELECT r.area_name FROM " . AreaRegion::tableName() . " AS a, " . Area::tableName() . " AS r " . " WHERE a.region_area = r.area_code " . " AND a.shipping_area_id = {$shipping_id}"; $regions = UtilD::getCol(\Yii::$app->getDb()->createCommand($sql)->queryAll()); $row['shipping_area_regions'] = empty($regions) ? '<a href="' . Url::toRoute(['/shipping-area/region', 'id' => $row['shipping_area_id']]) . '" style="color:red">' . \Yii::t('shipping', 'empty_regions') . '</a>' : $regions; $list[] = $row; } return $list; }
public function actionDeleteLink() { $id = (int) \Yii::$app->request->get('id', 0); if (!$id) { exit(UtilD::handleResult(false, '非法提交')); } $model = FriendLink::find()->where('id=' . $id)->one(); if (strpos($model['link_logo'], 'http://') === false && strpos($model['link_logo'], 'https://') === false) { $img_name = basename($model['link_logo']); @unlink(\Yii::getAlias('static') . '/images/afficheimg/' . $img_name); } $model->delete(); AdminLog::admin_log('', 'remove', 'friendlink'); exit(UtilD::handleResult(true, '删除成功')); }
private function getAllArea() { $key = md5(self::CACHE_KEY . 'AllData'); $allArea = UtilD::getCache(__CLASS__, $key); if (!$allArea) { $sql = "SELECT id,area_code,area_name,depth,full_name,pid FROM " . self::tableName() . " WHERE sta=1 AND depth<=4 ORDER BY priority ASC,sort ASC,area_code ASC"; $result = \yii::$app->getDb()->createCommand($sql)->queryAll(); foreach ($result as $row) { $allArea[$row['area_code']] = $row; $fullName = explode(',', $allArea[$row['area_code']]['full_name']); if (count($fullName)) { unset($fullName[0]); $allArea[$row['area_code']]['full_name'] = implode(',', $fullName); } else { $allArea[$row['area_code']]['full_name'] = str_replace('中国', '全国', $allArea[$row['area_code']]['full_name']); } } UtilD::setCache(__CLASS__, $key, $allArea); } return $allArea; }
public function actionPost() { $allow_file_types = ['jpg', 'jpeg', 'png', 'gif', 'bmp', 'swf']; $values = \yii::$app->request->post('value', []); $type = \Yii::$app->request->post('type', ''); /* 保存变量值 */ $count = count($values); $arr = []; $sql = "SELECT id,value FROM " . ShopConfig::tableName(); $res = \yii::$app->db->createCommand($sql)->queryAll(); foreach ($res as $row) { $arr[$row['id']] = $row['value']; } foreach ($_POST['value'] as $key => $val) { //值更改则更新 if ($arr[$key] != $val) { $sql = "UPDATE " . ShopConfig::tableName() . " SET value='" . trim($val) . "' WHERE id=" . $key; $rs = \yii::$app->db->createCommand($sql)->execute(); } } /* 处理上传文件 */ $file_var_list = []; $sql = "SELECT * FROM " . ShopConfig::tableName() . " WHERE parent_id > 0 AND type='file'"; $res = \yii::$app->db->createCommand($sql)->queryAll(); foreach ($res as $row) { $file_var_list[$row['code']] = $row; } foreach ($_FILES as $code => $file) { /* 判断用户是否选择了文件 */ if (isset($file['error']) && $file['error'] == 0 || !isset($file['error']) && $file['tmp_name'] != 'none') { //检查上传的文件类型是否合法 if (!UtilD::check_file_type($file['tmp_name'], $file['name'], $allow_file_types)) { UtilD::toJavaScriptAlert('', 'back'); \yii::$app->end(); } else { $file_path = \yii::getAlias('@static') . DIRECTORY_SEPARATOR . $file_var_list[$code]['store_dir']; //取得文件路径 if ($code == 'shop_logo') { $ext = array_pop(explode('.', $file['name'])); $file_name = 'logo.' . $ext; } elseif ($code == 'watermark') { $ext = array_pop(explode('.', $file['name'])); $file_name = 'watermark.' . $ext; if (file_exists($file_var_list[$code]['value'])) { @unlink($file_var_list[$code]['value']); } } elseif ($code == 'wap_logo') { $ext = array_pop(explode('.', $file['name'])); $file_name = 'wap_logo.' . $ext; if (file_exists($file_var_list[$code]['value'])) { @unlink($file_var_list[$code]['value']); } } else { $file_name = $file['name']; } /* 判断是否上传成功 */ if (move_uploaded_file($file['tmp_name'], $file_path . $file_name)) { $sql = "UPDATE " . ShopConfig::tableName() . " SET value='" . $file_name . "' WHERE code='" . $code . "'"; $rs = \yii::$app->db->createCommand($sql)->execute(); } } } } /* 处理发票类型及税率 */ if (!empty($_POST['invoice_rate'])) { foreach ($_POST['invoice_rate'] as $key => $rate) { $rate = round(floatval($rate), 2); if ($rate < 0) { $rate = 0; } $_POST['invoice_rate'][$key] = $rate; } $invoice = ['type' => $_POST['invoice_type'], 'rate' => $_POST['invoice_rate']]; $sql = "UPDATE " . ShopConfig::tableName() . " SET value='" . serialize($invoice) . "' WHERE code ='invoice_type'"; \yii::$app->db->createCommand($sql)->execute(); } AdminLog::admin_log('', 'edit', 'shop_config'); /* 清除缓存 */ ShopConfig::clearCache(); if ($type == 'mail_setting') { return $this->redirect(Url::to('/config/mail-settings')); } else { return $this->redirect(\yii\helpers\Url::to('/config/listedit')); } }
public function actionEditPost() { $id = (int) \Yii::$app->request->post('id'); $item_name = Html::decode(\Yii::$app->request->post('item_name')); $item_url = Html::decode(\Yii::$app->request->post('item_url')); $item_ifshow = \Yii::$app->request->post('item_ifshow'); $item_opennew = \Yii::$app->request->post('item_opennew'); $item_type = \Yii::$app->request->post('item_type'); $item_vieworder = (int) \Yii::$app->request->post('item_vieworder', 0); $row = Nav::find()->select(['ctype', 'cid', 'is_show', 'type'])->where($id)->one(); $arr = Nav::analyse_uri($item_url); if ($arr) { if ($row['ctype'] == $arr['type'] && $row['cid'] == $arr['id']) { //如果没有修改分类 if ($item_type != 'middle') { //位置不在中部 Nav::setShowInNav($arr['type'], $arr['id'], 0); } } else { //修改了分类 if ($row['is_show'] == 1 && $row['type'] == 'middle') { Nav::setShowInNav($row['ctype'], $row['cid'], 0); //设置成不显示 } } //分类判断 if ($item_ifshow != Nav::isShowInNav($arr['type'], $arr['id']) && $item_type == 'middle') { Nav::setShowInNav($arr['type'], $arr['id'], $item_ifshow); } Nav::updateAll(['name' => $item_name, 'ctype' => $arr['type'], 'cid' => $arr['id'], 'is_show' => $item_ifshow, 'view_order' => $item_vieworder, 'open_new' => $item_opennew, 'url' => $item_url, 'type' => $item_type], 'id=:id', [':id' => $id]); } else { if ($row['ctype'] && $row['cid']) { Nav::setShowInNav($row['ctype'], $row['cid'], 0); } Nav::updateAll(['name' => $item_name, 'ctype' => '', 'cid' => '', 'is_show' => $item_ifshow, 'view_order' => $item_vieworder, 'open_new' => $item_opennew, 'url' => $item_url, 'type' => $item_type], 'id=:id', [':id' => $id]); } exit(UtilD::handleResult(true, \Yii::t('common', 'edit_ok'))); }
/** * 更新配置文件的sitemap * @param string $config */ public static function updateConfigSitemap($config, $sm, $domain, $today) { if (!static::updateAll(['value' => serialize($config)], "code='sitemap'")) { return false; } $res = Category::find()->select(['id', 'cat_name'])->orderBy('parent_id')->column(); foreach ($res as $row) { $smi =& new GoogleSitemapItem($domain . UtilD::build_uri('category', [$row['id']], $row['cat_name']), $today, $config['category_changefreq'], $config['category_priority']); $sm->add_item($smi); } $res = ArticleCat::find()->select(['id', 'cat_name'])->where(['cat_type' => 1])->column(); foreach ($res as $row) { $smi =& new GoogleSitemapItem($domain . UtilD::build_uri('article_cat', ['acid' => $row['id']], $row['cat_name']), $today, $config['category_changefreq'], $config['category_priority']); $sm->add_item($smi); } $res = Goods::find()->select(['id', 'goods_name'])->where('is_delete=0')->column(); foreach ($res as $row) { $smi =& new GoogleSitemapItem($domain . UtilD::build_uri('goods', ['gid' => $row['id']], $row['goods_name']), $today, $config['content_changefreq'], $config['content_priority']); $sm->add_item($smi); } //文章 $res = Article::find()->select(['id', 'title', 'file_url', 'open_type'])->where('is_open=1')->column(); foreach ($res as $row) { $article_url = $row['open_type'] != 1 ? UtilD::build_uri('article', ['aid' => $row['id']], $row['title']) : trim($row['file_url']); $smi =& new GoogleSitemapItem($domain . $article_url, $today, $config['content_changefreq'], $config['content_priority']); $sm->add_item($smi); } $sm_file = 'sitemaps.xml'; if ($sm->build($sm_file)) { return true; } else { } }
public function actionPrintUpload() { $allow_suffix = ['jpg', 'png', 'jpeg']; $shipping_id = \yii::$app->request->post('shipping', 0); $src = ''; if (!empty($_FILES['bg']['name'])) { if (!in_array(UtilD::getFileSuffix($_FILES['bg']['name']), $allow_suffix)) { UtilD::toJavaScriptAlert(sprintf(\yii::t('shipping', 'js_languages_upload_falid'), implode(',', $allow_suffix))); \yii::$app->end(); } $name = date('Ymd'); for ($i = 0; $i < 6; $i++) { $name .= chr(mt_rand(97, 122)); } $name .= '.' . end(explode('.', $_FILES['bg']['name'])); $target = \yii::getAlias('@webroot') . '/images/receipt/' . $name; if (move_uploaded_file($_FILES['bg']['tmp_name'], $target)) { $src = '/images/receipt/' . $name; } } if (!empty($src)) { $sql = "UPDATE " . Shipping::tableName() . " SET print_bg = '{$src}' WHERE id = {$shipping_id}"; if (\Yii::$app->getDb()->createCommand($sql)->execute()) { echo '<script language="javascript">'; echo 'parent.call_flash("bg_add", "' . \Yii::$app->request->getHostInfo() . $src . '");'; echo '</script>'; } } }
public function actionUninstall() { $code = \yii::$app->request->get('code'); if (empty($code)) { UtilD::toJavaScriptAlert(\yii::t('app', 'invalid_parameter'), 'back'); \yii::$app->end(); } $sta = Payment::uninstall($code); if ($sta) { AdminLog::admin_log($code, 'uninstall', 'payment'); } $this->redirect('/payment/list'); }