123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162 |
- <?php
- namespace app\common\model;
- use think\facade\Db;
- class Adv extends BaseModel {
- public $page_info;
-
- public function addAdvposition($data) {
- return Db::name('advposition')->insertGetId($data);
- }
-
- public function addAdv($data) {
- $result = Db::name('adv')->insertGetId($data);
- $apId = (int) $data['ap_id'];
- dkcache("adv/{$apId}");
- return $result;
- }
-
- public function delAdv($adv_id) {
- $adv = Db::name('adv')->where('adv_id',$adv_id)->find();
- if ($adv) {
-
- $apId = (int) $adv['ap_id'];
- dkcache("adv/{$apId}");
- }
- @unlink(BASE_UPLOAD_PATH . DIRECTORY_SEPARATOR . ATTACH_ADV. DIRECTORY_SEPARATOR .$adv['adv_code']);
- return Db::name('adv')->where('adv_id',$adv_id)->delete();
- }
-
- public function delAdvposition($ap_id) {
- $apId = (int) $ap_id;
- dkcache("adv/{$apId}");
- return Db::name('advposition')->where('ap_id', $apId)->delete();
- }
-
- public function getAdvpositionList($condition = array(), $pagesize = '', $orderby = 'ap_id desc') {
- if ($pagesize) {
- $result = Db::name('advposition')->where($condition)->order($orderby)->paginate(['list_rows'=>$pagesize,'query' => request()->param()],false);
- $this->page_info = $result;
- return $result->items();
- } else {
- return Db::name('advposition')->where($condition)->order($orderby)->select()->toArray();
- }
- }
- public function getOneAdvposition($condition = array()) {
- return Db::name('advposition')->where($condition)->find();
- }
- public function getOneAdv($condition = array()) {
- return Db::name('adv')->where($condition)->find();
- }
-
- public function getAdvList($condition = array(), $pagesize = '', $limit = 0, $orderby = 'adv_id desc') {
- if ($pagesize) {
- $result = Db::name('adv')->where($condition)->order($orderby)->paginate(['list_rows'=>$pagesize,'query' => request()->param()],false);
- $this->page_info = $result;
- return $result->items();
- } else {
- return Db::name('adv')->where($condition)->order($orderby)->select()->toArray();
- }
- }
-
- public function mbadvlist($condition,$orderby='adv_sort desc'){
- return Db::name('adv')->alias('a')->join('advposition n','a.ap_id=n.ap_id')->where($condition)->order($orderby)->select()->toArray();
- }
-
- public function editAdv($adv_id,$data) {
- $adv_array = Db::name('adv')->where('adv_id', $adv_id)->find();
- if ($adv_array) {
-
- $apId = (int) $adv_array['ap_id'];
- dkcache("adv/{$apId}");
- }
- return Db::name('adv')->where('adv_id', $adv_id)->update($data);
- }
-
- public function editAdvposition($ap_id,$data) {
- dkcache("adv/{$ap_id}");
- return Db::name('advposition')->where('ap_id', $ap_id)->update($data);
- }
- }
- ?>
|