Search options (Page 3 of 4)

function show_allocatable($show_totals) {

    global $systypes_array;
    
    $k = $total_allocated = 0;

    $cart = $_SESSION['alloc'];
    $supp_ref = in_array($cart->type, array(ST_SUPPCREDIT, ST_SUPPAYMENT, ST_BANKPAYMENT));

    if (count($cart->allocs)) 
    {
        display_heading(sprintf(_("Allocated amounts in %s:"), $cart->person_curr));
        start_table(TABLESTYLE, "width='60%'");
           $th = array(_("Transaction Type"), _("#"), _("Branch"), $supp_ref ? _("Supplier Ref"): _("Ref"), _("Date"), _("Due Date"), _("Amount"),
               _("Other Allocations"), _("Left to Allocate"), _("This Allocation"),'',''); // added branch heading

           table_header($th);

        foreach ($cart->allocs as $id => $alloc_item)
        {
            if (floatcmp(abs($alloc_item->amount), $alloc_item->amount_allocated))
            {
                $myrow = get_customer_trans($alloc_item->type_no, ST_SALESINVOICE);// new to get trans data
                alt_table_row_color($k);
                label_cell($systypes_array[$alloc_item->type]);
                   label_cell(get_trans_view_str($alloc_item->type, $alloc_item->type_no), "nowrap align='right'");
                   label_cell($myrow['br_name'], "nowrap align='right'"); // to output branch
                   label_cell($alloc_item->ref);
                label_cell($alloc_item->date_, "align=right");
                label_cell($alloc_item->due_date, "align=right");
                amount_cell(abs($alloc_item->amount));
                amount_cell($alloc_item->amount_allocated);

                $_POST['amount' . $id] = price_format($alloc_item->current_allocated);

                $un_allocated = round((abs($alloc_item->amount) - $alloc_item->amount_allocated), 6);
                amount_cell($un_allocated, false,'', 'maxval'.$id);
                amount_cells(null, "amount" . $id);//, input_num('amount' . $id));
                label_cell("<a href='javascript:void(0)' name=Alloc$id onclick='allocate_all(this.name.substr(5));return true;'>"
                     . _("All") . "</a>");
                label_cell("<a href='javascript:void(0)' name=DeAll$id onclick='allocate_none(this.name.substr(5));return true;'>"
                     . _("None") . "</a>".hidden("un_allocated" . $id, 
                     price_format($un_allocated), false));
                end_row();

                   $total_allocated += input_num('amount' . $id);
               }
        }
        if ($show_totals) {
               label_row(_("Total Allocated"), price_format($total_allocated),
                "colspan=8 align=right", "align=right id='total_allocated'", 3);

            $amount = abs($cart->amount);

            if (floatcmp($amount, $total_allocated) < 0)
            {
                $font1 = "<font color=red>";
                $font2 = "</font>";
            }
            else
                $font1 = $font2 = "";
            $left_to_allocate = price_format($amount - $total_allocated);
            label_row(_("Left to Allocate"), $font1 . $left_to_allocate . $font2, 
                "colspan=8 align=right", "nowrap align=right id='left_to_allocate'",
                 3);
        }
        end_table(1);
    }
    hidden('TotalNumberOfAllocs', count($cart->allocs));
}

$reports->addReport(RC_CUSTOMER, 107, _('Print &Invoices'),
    array(    //_('From') => 'INVOICE',       // removed for date
            //_('To') => 'INVOICE',         // removed for date  
            _('Start Date') => 'DATEBEGINM',    // added for date
            _('End Date') => 'DATEENDM',        // added for date
            _('Currency Filter') => 'CURRENCY',
            _('email Customers') => 'YES_NO',
            _('Payment Link') => 'PAYMENT_LINK',
            _('Comments') => 'TEXTBOX',
            _('Customer') => 'CUSTOMERS_NO_FILTER',
            _('Orientation') => 'ORIENTATION'
));

function get_invoice_range($from, $to, $currency=false)
{
    global $SysPrefs;
//--- new for date search instead of     
    $fromdate = date2sql($from);
    $todate = date2sql($to);
//---- End new stuff    


    $ref = ($SysPrefs->print_invoice_no() == 1 ? "trans_no" : "reference");

    $sql = "SELECT trans.trans_no, trans.reference";

//  if($currency !== false)
//        $sql .= ", cust.curr_code";

    $sql .= " FROM ".TB_PREF."debtor_trans trans 
            LEFT JOIN ".TB_PREF."voided voided ON trans.type=voided.type AND trans.trans_no=voided.id";

    if ($currency !== false)
        $sql .= " LEFT JOIN ".TB_PREF."debtors_master cust ON trans.debtor_no=cust.debtor_no";

    $sql .= " WHERE trans.type=".ST_SALESINVOICE
        ." AND ISNULL(voided.id)"
     //    ." AND trans.trans_no BETWEEN ".db_escape($from)." AND ".db_escape($to) //removed old
         ." AND trans.tran_date>='$fromdate'" // added this
        ." AND trans.tran_date<='$todate'";     //added this        

    if ($currency !== false)
        $sql .= " AND cust.curr_code=".db_escape($currency);

    $sql .= " ORDER BY trans.tran_date, trans.$ref";

    return db_query($sql, "Cant retrieve invoice range");
}

// add QR Support mod
    $path_to_root="..";
    include_once($path_to_root . "/reporting/includes/phpqrcode/qrlib.php");

    $tempDir = $path_to_root ."/company/1/pdf_files/"; // <--NOTE must be your temp location
// end

    if (@$this->formData['payment_service'])    //payment link
    {
        $amt = number_format($this->formData["ov_freight"] + $this->formData["ov_gst"] + $this->formData["ov_amount"], user_price_dec());
        $service = $this->formData['payment_service'];
        $url = payment_link($service, array(
            'company_email' => $this->company['email'],
            'amount' => $amt,
            'currency' => $this->formData['curr_code'],
            'comment' => $this->title . " " . $this->formData['reference'],
            'invoice' => $this->formData['document_number']
            ));
        $Footer[_("You can pay through"). " $service: "] = "$url";
// QR Mod
        $tempname = tempnam($tempDir,'QRcode');
        QRcode::png($url, $tempname.'.png', QR_ECLEVEL_L, 3);
        $this->Image($tempname.'.png',486,670,100,100);
// End
    }