private function updateId()
{
$compcats = Compcat::all();
foreach ($compcats as $compcat) {
$new = Compcat::find($compcat->id);
$new->id = Compcat::get_uid();
$new->save();
}
}
public function search(Request $request)
{
$arr = [];
if ($request->has('q')) {
$q = $request->input('q');
$branchid = $request->input('branchid');
$components = Component::where('descriptor', 'like', '%' . $q . '%')->orderBy('descriptor')->get(['descriptor', 'id']);
foreach ($components as $component) {
array_push($arr, ['table' => 'component', 'item' => $component->descriptor, 'id' => strtolower($component->id)]);
}
$compcats = Compcat::where('descriptor', 'like', '%' . $q . '%')->orderBy('descriptor')->get(['descriptor', 'id']);
foreach ($compcats as $compcat) {
array_push($arr, ['table' => 'compcat', 'item' => $compcat->descriptor, 'id' => strtolower($compcat->id)]);
}
$expenses = Expense::where('descriptor', 'like', '%' . $q . '%')->orderBy('descriptor')->get(['descriptor', 'id']);
foreach ($expenses as $expense) {
array_push($arr, ['table' => 'expense', 'item' => $expense->descriptor, 'id' => strtolower($expense->id)]);
}
$expscats = Expscat::where('descriptor', 'like', '%' . $q . '%')->orderBy('descriptor')->get(['descriptor', 'id']);
foreach ($expscats as $expscat) {
array_push($arr, ['table' => 'expscat', 'item' => $expscat->descriptor, 'id' => strtolower($expscat->id)]);
}
$suppliers = Supplier::where('descriptor', 'like', '%' . $q . '%')->where('branchid', $branchid)->orderBy('descriptor')->get(['descriptor', 'id']);
foreach ($suppliers as $supplier) {
array_push($arr, ['table' => 'supplier', 'item' => $supplier->descriptor, 'id' => strtolower($supplier->id)]);
}
//$payments = ['110A573E855511E68FF47E841D02B37D'=>'cash', '19ADA60B855511E68FF47E841D02B37D'=>'check'];
$payments = ['c' => 'cash', 'k' => 'check'];
$s = preg_grep("/^" . strtolower($q) . "/", $payments);
if ($s) {
$k = key($s);
array_push($arr, ['table' => 'payment', 'item' => ucwords($s[$k]), 'id' => strtolower($k)]);
}
}
//return $arr;
if ($request->ajax()) {
return $arr;
} else {
return abort('404');
}
}