orgId; if($month){ $map['month'] = $month; } $list = Db::name('user_salary') ->where($map) ->limit($start,$length) ->order('id desc') ->select(); foreach ($list as $k=>$v){ $list[$k]['name'] = Db::name('user_archives')->where('id',$v['uaid'])->value('name'); } $total = Db::name('user_salary')->where($map)->count(); $data = [ 'total' => $total, 'list' => $list?$list:[] ]; ajax_return_ok($data); } public function add(){ $data = [ 'uaid' => input('uaid/d',0), 'salary' => input('salary/f',0), 'days' => input('days/d',0), 'real_days' => input('real_days/d',0), 'month' => input('month','','trim'), 'jx_money' => input('jx_money/f',0), 'gw_money' => input('gw_money/f',0), 'jb_money' => input('jb_money/f',0), 'hb_money' => input('hb_money/f',0), 'jb_days' => input('jb_days/d',0), 'cb_money' => input('cb_money/f',0), 'caib_money' => input('caib_money/f',0), 'jj_money' => input('jj_money/f',0), 'kk_money' => input('kk_money/f',0), 'tax_money' => input('tax_money/f',0), ]; $data['org_id'] = $this->orgId; $validate = new UserSalary(); if (!$validate->check($data)) { ajax_return_error($validate->getError()); } $cqsalary = $data['salary'] * ($data['real_days']/$data['days']); $real_salary = $cqsalary + $data['jx_money'] + $data['gw_money'] + $data['jb_money'] + $data['hb_money'] + $data['cb_money'] + $data['caib_money'] + $data['jj_money'] - $data['kk_money'] - $data['tax_money']; $data['real_salary'] = round($real_salary,2); if(empty($data['id'])){ // 新增 unset($data['id']); $data['create_time'] = date('Y-m-d H:i:s'); $ret = Db::name('user_salary')->strict(false)->insert($data); }else{ // 编辑 $data['update_time'] = date('Y-m-d H:i:s'); $ret = Db::name('user_salary')->where('id',$data['id'])->strict(false)->update($data); } if($ret){ ajax_return_ok(); }else{ ajax_return_error('保存失败'); } } public function info(){ $id = input('id/d',0); $info = Db::name('user_salary')->where('id',$id)->find(); if(!$info){ ajax_return_error('数据不存在'); } ajax_return_ok($info); } public function del(){ $id = input('id/d',0); $info = Db::name('user_salary')->where('id',$id)->delete(); if(!$info){ ajax_return_error('删除失败'); } ajax_return_ok('','删除成功'); } }