基于PHP Laravel的开源OA/协同办公平台，包含销售管理、日程安排，进销存、数据分析，强大的自定义能力

<?php namespace Gdoo\Model; use XMLReader; use DB; use Request; use Validator; use URL; use View; use Auth; use App\Support\AES; use App\Support\Hook; use App\Support\License; use Gdoo\Model\Models\Bill; use Gdoo\Model\Models\Model; use Gdoo\Model\Models\Field; use Gdoo\Model\Models\Permission; use Gdoo\Model\Models\Template; use Gdoo\Model\Models\Step; use Gdoo\Model\Models\StepLog; use Gdoo\Index\Models\Attachment; use Gdoo\Index\Models\Access; use Gdoo\Index\Services\AttachmentService; use Gdoo\User\Models\User; use Gdoo\User\Models\UserAsset; use Gdoo\Model\Models\Run; use Gdoo\Model\Models\RunStep; use Gdoo\Model\Models\RunLog; use Gdoo\Model\Services\FieldService; use Gdoo\Model\Services\ModuleService; use Gdoo\Index\Services\NotificationService; use Gdoo\Model\Services\StepService; use Gdoo\User\Services\UserAssetService; use Gdoo\User\Services\UserService; use Illuminate\Support\Arr; class Form { /** * 关联字段处理 */ public static function fieldRelated($table, &$field, &$join, &$select, &$links) { if ($field['data_type']) { $data_type = $field['data_type']; $data_field = $field['data_field']; $data_link = $field['data_link']; $_table = $data_link.'_'.$data_type; if ($field['type']) { $join[$_table] = [$data_type.' as '.$_table, $_table.'.id', '=', $table.'.'.$data_link, $table, 1]; } $links[$data_link][$data_link] = 'id'; if ($field['field'] == $data_link) { $column = $field['field'].'_'.$data_field; } else { $column = $field['field']; } $field_count = mb_substr_count($data_field, ':'); if ($field_count > 0) { $var1 = explode(':', $data_field); list($_v1, $_v2) = explode('.', $var1[0]); list($_t1, $_t2) = explode('.', $var1[1]); if ($field['type']) { $_table = $data_link.'_'.$_t1; } else { $_table = $field['field'].'_'.$_t1; } $join[$_table] = [$_t1.' as '.$_table, $_table.'.id', '=', $data_link.'_'.$data_type.'.'.$_v2, $data_link.'_'.$data_type, 1]; $index = $_table.'.'.$_t2; if ($field['field'] == $data_link) { $column = $field['field'].'_'.$_v1; // 这里本地字段和右表字段一样时，直接取右表名称 $links[$data_link][$column] = $_v1; } else { // $_v2 右表关联字段，$_t2 右表映射字段 if ($field['type']) { $links[$data_link][$column] = $_v2; // 右表 id_name $links[$data_link][$column.'_'.$_t2] = $_v2.'_'.$_t2; $field['dest_column'] = $column.'_'.$_t2; $column = $column.'_'.$_t2; } else { $links[$data_link][$column] = $_v2.'_'.$_t2; } } } else { if ($field['type']) { if ($field['field'] == $data_link) { $index = $data_link.'_'.$data_type.'.'.$data_field; } else { $index = $table.'.'.$field['field']; } } else { $index = $data_link.'_'.$data_type.'.'.$data_field; } $links[$data_link][$column] = $data_field; } $field['_column'] = $column; $select[] = $index. ' as '.$column; } } public static function make($options) { $assets = UserAssetService::getNowRoleAssets(); // 权限查询类型 $code = $options['code']; $bill = Bill::where('code', $code)->first(); // 表数据 $flow = DB::table('model') ->where('id', $bill['model_id']) ->first(); // 主表字段 $fields = DB::table('model_field') ->where('model_id', $bill['model_id']) ->orderBy('sort', 'asc') ->get()->keyBy('field'); $table = $flow['table']; // 查询主表数据 $join = $select = $links = []; $select[] = $table.'.*'; foreach($fields as $field) { static::fieldRelated($table, $field, $join, $select, $links); } $join = Grid::sortJoin($join); $q = DB::table($table) ->where($table.'.id', (int)$options['id']); foreach($join as $j) { $q->leftJoin($j[0], $j[1], $j[2], $j[3]); } $row = $q->select($select)->first(); $auth = auth()->user(); $action = $options['action']; if ($action == 'show') { $tpl = 'show'; $type_sql = '(' . join(' or ', [db_instr('type', $tpl)]) . ')'; } else { $tpl = $row['id'] > 0 ? 'edit' : 'create'; $type_sql = '(' . join(' or ', [db_instr('type', $tpl)]) . ')'; } if ($action == 'print') { $type_sql = '(' . join(' or ', [db_instr('type', 'print')]) . ')'; } $key = AES::encrypt($bill['id'].'.'.(int)$row['id'], config('app.key')); $run_id = 0; $step_id = 0; $run_log_id = 0; $run_step_id = 0; $recall_log_id = 0; $recall_btn = $audit_btn = $abort_btn = $read_btn = false; if ($bill['audit_type'] == 1) { $run = DB::table('model_run') ->where('bill_id', $bill['id']) ->where('data_id', $row['id']) ->first(); // 流程是新建的 if (empty($run)) { $step = DB::table('model_step') ->where('bill_id', $bill['id']) ->where('type', 'start') ->first(); $step_id = $step['id']; } else { $step = DB::table('model_run_log') ->leftJoin('model_run_step', 'model_run_step.id', '=', 'model_run_log.run_step_id') ->where('model_run_log.run_id', $run['id']) ->where('model_run_log.user_id', $auth['id']) ->where('model_run_log.status', 0) ->orderBy('model_run_log.id', 'asc') ->first([ 'model_run_log.*', 'model_run_step.type as step_type', 'model_run_step.step_id', 'model_run_step.permission_id' ]); $run_id = $run['id']; $step_id = $step['step_id']; $run_step_id = $step['run_step_id']; $run_log_id = $step['id']; $option = $step['option']; // 判断是有审核权限 $audit_status = $step['user_id'] == auth()->id(); if ($option == 1) { $audit_btn = $audit_status; } else { $read_btn = $audit_status; } } if ($row['status'] == '0') { $audit_btn = 1; } if ($row['status'] == '1') { $abort_btn = 1; } // 获取表单操作权限 $_permission = DB::table('model_permission') ->permission('receive_id') ->where('id', $step['permission_id']) ->first(); // 获取最后已转交节点 $passed = DB::table('model_run_log') ->where('run_id', $run['id']) ->where('user_id', $auth['id']) ->where('status', '>', 0) ->orderBy('id', 'desc') ->first(); if ($passed) { $recall_log_id = $passed['id']; $nodes = DB::table('model_run_log