See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
/* Author Rob Mallon */
See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
/* Author Rob Mallon */
include($path_to_root . "/includes/db_pager.inc");
include_once($path_to_root . "/includes/session.inc");
include($path_to_root . "/includes/db_pager.inc");
include_once($path_to_root . "/includes/session.inc");
-page(_("Reconcile Bank Account"), false, false, "", $js);
+page(_($help_context = "Reconcile Bank Account"), false, false, "", $js);
$_POST['bank_date'] = date2sql(get_post('reconcile_date'));
$reconcile_value = check_value("rec_".$reconcile_id)
? ("'".$_POST['bank_date'] ."'") : 'NULL';
$_POST['bank_date'] = date2sql(get_post('reconcile_date'));
$reconcile_value = check_value("rec_".$reconcile_id)
? ("'".$_POST['bank_date'] ."'") : 'NULL';
- $sql = "UPDATE ".TB_PREF."bank_trans SET reconciled=".db_escape($reconcile_value)
- ." WHERE id=".db_escape($reconcile_id);
+ $sql = "UPDATE ".TB_PREF."bank_trans SET reconciled=$reconcile_value"
+ ." WHERE id=".db_escape($reconcile_id);
db_query($sql, "Can't change reconciliation status");
// save last reconcilation status (date, end balance)
db_query($sql, "Can't change reconciliation status");
// save last reconcilation status (date, end balance)
$sql = "SELECT MAX(reconciled) as last_date,
SUM(IF(reconciled<='$date', amount, 0)) as end_balance,
$sql = "SELECT MAX(reconciled) as last_date,
SUM(IF(reconciled<='$date', amount, 0)) as end_balance,
start_row();
date_cells("", "reconcile_date", _('Date of bank statement to reconcile'),
start_row();
date_cells("", "reconcile_date", _('Date of bank statement to reconcile'),
- null, 0, 0, 0, null, true);
+ get_post('bank_date')=='', 0, 0, 0, null, true);
"X"=>array('insert'=>true, 'fun'=>'rec_checkbox')
);
$table =& new_db_pager('trans_tbl', $sql, $cols);
"X"=>array('insert'=>true, 'fun'=>'rec_checkbox')
);
$table =& new_db_pager('trans_tbl', $sql, $cols);