public static function createJV($data)
{
$jv = $data['JV'];
$entries = json_decode($data['entries']);
$userID = $data['userID'];
$JVNo = JVoucher::JVnum();
$JVNumSeries = JVoucher::getJVNum();
$ID = $JVNumSeries[0]->idNum;
$Voucher = $JVNumSeries[0]->numSeries + 1;
DB::table('tbl_series')->where('idNum', $ID)->update(['numSeries' => $Voucher]);
$id = DB::table('tbl_gj')->insertGetId(['JVNum' => $JVNo[0]->JV, 'transDate' => Carbon::NOW(), 'prepBy' => $userID, 'particulars' => $jv['particulars']]);
for ($i = 0; $i < count($entries); $i++) {
$var = $entries[$i];
$amount = isset($var->DB) && $var->DB > 0 ? $var->DB : $var->CR;
if (isset($var->DB) && !empty($var->DB)) {
$ID = $var->title;
} else {
$ID = null;
}
if (isset($var->CR) && !empty($var->CR)) {
$ID2 = $var->title;
} else {
$ID2 = null;
}
DB::table('tbl_journalEntries')->insert(['JID' => $id, 'idAcctTitleDB' => $ID, 'idAcctTitleCR' => $ID2, 'amount' => $amount]);
}
if ($id) {
$ids['success'] = 'true';
$ids['msg'] = 'New Journal Voucher Entry has been saved.';
} else {
$ids['success'] = 'false';
$ids['msg'] = 'WARNING: Unknown error occur while saving the record';
}
return $ids;
}
public function getGJEntries(Request $request)
{
$input = $request->all();
$data = JVoucher::getGJEntries($input['from'], $input['to']);
return response()->json($data);
}
