123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271 |
- <?php
- namespace addons\qingdongams\model;
- use think\Exception;
- use think\Model;
- use traits\model\SoftDelete;
- /**
- *费用表
- */
- class Consume Extends Model {
- use SoftDelete;
- // 表名,不含前缀
- const CONTRACT_TYPE = 'contract';
- const RECEIVABLES_TYPE = 'receivables';//合同
- const CUSTOMER_TYPE = 'customer';//回款
- const WORKORDER_TYPE = 'workorder';//报价单
- const EVENT_TYPE = 'event';//工单
- // 表名,不含前缀
- protected $name = 'qingdongams_consume';
- // 开启自动写入时间戳字段
- protected $autoWriteTimestamp = 'int';
- // 定义时间戳字段名
- protected $createTime = 'createtime';
- protected $updateTime = 'updatetime';
- protected $deleteTime = 'deletetime';
- // 追加属性
- protected $append = [
- 'file_text',
- 'relation_data',
- 'title_text',
- ];
- public static function getconsumetype() {
- return [
- 'jtf' => '交通费',
- 'clf' => '差旅费',
- 'call' => '电话费',
- 'jjf' => '交际费',
- 'bgkx' => '办公开销',
- 'cgf' => '采购费',
- 'ggf' => '广告宣传费',
- 'other' => '其他费用',
- ];
- }
- public static function getNumber()
- {
- return 'M' . date('ymd') . rand(100, 999);
- }
- public function getTitleTextAttr($value, $data)
- {
- $value = $value ? $value : '';
- if (isset($value) && $value) {
- return $value;
- } else {
- return '日常报销';
- }
- }
- public function getRelationDataAttr($value, $data)
- {
- if (!isset($data['relation_type'])) {
- return '';
- }
- if ($data['relation_type'] == self::WORKORDER_TYPE) {
- return Workorder::where(['id' => $data['relation_id']])->field('id,title,workorder_number')->find();
- } elseif ($data['relation_type'] == self::EVENT_TYPE) {
- return Event::where(['id' => $data['relation_id']])->field('id,title')->find();
- }
- return [];
- }
- //添加费用
- public function getCheckStatusTextAttr($value, $data)
- {
- $check_status=$data['check_status']??0;
- $a = [0 => __('待审核'), 1 => __('审核中'), 2 => __('审核通过'), 3 => __('审核未通过')];
- return $a[$check_status] ?? '';
- }
- // 图片
- public function getFileTextAttr($value, $data)
- {
- if(!isset($data['file_ids'])){
- return '';
- }
- if(is_array($value)){
- return $value;
- }
- $value = $value ? $value : $data['file_ids'];
- $files = explode(',',$value);
- $files_v = [];
- foreach ($files as $fid) {
- if($fid){
- $files_v[] = cdnurl(File::getUrl($fid), true);
- }
- }
- return $files_v;
- }
- //添加费用
- public static function createConsume($params) {
- foreach ($params as $name => $val) {
- if($params[$name] === ''){
- $params[$name]=NULL;
- }
- }
- $staff = Staff::info();
- $staff_id = $staff->id;
- if(isset($params['customer_id']) && $params['customer_id']){
- $staff_id = Customer::where(['id'=>$params['customer_id']])->value('owner_staff_id');
- }
- $params['staff_id'] = $staff_id;
- $params['check_status'] = 1;
- $flow = Flow::getsteplist(Flow::CONSUME_STATUS);
- $params['flow_id'] = $flow['flow_id'];
- $params['order_id'] = $flow['order_id'];
- $detailes = $params['detail']??[];
- unset($params['detail']);
- if ($flow['status'] == 0) {//发起人自选
- if (empty($params['flow_staff_ids'])) {
- // throw new Exception('审批人必须选择');
- }
- $params['flow_staff_ids'] = trim($params['flow_staff_ids']??'');
- } else {
- $params['flow_staff_ids'] = trim($flow['flow_staff_ids']);
- }
- $Model = new self;
- $result = $Model->allowField(true)->save($params);
- if (false === $result) {
- // 验证失败 输出错误信息
- throw new Exception($Model->getError());
- }
- $lastId= $Model->getLastInsID();
- $detail = [];
- foreach ($detailes as $v) {
- $detail[] = [
- 'customer_id' => $params['customer_id']??0,
- 'consume_id' => $lastId,
- 'consume_date' => $v['consume_date'],
- 'consume_type' => $v['consume_type'],
- 'consume_money' => $v['consume_money'],
- 'remark' => $v['remark'] ?? '',
- 'file_ids' => $v['file_ids'] ?? '',
- 'mileage' => $v['mileage'] ?? '',
- 'car_number' => $v['car_number'] ?? '',
- 'car_type' => $v['car_type'] ?? '',
- 'start_mileage' => $v['start_mileage'] ?? '',
- 'end_mileage' => $v['end_mileage'] ?? '',
- 'other_files' => $v['other_files'] ?? '',
- ];
- }
- $detailModel = new ConsumeDetail();
- $detailModel->insertAll($detail);
- $staff_id = explode(',', $params['flow_staff_ids'])[0];
- ExamineRecord::addExaminse(ExamineRecord::CONSUME_TYPE,$lastId, $staff_id);
- return true;
- }
- //编辑费用
- public static function updateConsume($params) {
- $params['check_status'] = 1;
- $flow = Flow::getsteplist(Flow::CONSUME_STATUS);
- $params['flow_id'] = $flow['flow_id'];
- $params['order_id'] = $flow['order_id'];
- if ($flow['status'] == 0) {//发起人自选
- if (empty($params['flow_staff_ids'])) {
- throw new Exception('审批人必须选择');
- }
- $params['flow_staff_ids'] = trim($params['flow_staff_ids']);
- } else {
- $params['flow_staff_ids'] = trim($flow['flow_staff_ids']);
- }
- $detailes = $params['detail']??[];
- unset($params['detail']);
- $Model = new self;
- // 调用当前模型对应的User验证器类进行数据验证
- $result = $Model->save($params,['id'=>$params['id']]);
- if (false === $result) {
- // 验证失败 输出错误信息
- throw new Exception($Model->getError());
- }
- $detail = [];
- foreach ($detailes as $v) {
- $detail[] = [
- 'customer_id' => $params['customer_id']?:0,
- 'consume_id' => $params['id'],
- 'consume_date' => $v['consume_date'],
- 'consume_type' => $v['consume_type'],
- 'consume_money' => $v['consume_money'],
- 'remark' => $v['remark'] ?? '',
- 'file_ids' => $v['file_ids'] ?? '',
- 'mileage' => $v['mileage'] ?? '',
- 'car_number' => $v['car_number'] ?? '',
- 'car_type' => $v['car_type'] ?? '',
- 'start_mileage' => $v['start_mileage'] ?? '',
- 'end_mileage' => $v['end_mileage'] ?? '',
- 'other_files' => $v['other_files'] ?? '',
- ];
- }
- $detailModel = new ConsumeDetail();
- $detailModel->where(['consume_id'=>$params['id']])->delete();
- $detailModel->insertAll($detail);
- if ($flow['status'] == 1) {//固定审批
- //发送审批通知
- Flow::sendStepRecord($flow,Flow::CONSUME_STATUS, $params['id']);
- } else {//发起人自选 依次审批
- $staff_id = explode(',', $params['flow_staff_ids'])[0];
- if ($staff_id) {
- ExamineRecord::addExaminse(ExamineRecord::CONSUME_TYPE, $params['id'], $staff_id);
- }
- }
- return true;
- }
- //计算交通费
- public static function getMileageMoney($number)
- {
- return $number * 10;
- }
- public function getCreatetimeAttr($value){
- if(empty($value)){
- return $value;
- }
- return date('Y-m-d H:i:s',$value);
- }
- public function getUpdatetimeAttr($value){
- if(empty($value)){
- return $value;
- }
- return date('Y-m-d H:i:s',$value);
- }
- //销售
- public function staff() {
- return $this->hasOne(Staff::class, 'id', 'staff_id')
- ->field('id,img,name,mobile');
- }
- //审核人
- public function followStaff() {
- return $this->hasOne(Staff::class, 'id', 'flow_staff_ids')
- ->field('id,img,name,mobile');
- }
- //客户
- public function customer() {
- return $this->hasOne(Customer::class, 'id', 'customer_id')->field('id,name');
- }
- //费用详情
- public function consumeDetail()
- {
- return $this->hasMany(ConsumeDetail::class, 'consume_id', 'id');
- }
- }
|