public function details($id)
{
$store_audit = StoreAudit::findOrFail($id);
$details = StoreAuditDetail::getDetails($store_audit->id);
foreach ($details as $key => $value) {
$img = explode(".", $value->answer);
if (isset($img[1]) && strtolower($img[1]) == "jpg") {
$link = url('auditimage/' . $id . '/' . $value->answer);
$value->answer = $link;
}
}
\Excel::create($store_audit->store_name . ' - ' . $store_audit->template_name, function ($excel) use($details) {
$excel->sheet('Sheet1', function ($sheet) use($details) {
$sheet->fromModel($details, null, 'A1', true);
})->download('xls');
});
}
public function storeaudit(Request $request)
{
if ($request->hasFile('data')) {
$destinationPath = storage_path() . '/uploads/audit/';
$fileName = $request->file('data')->getClientOriginalName();
$request->file('data')->move($destinationPath, $fileName);
$filePath = storage_path() . '/uploads/audit/' . $fileName;
$filename_data = explode("_", $fileName);
$user_id = $filename_data[0];
$store_code = $filename_data[1];
DB::beginTransaction();
try {
$reader = ReaderFactory::create(Type::CSV);
// for XLSX files
$reader->setFieldDelimiter('|');
$reader->open($filePath);
$first_row = true;
$summary = false;
$audit_id = 0;
foreach ($reader->getSheetIterator() as $sheet) {
foreach ($sheet->getRowIterator() as $row) {
if ($first_row) {
$start_date = date_format(date_create($row[11]), "Y-m-d");
$end_date = date_format(date_create($row[12]), "Y-m-d");
$audit = StoreAudit::where('user_id', $row[0])->where('store_code', $row[9])->where('start_date', $start_date)->where('end_date', $end_date)->first();
if (!empty($audit)) {
$audit->user_id = $row[0];
$audit->user_name = $row[1];
$audit->account = $row[2];
$audit->customer_code = $row[3];
$audit->customer = $row[4];
$audit->region_code = $row[5];
$audit->region = $row[6];
$audit->distributor_code = $row[7];
$audit->distributor = $row[8];
$audit->store_code = $row[9];
$audit->store_name = $row[10];
$audit->start_date = $start_date;
$audit->end_date = $end_date;
$audit->template_code = $row[13];
$audit->template_name = $row[14];
$audit->passed = $row[15];
$audit->updated_at = date('Y-m-d H:i:s');
$audit->update();
$audit_id = $audit->id;
StoreAuditDetail::where('store_audit_id', $audit_id)->delete();
StoreAuditSummary::where('store_audit_id', $audit_id)->delete();
} else {
$new_audit = new StoreAudit();
$new_audit->user_id = $row[0];
$new_audit->user_name = $row[1];
$new_audit->account = $row[2];
$new_audit->customer_code = $row[3];
$new_audit->customer = $row[4];
$new_audit->region_code = $row[5];
$new_audit->region = $row[6];
$new_audit->distributor_code = $row[7];
$new_audit->distributor = $row[8];
$new_audit->store_code = $row[9];
$new_audit->store_name = $row[10];
$new_audit->start_date = $start_date;
$new_audit->end_date = $end_date;
$new_audit->template_code = $row[13];
$new_audit->template_name = $row[14];
$new_audit->passed = $row[15];
$new_audit->save();
$audit_id = $new_audit->id;
}
$first_row = false;
} else {
if ($row[0] == 'audit_summary') {
$summary = true;
continue;
}
if (!$summary) {
StoreAuditDetail::insert(['store_audit_id' => $audit_id, 'category' => $row[0], 'group' => $row[1], 'prompt' => $row[2], 'type' => $row[3], 'answer' => $row[4]]);
} else {
StoreAuditSummary::insert(['store_audit_id' => $audit_id, 'category' => $row[0], 'group' => $row[1], 'passed' => $row[2]]);
}
}
}
}
$reader->close();
DB::commit();
return response()->json(array('msg' => 'file uploaded', 'status' => 0, 'audit_id' => $audit_id));
} catch (Exception $e) {
DB::rollback();
return response()->json(array('msg' => 'file uploaded error', 'status' => 1));
}
}
return response()->json(array('msg' => 'file uploaded error', 'status' => 1));
}