123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151 |
- <?php
- namespace app\common\model;
- use think\facade\Db;
- class Appadv extends BaseModel
- {
-
- public function getAppadvpositionList($condition = array(), $pagesize = '', $orderby = 'ap_id desc') {
- if ($pagesize) {
- $result = Db::name('appadvposition')->where($condition)->order($orderby)->paginate(['list_rows'=>$pagesize,'query' => request()->param()],false);
- $this->page_info = $result;
- return $result->items();
- } else {
- return Db::name('appadvposition')->where($condition)->order($orderby)->select()->toArray();
- }
- }
-
- public function getAppadvList($condition = array(), $pagesize = '', $limit = 0, $orderby = 'adv_sort asc') {
- if ($pagesize) {
- $result = Db::name('appadv')->where($condition)->order($orderby)->paginate(['list_rows'=>$pagesize,'query' => request()->param()],false);
- $this->page_info = $result;
- return $result->items();
- } else {
- return Db::name('appadv')->where($condition)->order($orderby)->select()->toArray();
- }
- }
-
- public function addAppadvposition($data) {
- return Db::name('appadvposition')->insertGetId($data);
- }
-
- public function addAppadv($data) {
- $result = Db::name('appadv')->insertGetId($data);
- $apId = (int) $data['ap_id'];
- dkcache("appadv/{$apId}");
- return $result;
- }
-
- public function editAppadvposition($ap_id,$data) {
- dkcache("appadv/{$ap_id}");
- return Db::name('appadvposition')->where('ap_id', $ap_id)->update($data);
- }
-
-
- public function getOneAppadvposition($condition = array()) {
- return Db::name('appadvposition')->where($condition)->find();
- }
-
- public function delAppadvposition($ap_id) {
- $apId = (int) $ap_id;
- dkcache("appadv/{$apId}");
- return Db::name('appadvposition')->where('ap_id', $apId)->delete();
- }
-
- public function getOneAppadv($condition = array()) {
- return Db::name('appadv')->where($condition)->find();
- }
-
- public function editAppadv($adv_id,$data) {
- $adv_array = Db::name('appadv')->where('adv_id', $adv_id)->find();
- if ($adv_array) {
-
- $apId = (int) $adv_array['ap_id'];
- dkcache("appadv/{$apId}");
- }
- return Db::name('appadv')->where('adv_id', $adv_id)->update($data);
- }
-
- public function delAppadv($adv_id) {
- $adv = Db::name('appadv')->where('adv_id',$adv_id)->find();
- if ($adv) {
-
- $apId = (int) $adv['ap_id'];
- dkcache("appadv/{$apId}");
- }
- @unlink(BASE_UPLOAD_PATH . DIRECTORY_SEPARATOR . ATTACH_APPADV. DIRECTORY_SEPARATOR .$adv['adv_code']);
- return Db::name('appadv')->where('adv_id',$adv_id)->delete();
- }
- }
|