Search options

would you please explain more.
I want to post json object like below to insert an invoice:
{
        "customer_id":2,
        "order_date":"06/27/2018",
        "ref":"001/2018",
        "trans_type":"ST_SALESINVOICE",
        "items":[
            {"stock_id":103, "qty":5, "price":5555, "discount":0,"description":"no desc"}
            ]
}
I want to know how _parse_next function handle the next reference if there is no record in journal table with trans_type=ST_SALESINVOICE
When I post this object dbquery in references.inc 170+ does not respond:
$sql = "SELECT MAX(CAST(SUBSTR($ref_fld, ".(strlen($prefix)+1).",LENGTH($ref_fld)-".(strlen($postfix)+strlen($prefix)).") AS UNSIGNED))"
                ." FROM `$trans_table` tbl
                    LEFT JOIN ".TB_PREF."voided v ON tbl.`$tno_fld`=v.id AND v.type=$type"
                ." WHERE ISNULL(v.id)"
                .($type_fld ? " AND tbl.`$type_fld`=$type" : '')
                ." AND `$ref_fld` REGEXP ".db_escape('^'.preg_quote($prefix).'[0-9]*'.preg_quote($postfix).'$');
        $result = db_query($sql, 'cannot retrieve last reference');