Search options (Page 1 of 4)

function copy_link($row) 
{
    global $page_nested;

  return pager_link(_("Copy Order") ,
      "/sales/sales_order_entry.php?CopyOrder=". $row['order_no'], ICON_DOC); 
}

} elseif ($trans_type == ST_SALESORDER) {
     array_append($cols,array(
            _("Tmpl") => array('insert'=>true, 'fun'=>'tmpl_checkbox'),
                    array('insert'=>true, 'fun'=>'edit_link'),
                    array('insert'=>true, 'fun'=>'copy_link'),
                    array('insert'=>true, 'fun'=>'dispatch_link'),
                    array('insert'=>true, 'fun'=>'prt_link')));
};

    array(    'NewOrder' => 'SA_SALESORDER',
            'CopyOrder' => 'SA_SALESORDER',
            'ModifyOrderNumber' => 'SA_SALESORDER',
            'AddedID' => 'SA_SALESORDER',
            'UpdatedID' => 'SA_SALESORDER',
            'NewQuotation' => 'SA_SALESQUOTE',
            'ModifyQuotationNumber' => 'SA_SALESQUOTE',
            'NewQuoteToSalesOrder' => 'SA_SALESQUOTE',
            'AddedQU' => 'SA_SALESQUOTE',
            'UpdatedQU' => 'SA_SALESQUOTE',
            'NewDelivery' => 'SA_SALESDELIVERY',
            'AddedDN' => 'SA_SALESDELIVERY', 
            'NewInvoice' => 'SA_SALESINVOICE',
            'AddedDI' => 'SA_SALESINVOICE'
            )

function create_cart($type, $trans_no)
{ 
    global $Refs, $SysPrefs;

    if (!$SysPrefs->db_ok) // create_cart is called before page() where the check is done
        return;

    processing_start();

    if (isset($_GET['NewQuoteToSalesOrder']))
    {
        $trans_no = $_GET['NewQuoteToSalesOrder'];
        $doc = new Cart(ST_SALESQUOTE, $trans_no, true);
        $doc->Comments = _("Sales Quotation") . " # " . $trans_no;
        $_SESSION['Items'] = $doc;
    }    
  elseif(($type != ST_SALESORDER || isset($_GET['CopyOrder'])) && $type != ST_SALESQUOTE && $trans_no != 0) { // this is template

        $doc = new Cart(ST_SALESORDER, array($trans_no));
        $doc->trans_type = $type;
        $doc->trans_no = 0;
        $doc->document_date = new_doc_date();
        if ($type == ST_SALESINVOICE) {
            $doc->due_date = get_invoice_duedate($doc->payment, $doc->document_date);
            $doc->pos = get_sales_point(user_pos());
        } else
            $doc->due_date = $doc->document_date;
        $doc->reference = $Refs->get_next($doc->trans_type, null, array('date' => Today()));
        //$doc->Comments='';
        foreach($doc->line_items as $line_no => $line) {
            $doc->line_items[$line_no]->qty_done = 0;
        }
        $_SESSION['Items'] = $doc;
    } else
        $_SESSION['Items'] = new Cart($type, array($trans_no));
    copy_from_cart();
}

function get_customers_search($customer)
{
    global $SysPrefs;

    if (isset($SysPrefs->max_rows_in_search))
        $limit = $SysPrefs->max_rows_in_search;
    else
        $limit = 10;

  $sql = "SELECT d.debtor_no, d.name, d.debtor_ref, d.address, d.tax_id, 
    p.phone, p.phone2, p.fax, p.email 
    FROM ".TB_PREF."crm_persons p, ".TB_PREF."crm_contacts c,  
    ".TB_PREF."debtors_master d
    WHERE p.id = c.person_id AND c.entity_id = d.debtor_no AND 
          c.type = 'customer' AND
    (      d.name LIKE " . db_escape("%" . $customer. "%") . " OR 
     d.debtor_ref LIKE " . db_escape("%" . $customer. "%") . " OR 
          d.address LIKE " . db_escape("%" . $customer. "%") . " OR 
           d.tax_id LIKE " . db_escape("%" . $customer. "%")." OR
            p.phone LIKE " . db_escape("%" . $customer. "%") . " OR 
           p.phone2 LIKE " . db_escape("%" . $customer. "%") . " OR 
              p.fax LIKE " . db_escape("%" . $customer. "%") . " OR 
            p.email LIKE " . db_escape("%" . $customer. "%").")
      ORDER BY name LIMIT 0,".(int)($limit);

    return db_query($sql, "Failed in retreiving customer list.");
}

$th = array("", _("Customer"), _("Short Name"), _("Address"), _("Tax ID"), _("Phone"), _("Email"));

      label_cell($myrow["name"]);
      label_cell($myrow["debtor_ref"]);
      label_cell($myrow["address"]);
      label_cell($myrow["tax_id"]);
      label_cell($myrow["phone"]);
      label_cell($myrow["email"]);

        case ST_BANKPAYMENT : // it's a payment
            if (!exists_bank_trans($type, $type_no))
                return _('Selected transaction does not exists.');
                  $original_trans = db_fetch(get_bank_trans($type, $type_no));
                  $memo_ = $memo_."\nOriginal Amt: ".$original_trans['amount'];
            void_bank_trans($type, $type_no);
            break;

if (!isset($payment_services))
{
  $fa_url = "https://".$_SERVER['HTTP_HOST'].strtok($_SERVER['REQUEST_URI'], '?');
  $fa_url = str_replace('/reporting/reports_main.php', '', $fa_url );

  $payment_services = array(
    'PayPal' => "https://www.paypal.com/xclick?business=<company_email>&item_name=<comment>&amount<amount>&currency_code=<currency>",
    'StrikeOut' => $fa_url."/modules/strikeout/pay/?co=<company_no>&amount=<amount>&custId=<reference>",
    'XUMM XRP' => "https://xumm.app/detect/request:{{account}}?amount=<amount>"
  );
}

    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,
            'company_no' => user_company(),
            'document_number' => $this->formData['document_number'],
            'currency' => $this->formData['curr_code'],
            'trans_no' => $this->formData['trans_no'],
            'type' => $this->formData['type'],
            'tax_id' => $this->formData['tax_id'],
            'reference' => $this->formData['reference'],
            'comment' => $this->title . " " . $this->formData['reference']
            ));
    $Footer[_("You can pay through"). " $service: "] = "$url";

    if (file_exists("../modules/strikeout/pay/inc/phpqrcode/qrlib.php"))
    {
      include_once("../modules/strikeout/pay/inc/phpqrcode/qrlib.php"); 
        $tmp_file = company_path(). "/pdf_files/". random_id().".png";
        QRcode::png($url, $tmp_file, QR_ECLEVEL_L, 3);
        $this->Image($tmp_file,486,670,100,100);
    }
    }

        // quick entry made on account balance is special case.
        if ($qe['bal_type'] == 1) // if this is quick entry based on balance - calculate it
        {
            // Note, that this is ugly hack overriding standard field usage 
            // just to make the feature available between major FA releases!
            $gl_code = $qe['base_desc'];
            $monthly = $qe['base_amount'] == 1.0;

            if (!isset($date))
                $date = Today();

            if ($monthly) // marked as monthly
                $begin = begin_month($date);
            else
            {
                if (is_account_balancesheet($gl_code)) // total
                    $begin = "";
                else
                    $begin = begin_fiscalyear(); // from fiscalyear begin
            }
            $base = get_gl_trans_from_to($begin, $date, $gl_code);

        }

        if ($qid['bal_type'] == 1)
        {
            $accname = get_gl_account_name($qid['base_desc']);
            label_row(($qid['base_amount'] == 0 ? _("Yearly") : _("Monthly")) . " ". _("balance from account")." ".
                $qid['base_desc']." ".$accname."  ".submit('go', _("Go"), false, false, true),'', "colspan=2");
        }

    if ($bal_type == 1 && $_POST['type'] != QE_JOURNAL)
    {
        display_error( _("You can only use Balance Based together with Journal Entries."));
        set_focus('base_desc');
        return false;
    }

if (get_post('type') == QE_JOURNAL && get_post('bal_type') == 1)
{
    yesno_list_row(_("Period"), 'base_amount', null, _("Monthly"), _("Yearly"));
    gl_all_accounts_list_row(_("Account"), 'base_desc', null, true);
}