projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
PHP 7.4 bug. Fixed in many files.
[fa-stable.git]
/
gl
/
includes
/
db
/
gl_journal.inc
diff --git
a/gl/includes/db/gl_journal.inc
b/gl/includes/db/gl_journal.inc
index f3f49533d8ba388b5d96c1dd521bacc0df7f2e0d..c44cb335b3328b8fd15179cecb5259439ed66d5a 100644
(file)
--- a/
gl/includes/db/gl_journal.inc
+++ b/
gl/includes/db/gl_journal.inc
@@
-13,9
+13,8
@@
function add_journal($type, $trans_no, $amount, $tran_date, $currency, $referenc
$event_date='', $doc_date='')
{
$sql = "INSERT INTO ".TB_PREF."journal(
$event_date='', $doc_date='')
{
$sql = "INSERT INTO ".TB_PREF."journal(
- `type`,`trans_no`, `amount`, `currency`, `rate`, `reference`, `source_ref`, `tran_date`,
- `event_date`, `doc_date`)
- VALUES("
+ `type`,`trans_no`, `amount`, `currency`, `rate`, `reference`, `source_ref`, `tran_date`,`event_date`,`doc_date`)
+ VALUES("
.db_escape($type).","
.db_escape($trans_no).","
.db_escape($amount).","
.db_escape($type).","
.db_escape($trans_no).","
.db_escape($amount).","
@@
-23,9
+22,9
@@
function add_journal($type, $trans_no, $amount, $tran_date, $currency, $referenc
.db_escape($rate).","
.db_escape($reference).","
.db_escape($source_ref).","
.db_escape($rate).","
.db_escape($reference).","
.db_escape($source_ref).","
- ."'".date2sql($tran_date)."',"
- .
"'".date2sql($event_date)."',
"
- .
"'".date2sql($doc_date
)."')";
+ ."'".date2sql($tran_date)."',
'
"
+ .
($event_date === '' ? '0000-00-00' : date2sql($event_date))."','
"
+ .
($doc_date === '' ? '0000-00-00' : date2sql($doc_date)
)."')";
return db_query($sql, 'cannot add journal entry');
}
return db_query($sql, 'cannot add journal entry');
}
@@
-39,9
+38,9
@@
function update_journal($type, $trans_no, $amount, $tran_date, $currency, $refer
."`rate`=".db_escape($rate).","
."`reference`=".db_escape($reference).","
."`source_ref`=".db_escape($source_ref).","
."`rate`=".db_escape($rate).","
."`reference`=".db_escape($reference).","
."`source_ref`=".db_escape($source_ref).","
- ."`tran_date`=
"."
'".date2sql($tran_date)."',"
- ."`event_date`=
"."'".date2sql($event_date
)."',"
- ."`doc_date`=
"."'".date2sql($doc_date)."')
+ ."`tran_date`='".date2sql($tran_date)."',"
+ ."`event_date`=
'".($event_date === '' ? '0000-00-00' : date2sql($event_date)
)."',"
+ ."`doc_date`=
'".($doc_date === '' ? '0000-00-00' : date2sql($doc_date))."'
WHERE `type`=".db_escape($type)." AND " ."`trans_no`=".db_escape($trans_no);
return db_query($sql, 'cannot update journal entry');
WHERE `type`=".db_escape($type)." AND " ."`trans_no`=".db_escape($trans_no);
return db_query($sql, 'cannot update journal entry');
@@
-151,15
+150,10
@@
function void_journal_trans($type, $type_no, $use_transaction=true)
$sql = "UPDATE ".TB_PREF."journal SET amount=0
WHERE type=".db_escape($type)." AND trans_no=".db_escape($type_no);
$sql = "UPDATE ".TB_PREF."journal SET amount=0
WHERE type=".db_escape($type)." AND trans_no=".db_escape($type_no);
-
$result =
db_query($sql, "could not void journal transaction for type=$type and trans_no=$type_no");
+ db_query($sql, "could not void journal transaction for type=$type and trans_no=$type_no");
void_bank_trans($type, $type_no, true);
void_bank_trans($type, $type_no, true);
-// void_gl_trans($type, $type_no, true); // this is done above
-// void_trans_tax_details($type, $type_no); // ditto
-// void_supp_allocations($type, $type_no); // ditto
-// void_cust_allocations($type, $type_no); // ditto
-
if ($use_transaction)
commit_transaction();
}
if ($use_transaction)
commit_transaction();
}