private function getIndex(Request $request)
{
$date = is_null($request->input('date')) ? $this->dr->now : carbonCheckorNow($request->input('date'));
$data = $this->timelog->allByDate($date);
//return dd($data);
return $this->setViewWithDR(view('timesheet.index')->with('dr', $this->dr)->with('data', $data));
}
private function backupParseDate($filename)
{
$f = pathinfo($filename, PATHINFO_FILENAME);
$m = substr($f, 2, 2);
$d = substr($f, 4, 2);
$y = '20' . substr($f, 6, 2);
if (is_iso_date($y . '-' . $m . '-' . $d)) {
return carbonCheckorNow($y . '-' . $m . '-' . $d);
} else {
return false;
}
}
public function apiGetPurchase(Request $request)
{
//$categories
$date = carbonCheckorNow($request->input('date'));
$data = $this->getPurchaseByDate($date);
$json = ['status' => 'success', 'code' => 200, 'data' => ['items' => ['date' => $date->format('Y-m-d'), 'data' => $data], 'stats' => ['categories' => $this->getFieldTotal($data, 'catname', 'tcost'), 'expenses' => $this->getExpenseTotal($data, 'tcost'), 'suppliers' => $this->getFieldTotal($data, 'supname', 'tcost')]]];
if ($request->ajax()) {
return response()->json($json);
return response()->json(['status' => 'success', 'code' => 200, 'date' => $date->format('Y-m-d'), 'data' => $data]);
} else {
if (intval($request->input('download')) === 1) {
return $this->export($data, $date);
} else {
return $data;
}
}
}
public function apiGetPurchase(Request $request)
{
$branch = $this->branch->findByField('id', $request->input('branchid'))->first();
$date = carbonCheckorNow($request->input('date'));
if (is_null($branch)) {
$status = 'warning';
$msg = 'Branch not found!';
$code = 300;
$categories = [];
$expenses = [];
$suppliers = [];
$data = [];
} else {
$status = 'success';
$msg = 'success on fetching data';
$code = 200;
$data = $this->getPurchaseByDateBranch($branch->id, $date);
$categories = $this->getFieldTotal($data, 'catname', 'tcost');
$expenses = $this->getExpenseTotal($data, 'tcost');
$suppliers = $this->getFieldTotal($data, 'supname', 'tcost');
}
//$categories
$json = ['status' => $status, 'code' => $code, 'message' => $msg, 'data' => ['items' => ['date' => $date->format('Y-m-d'), 'data' => $data], 'stats' => ['categories' => $categories, 'expenses' => $expenses, 'suppliers' => $suppliers]]];
if ($request->ajax()) {
return response()->json($json);
} else {
if (intval($request->input('download')) === 1) {
if (is_null($branch)) {
return $msg;
}
return $this->export($data, $date, $branch);
} else {
return $data;
}
}
}
public function getChecklist(Request $request)
{
$date = carbonCheckorNow($request->input('date'));
$backups = $this->backup->monthlyLogs($date);
return view('backups.checklist')->with('date', $date)->with('backups', $backups);
}
public function getDashboardCSV(Request $request)
{
$date = carbonCheckorNow($request->input('date'));
//echo $date->month.' - '. $date->daysInMonth .'<br>';
$bb = $this->bb->with('branch')->all();
echo "Date";
foreach ($bb as $b) {
echo ',';
echo $b->branch->code;
}
echo PHP_EOL;
//echo '<br>';
for ($i = 1; $i <= $date->daysInMonth; $i++) {
$day = Carbon::parse($date->year . '-' . $date->month . '-' . $i);
echo $day->format('Y-m-d') . ",";
foreach ($bb as $b) {
$ds = $this->repo->findWhere(['date' => $day->format('Y-m-d'), 'branchid' => $b->branchid])->first();
echo is_null($ds) ? 0 : $ds->sales;
echo $bb->last() == $b ? '' : ',';
//echo ",";
}
echo PHP_EOL;
//echo '<br>';
}
return;
//$response = new Response;
//$response->header('Content-Type', 'plain/text');
//$response->header('Content-Disposition', 'attachment; filename="data.csv"');
//return $response;
}
public function getComparativeJSON(Request $request)
{
$this->dr->fr = carbonCheckorNow($request->input('fr'));
$this->dr->to = carbonCheckorNow($request->input('to'));
$arr = [];
$branches = $this->repository->findWhereIn('id', $request->input('branches'), ['code', 'descriptor', 'mancost', 'id']);
$dss = $this->ds->skipCache()->with(['branch' => function ($query) {
$query->select(['code', 'descriptor', 'mancost', 'id']);
}])->scopeQuery(function ($query) use($request) {
return $query->whereBetween('date', [$this->dr->fr->format('Y-m-d'), $this->dr->to->format('Y-m-d')])->whereIn('branchid', $request->input('branches'))->orderBy('date', 'ASC');
})->all();
foreach ($branches as $b) {
$arr[$b->code] = [];
foreach ($this->dr->dateInterval() as $date) {
$filtered = $dss->filter(function ($item) use($b, $date) {
return $item->branchid == $b->id && $item->date->format('Y-m-d') == $date->format('Y-m-d') ? $item : null;
})->first();
$ds = $filtered;
$data['date'] = $date->format('Y-m-d');
$data['timestamp'] = $date->timestamp;
if (is_null($ds)) {
$data['sales'] = 0;
$data['mancost'] = 0;
$data['mancostpct'] = 0;
$data['tips'] = 0;
$data['tipspct'] = 0;
$data['salesemp'] = 0;
$data['purchcost'] = 0;
} else {
$data['sales'] = (double) $ds->sales;
$data['mancost'] = (double) number_format($ds->empcount * $b->mancost, 2, '.', '');
$data['mancostpct'] = (double) $ds->mancostpct;
$data['tips'] = (double) $ds->tips;
$data['tipspct'] = (double) $ds->tipspct;
$data['salesemp'] = $ds->empcount == '0' ? (double) '0.00' : (double) number_format($ds->sales / $ds->empcount, 2, '.', '');
$data['purchcost'] = (double) $ds->purchcost;
}
array_push($arr[$b->code], $data);
}
}
//return response()->json($arr);
return response($arr)->header('Content-Type', 'text/json')->withCookie(cookie('to', $this->dr->to->format('Y-m-d'), 120))->withCookie(cookie('fr', $this->dr->fr->format('Y-m-d'), 120));
}
private function setDateRangeMode(Request $request, $mode = 'day')
{
$y = false;
switch ($mode) {
case 'month':
$to = !is_null($request->input('to')) ? carbonCheckorNow($request->input('to')) : Carbon::now()->endOfMonth();
$fr = !is_null($request->input('fr')) ? carbonCheckorNow($request->input('fr')) : $to->copy()->subMonths(5)->startOfMonth();
if ($to->lt($fr)) {
$to = Carbon::now()->endOfMonth();
$fr = $to->copy()->subMonths(5)->startOfMonth();
//$to->copy()->startOfMonth();
} else {
$to = $to->endOfMonth();
$fr = $fr->startOfMonth();
}
break;
case 'daily':
$to = !is_null($request->input('to')) ? carbonCheckorNow($request->input('to')) : Carbon::now()->endOfMonth();
$fr = !is_null($request->input('fr')) ? carbonCheckorNow($request->input('fr')) : $to->copy()->startOfMonth();
if ($to->lt($fr)) {
$to = Carbon::now();
$fr = $to->copy()->startOfMonth();
}
break;
case 'weekly':
$to = !is_null($request->input('to')) ? carbonCheckorNow($request->input('to')) : Carbon::now()->endOfWeek();
$fr = !is_null($request->input('fr')) ? carbonCheckorNow($request->input('fr')) : $to->copy()->subWeeks(5)->startOfWeek();
if ($to->lt($fr)) {
$to = Carbon::now()->endOfWeek();
$fr = $to->copy()->subWeeks(5)->startOfWeek();
//$to->copy()->startOfWeek();
} else {
$to = $to->endOfWeek();
$fr = $fr->startOfWeek();
}
break;
case 'quarterly':
$to = !is_null($request->input('to')) ? carbonCheckorNow($request->input('to')) : Carbon::now()->lastOfQuarter();
$fr = !is_null($request->input('fr')) ? carbonCheckorNow($request->input('fr')) : $to->copy()->subMonths(11)->firstOfQuarter();
if ($to->lt($fr)) {
$to = Carbon::now()->lastOfQuarter();
$fr = $to->copy()->subMonths(12)->firstOfQuarter();
//$to->copy()->startOfWeek();
} else {
$to = $to->lastOfQuarter();
$fr = $fr->firstOfQuarter();
}
break;
case 'yearly':
$y = true;
$to = !is_null($request->input('to')) ? carbonCheckorNow($request->input('to')) : Carbon::now()->lastOfYear();
$fr = !is_null($request->input('fr')) ? carbonCheckorNow($request->input('fr')) : $to->copy()->subYear()->firstOfYear();
if ($to->lt($fr)) {
$to = Carbon::now()->lastOfYear();
$fr = $to->copy()->subYear()->firstOfYear();
//$to->copy()->startOfWeek();
} else {
$to = $to->lastOfYear();
$fr = $fr->firstOfYear();
}
break;
default:
$to = Carbon::now()->endOfMonth();
$fr = $to->copy()->startOfMonth();
break;
}
if (!$y) {
// if more than a year
if ($fr->diffInDays($to, false) >= 731) {
// 730 = 2yrs
$this->dr->fr = $to->copy()->subDays(730)->startOfMonth();
$this->dr->to = $to;
$this->dr->date = $to;
return false;
}
}
$this->dr->fr = $fr;
$this->dr->to = $to;
$this->dr->date = $to;
return true;
}
public function setDateRangeMode($arg = null, $arg2 = null)
{
if (is_null($arg) && is_null($arg)) {
$request = $this->request;
$mode = 'daily';
} elseif (in_array($arg, $this->modes) && $arg2 == null) {
$request = $this->request;
$mode = $arg;
} elseif ($arg instanceof Request && in_array($arg2, $this->modes)) {
$request = $arg;
$mode = $arg2;
}
//$this->setDateRangeFromRequest($request);
$this->mode = $mode;
$y = false;
switch ($mode) {
case 'monthly':
$this->to = !is_null($request->input('to')) ? carbonCheckorNow($request->input('to')) : Carbon::now()->endOfMonth();
$this->fr = !is_null($request->input('fr')) ? carbonCheckorNow($request->input('fr')) : $this->to->copy()->subMonths(5)->startOfMonth();
if ($this->to->lt($this->fr)) {
$this->to = Carbon::now()->endOfMonth();
$this->fr = $this->to->copy()->subMonths(5)->startOfMonth();
//$this->to->copy()->startOfMonth();
} else {
$this->to = $this->to->endOfMonth();
$this->fr = $this->fr->startOfMonth();
}
break;
case 'daily':
$this->to = !is_null($request->input('to')) ? carbonCheckorNow($request->input('to')) : Carbon::now()->endOfMonth();
$this->fr = !is_null($request->input('fr')) ? carbonCheckorNow($request->input('fr')) : $this->to->copy()->startOfMonth();
if ($this->to->lt($this->fr)) {
$this->to = Carbon::now();
$this->fr = $this->to->copy()->startOfMonth();
}
break;
case 'weekly':
$this->to = !is_null($request->input('to')) ? carbonCheckorNow($request->input('to')) : Carbon::now()->endOfWeek();
$this->fr = !is_null($request->input('fr')) ? carbonCheckorNow($request->input('fr')) : $this->to->copy()->subWeeks(5)->startOfWeek();
if ($this->to->lt($this->fr)) {
$this->to = Carbon::now()->endOfWeek();
$this->fr = $this->to->copy()->subWeeks(5)->startOfWeek();
//$this->to->copy()->startOfWeek();
} else {
$this->to = $this->to->endOfWeek();
$this->fr = $this->fr->startOfWeek();
}
break;
case 'quarterly':
$this->to = !is_null($request->input('to')) ? carbonCheckorNow($request->input('to')) : Carbon::now()->lastOfQuarter();
$this->fr = !is_null($request->input('fr')) ? carbonCheckorNow($request->input('fr')) : $this->to->copy()->subMonths(11)->firstOfQuarter();
if ($this->to->lt($this->fr)) {
$this->to = Carbon::now()->lastOfQuarter();
$this->fr = $this->to->copy()->subMonths(12)->firstOfQuarter();
//$this->to->copy()->startOfWeek();
} else {
$this->to = $this->to->lastOfQuarter();
$this->fr = $this->fr->firstOfQuarter();
}
break;
case 'yearly':
$y = true;
$this->to = !is_null($request->input('to')) ? carbonCheckorNow($request->input('to')) : Carbon::now()->lastOfYear();
$this->fr = !is_null($request->input('fr')) ? carbonCheckorNow($request->input('fr')) : $this->to->copy()->subYear()->firstOfYear();
if ($this->to->lt($this->fr)) {
$this->to = Carbon::now()->lastOfYear();
$this->fr = $this->to->copy()->subYear()->firstOfYear();
//$this->to->copy()->startOfWeek();
} else {
$this->to = $this->to->lastOfYear();
$this->fr = $this->fr->firstOfYear();
}
break;
default:
$this->to = Carbon::now()->endOfDay();
$this->fr = $this->to->copy()->startOfMonth();
break;
}
if (!$y) {
// if more than a year
if ($this->fr->diffInDays($this->to, false) >= 731) {
// 730 = 2yrs
$this->fr = $this->to->copy()->subDays(730)->startOfMonth();
$this->to = $this->to;
$this->date = $this->to;
return false;
}
}
return true;
}
private function getPrintIndex(Request $request)
{
$date = is_null($request->input('date')) ? $this->dr->date : carbonCheckorNow($request->input('date'));
$data = $this->timelog->allByDate($date);
return view('timesheet.index-print')->with('dr', $this->dr)->with('data', $data);
}
public function getChecklist(Request $request)
{
$bb = $this->branch->orderBy('code')->getByCriteria(new ActiveBranch())->all(['code', 'descriptor', 'id']);
$date = carbonCheckorNow($request->input('date'));
if (!$request->has('branchid') && !isset($_GET['branchid'])) {
return view('backup.checklist')->with('date', $date)->with('branches', $bb)->with('branch', null)->with('backups', null);
}
if (!is_uuid($request->input('branchid')) || !in_array(strtoupper($request->input('branchid')), $this->branch->all()->pluck('id')->all())) {
return redirect('/backup/checklist')->with('alert-warning', 'Please select a branch.');
}
try {
$branch = $this->branch->find(strtolower($request->input('branchid')));
} catch (Exception $e) {
return redirect('/backup/checklist')->with('alert-warning', 'Please select a branch.');
}
$backups = $this->repository->monthlyLogs($date, $branch);
return view('backup.checklist')->with('date', $date)->with('branches', $bb)->with('branch', $branch)->with('backups', $backups);
}
