public static function get_tasks($card_id = false, $camp_id = false)
{
$task = Task::select('tasks.*', 'cards.name as card', 'camps.name as camp');
$task->join('cards', 'cards.id', '=', 'card_id', 'left');
$task->join('camps', 'camps.id', '=', 'camp_id', 'left');
if ($card_id) {
$task->where('tasks.card_id', $card_id);
}
if ($camp_id) {
$task->where('tasks.camp_id', $camp_id);
}
return $task->get();
}
public function task($type)
{
$tasks = null;
$query = null;
$title = ['状态 ', '完成时间', 'PRI', '任务编号', '任务标题', '客户名称', 'PM', '工作流版本', '开发人员', '工作量', '测试人员', '工作量', 'EKP任务', '实际任务', '备注'];
$file_name = '任务明细' . date("Ymd", strtotime("now"));
switch ($type) {
case 'year':
$query_begin = date("Y", mktime(0, 0, 0, date("m"), 1, date("Y")));
$tasks = Task::select('status', 'actual_finish_date', 'PRI', 'task_no', 'task_title', 'customer_name', 'abu_pm', 'erp_version', 'developer', 'developer_workload', 'tester', 'tester_workload', 'ekp_task_type', 'task_type', 'comment')->where('task_no', '>', $query_begin)->get();
$file_name = '本年' . $file_name;
break;
case 'month':
$query_begin = date("Ymd", mktime(0, 0, 0, date("m") - 1, 1, date("Y")));
$query_end = date("Ymd ", mktime(0, 0, 0, date("m") + 1, 1, date("Y")));
$tasks = Task::select('status', 'actual_finish_date', 'task_no', 'task_title', 'customer_name', 'abu_pm', 'erp_version', 'developer', 'developer_workload', 'tester', 'tester_workload', 'ekp_task_type', 'task_type', 'comment')->where('task_no', '>', $query_begin)->where('task_no', '<', $query_end)->orWhere('status', '<', 3)->get();
$file_name = '本月' . $file_name;
break;
case 'week':
$query_begin = date("Ymd", strtotime("-1 week Monday"));
$query_end = date("Ymd", strtotime("+0 week Monday"));
$tasks = Task::select('status', 'actual_finish_date', 'PRI', 'task_no', 'task_title', 'customer_name', 'abu_pm', 'erp_version', 'developer', 'developer_workload', 'tester', 'tester_workload', 'ekp_task_type', 'task_type', 'comment')->where('task_no', '>', $query_begin)->where('task_no', '<', $query_end)->get();
$file_name = '本周' . $file_name;
break;
case 'yd':
$tasks = Task::select('status', 'actual_finish_date', 'PRI', 'task_no', 'task_title', 'customer_name', 'abu_pm', 'erp_version', 'developer', 'developer_workload', 'tester', 'tester_workload', 'ekp_task_type', 'task_type', 'comment')->where('abu_pm', '刘嵩')->orderBy('task_no', 'DESC')->get();
$file_name = '本周' . $file_name;
break;
}
$cellData = [];
$cellData = $tasks->toArray();
//// print_r($tasks);
foreach ($cellData as $k => $val) {
if (date("Y-m-d", strtotime($val['actual_finish_date'])) === '1970-01-01' || date("Y-m-d", strtotime($val['actual_finish_date'])) === '-0001-11-30') {
$cellData[$k]['actual_finish_date'] = "";
} else {
$cellData[$k]['actual_finish_date'] = date("Y-m-d", strtotime($val['actual_finish_date']));
}
$cellData[$k]['status'] = Config('params.task_status')[$val['status']];
$cellData[$k]['developer'] = $val['dev_name'];
$cellData[$k]['tester'] = $val['tester_name'];
unset($cellData[$k]['dev_name']);
unset($cellData[$k]['tester_name']);
}
// print_r($cellData);
// die;
// print_r($cellData);
Excel::create($file_name, function ($excel) use($cellData) {
$excel->sheet('score', function ($sheet) use($cellData) {
$sheet->rows($cellData);
});
})->export('xls');
}
public function test_page()
{
// $users = Cache::get('user',function(){
// $users = DB::table('users')->select('code', 'name','role','admin')->get();
// Cache::forever('user', $users);
// });
// $user_code = 'wank,zhuangsd';
// if(!empty($user_code))
// {
// $arr_user_code = explode(',',$user_code);
// $user_name = [];
//// var_dump($users);
// if(count($arr_user_code) > 1){
// //循环数组，输出名字
// foreach($arr_user_code as $val) {
// foreach($users as $user){
// if($user->code == $val){
// $user_name[$val] = $user->name;
// }
// }
// if(empty($user_name[$val])){
// $user_name[$val] = '未知';
// }
// }
// }
// else{
// foreach($users as $user) {
// if($user->code == $user_code) {
// $user_name[$user_code] = $user->name;
// }
// }
// if(empty($user_name[$user_code])){
// $user_name[$user_code] = '未知';
// }
// }
// var_dump(join(',',$user_name));die;
// }
// else
// {
// echo '未知code';
// }
// $cellData = [
// ['学号','姓名','成绩'],
// ['10001','AAAAA','99'],
// ['10002','BBBBB','92'],
// ['10003','CCCCC','95'],
// ['10004','DDDDD','89'],
// ['10005','EEEEE','96'],
// ];
$query = '2016';
$title = ['任务编号 ', '任务标题', '客户名称', 'PM', '工作流版本', '开发人员', '测试人员', '备注', '开发人员', '测试人员'];
// $tasks = DB::table('tasks')->select('task_no', 'task_title','customer_name','abu_pm','erp_version','developer','tester','comment')->where('task_no','like',$query.'%')->get();
$tasks = Task::select('ekp_task_type', 'task_type', 'task_no', 'task_title', 'customer_name', 'abu_pm', 'erp_version', 'developer', 'developer_workload', 'tester', 'tester_workload', 'comment')->where('task_no', 'like', $query . '%')->orderBy('task_no')->get();
$cellData = [];
$cellData = $tasks->toArray();
// $cellData[] = $title;
Excel::create('本年任务明细-2016-05', function ($excel) use($cellData) {
$excel->sheet('score', function ($sheet) use($cellData) {
$sheet->rows($cellData);
});
})->export('xls');
// $x = Uuid::generate();
// echo $x;
// $customer_details = DB::table('customers')
// ->join('projects2workflow','customers.name','=','projects2workflow.project_name')
// ->select('customers.uuid','projects2workflow.*')
// ->get();
//
//// print_r($customer_details);
//
// foreach($customer_details as $val) {
// $customer_details = new CustomerDetail();
// $customer_details->customer_uuid = $val->uuid;
// $customer_details->customer_name = $val->project_name;
// $customer_details->path = $val->path;
// $customer_details->workflow_path = $val->workflow_path;
// $customer_details->assemblyInfo_path = $val->assemblyInfo_path;
// $customer_details->assemblyInfo = $val->assemblyInfo;
// $customer_details->assemblyFileInfo = $val->assemblyFileInfo;
// $customer_details->workflow_version = $val->workflow_version;
// $customer_details->erp_version = $val->erp_version;
// $customer_details->save();
//// print_r($customer);
// }
}
