/** Imprime una fila de checkboxes con dos columnas, se le entrega los par�metros en el siguiente orden:
Etiqueta de la fila, Nombre del campo, Arreglo de opciones, Clase CSS, Si es o no campo requerido, El
valor que debe estar chequeado por defecto y el Caracter que divide a cada uno de los botones.*/
function print_checkblock($slabel, $sname, $aoptions, $brequired = false, $checkedval = 0, $sdiv = " ")
{
global $html;
echo "<tr><td><b>{$slabel}</b>";
if ($brequired == true) {
echo "<img src=\"" . $html['imgreq'] . "\" alt=\"Campo Obligatorio\" hspace=3>";
}
echo "</td>";
echo "<td>";
for ($i = 0; $i < count($aoptions); $i++) {
if ($checkedval == $aoptions[$i][1]) {
print_check($aoptions[$i][0], $sname, $aoptions[$i][1], 1);
} else {
print_check($aoptions[$i][0], $sname, $aoptions[$i][1]);
}
echo $sdiv;
}
echo "</td></tr>\n";
}
See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
$page_security = $_POST['PARAM_0'] == $_POST['PARAM_1'] ? 'SA_SUPPTRANSVIEW' : 'SA_SUPPBULKREP';
// ----------------------------------------------------------------
// $ Revision: 2.2 $
// Creator: Joe Hunt - Based on the new Report Engine by Tom Hallman
// Creator: Based on Tom Hallman's Report.
// Date: 2010-03-03
// Title: Printable Check
// ----------------------------------------------------------------
$path_to_root = "..";
include_once $path_to_root . "/includes/session.inc";
include_once $path_to_root . "/includes/date_functions.inc";
include_once $path_to_root . "/includes/data_checks.inc";
//----------------------------------------------------------------------------------------------------
print_check();
//----------------------------------------------------------------------------------------------------
function get_remittance($type, $trans_no)
{
$sql = "SELECT " . TB_PREF . "supp_trans.*, \n \t\t(" . TB_PREF . "supp_trans.ov_amount+" . TB_PREF . "supp_trans.ov_gst+" . TB_PREF . "supp_trans.ov_discount) AS Total, \n \t\t" . TB_PREF . "suppliers.supp_name, " . TB_PREF . "suppliers.supp_account_no,\n \t\t" . TB_PREF . "suppliers.curr_code, " . TB_PREF . "suppliers.payment_terms, " . TB_PREF . "suppliers.gst_no AS tax_id, \n \t\t" . TB_PREF . "suppliers.address, " . TB_PREF . "suppliers.contact\n\t\tFROM " . TB_PREF . "supp_trans, " . TB_PREF . "suppliers\n\t\tWHERE " . TB_PREF . "supp_trans.supplier_id = " . TB_PREF . "suppliers.supplier_id\n\t\tAND " . TB_PREF . "supp_trans.type = " . db_escape($type) . "\n\t\tAND " . TB_PREF . "supp_trans.trans_no = " . db_escape($trans_no);
$result = db_query($sql, "The remittance cannot be retrieved");
if (db_num_rows($result) == 0) {
return false;
}
return db_fetch($result);
}
function get_allocations_for_remittance($supplier_id, $type, $trans_no)
{
$sql = get_alloc_supp_sql("amt, supp_reference, trans.alloc", "trans.trans_no = alloc.trans_no_to\n\t\tAND trans.type = alloc.trans_type_to\n\t\tAND alloc.trans_no_from=" . db_escape($trans_no) . "\n\t\tAND alloc.trans_type_from=" . db_escape($type) . "\n\t\tAND trans.supplier_id=" . db_escape($supplier_id), TB_PREF . "supp_allocations as alloc");
$sql .= " ORDER BY trans_no";
return db_query($sql, "Cannot retreive alloc to transactions");
