コード例 #1
0
ファイル: HomeRepository.php プロジェクト: rob1121/qdn
 public function counter()
 {
     $collections = collect(['PeVerification' => 'P.e. Verification', 'Incomplete' => 'Incomplete Fill-Up', 'Approval' => 'Incomplete Approval', 'QaVerification' => 'Q.a. Verification'])->map(function ($status) {
         return Closure::statusCount($status);
     })->merge(['today' => Info::todayCount(), 'week' => Info::weekCount(), 'month' => Info::monthCount(), 'year' => Info::yearCount()]);
     return $collections;
 }
コード例 #2
0
ファイル: HomeController.php プロジェクト: rob1121/qdn
 public function getQdnLinkAndData(Request $request)
 {
     return Closure::status($request->status)->map(function ($item) {
         array_add($item, 'action_link', static::actionLink($item));
         array_add($item, 'gate', Gate::allows('mod-qdn', $item->info->slug));
         return array_add($item, 'receiver_name', InvolvePerson::getInvolvePerson($item->info_id));
     });
 }
コード例 #3
0
ファイル: DummyInfoSeeder.php プロジェクト: rob1121/qdn
 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     DB::table('infos')->delete();
     $faker = \Faker\Factory::create();
     foreach (range(1, 20) as $index) {
         $employee = Employee::all();
         $originator = $employee->random();
         $close_by = Employee::where('station', 'quality assurance')->first();
         $issuedTo = $employee->random();
         $major = 'major';
         $year = Carbon::now('Asia/Manila')->format('y');
         $info = Info::create(['control_id' => $year . "-" . sprintf("%'.04d", $index), 'customer' => $faker->randomElement(array_flatten(Option::all('customer')->toArray())), 'package_type' => $faker->firstNameFemale, 'device_name' => $faker->address, 'lot_id_number' => $faker->randomDigit, 'lot_quantity' => $faker->randomNumber(4), 'job_order_number' => $faker->randomElement(['0', '1', '2']), 'machine' => $faker->randomElement(['at01', 'at02', 'at03', 'at04', 'at05']), 'station' => $faker->randomElement(['pl1', 'pl2', 'pl3', 'pl4', 'pl5']), 'created_at' => $faker->dateTimeThisMonth, 'major' => $major, 'disposition' => $faker->randomElement(['use as is', 'ncmr#', 'rework', 'split lot', 'shutdown', 'shipback']), 'problem_description' => $faker->paragraph(2), 'failure_mode' => $faker->randomelement(['assembly', 'environment', 'machine', 'man', 'material', 'method / process']), 'discrepancy_category' => $faker->randomelement(['MISSING UNIT(S)', 'LOW YIELD', 'WRONG TRANSACTION', 'CANT CREATE', 'FOREIGN MATERIAL', 'WRONG MERGING', 'DATECODE DISCREPANCY', 'MARKING PROBLEM', 'MIXED DEVICE', 'BENT LEAD', 'LEAD CONTAMINATION', 'LEAD DISCOLORATION', 'LEAD COPLANARITY']), 'quantity' => $faker->randomNumber(4)]);
         CauseOfDefect::create(['info_id' => $info->id, 'cause_of_defect' => $faker->randomElement(['PRODUCTION', 'PROCESS', 'MAINTENANCE', 'FACILITIES', 'QUALITY ASSURANCE', 'OTHERS']), 'cause_of_defect_description' => $faker->paragraph(2), 'objective_evidence' => 'N/A']);
         ContainmentAction::create(['info_id' => $info->id, 'what' => $faker->paragraph(2), 'who' => $faker->name('male' | 'female'), 'objective_evidence' => 'N/A', 'created_at' => $info->created_at]);
         CorrectiveAction::create(['info_id' => $info->id, 'what' => $faker->paragraph(2), 'who' => $faker->name('male' | 'female'), 'objective_evidence' => 'N/A', 'created_at' => $info->created_at]);
         PreventiveAction::create(['info_id' => $info->id, 'what' => $faker->paragraph(2), 'who' => $faker->name('male' | 'female'), 'objective_evidence' => 'N/A', 'created_at' => $info->created_at]);
         QdnCycle::create(['info_id' => $info->id, 'cycle_time' => '24', 'production_cycle_time' => '24', 'process_engineering_cycle_time' => '24', 'quality_assurance_cycle_time' => '24', 'other_department_cycle_time' => '24', 'created_at' => $info->created_at]);
         InvolvePerson::create(['info_id' => $info->id, 'station' => $originator->station, 'originator_id' => $originator->user_id, 'originator_name' => $originator->name, 'receiver_id' => $issuedTo->user_id, 'receiver_name' => $issuedTo->name, 'created_at' => $info->created_at]);
         Closure::create(['info_id' => $info->id, 'containment_action_taken' => $faker->randomElement(['yes', 'no']), 'corrective_action_taken' => $faker->randomElement(['yes', 'no']), 'close_by' => $close_by->name, 'date_sign' => Carbon::parse($info->created_at)->addDay(), 'production' => $employee->where('department', 'production')->random()->name, 'process_engineering' => $employee->where('department', 'process_engineering')->random()->name, 'quality_assurance' => $employee->where('department', 'quality_assurance')->random()->name, 'other_department' => $employee->where('department', 'other_department')->random()->name, 'status' => 'Closed', 'created_at' => $info->created_at]);
     }
 }
コード例 #4
0
ファイル: Api.php プロジェクト: rob1121/qdn
 protected function getColumnMonthCreatedTimeAndClosingTime($month)
 {
     return Closure::CycleTimeForMonth($month)->map(function ($key) {
         return ['month' => $key->month, 'created' => strtotime($key->created_at), 'closed' => strtotime($key->date_sign)];
     });
 }
コード例 #5
0
ファイル: Closure.php プロジェクト: rob1121/qdn
 public static function CycleTimeForMonth($month)
 {
     return Closure::select(DB::raw("MONTH(created_at) as month"), 'created_at', 'date_sign')->where(DB::raw('MONTH(created_at)'), $month)->whereStatus('closed')->get();
 }
コード例 #6
0
ファイル: DbInfo.php プロジェクト: rob1121/qdn
 protected function setQdnStatus()
 {
     Closure::whereInfoId($this->qdn->id)->update(['status' => 'p.e. verification']);
 }
コード例 #7
0
 protected function save()
 {
     Closure::where('info_id', $this->qdn->id)->update($this->setOfClosureCollection());
     return $this;
 }
コード例 #8
0
ファイル: QdnCountAndData.php プロジェクト: rob1121/qdn
 public static function getCount($status)
 {
     return Closure::where('status', $status)->count();
 }