I have the following script/query in Laravel,
$q = "SELECT COUNT(*) AS lembar, SUM(r.worth) AS jumlah
FROM receipts r
JOIN customers c ON c.id=r.customer_id
JOIN customer_types ct ON ct.code=c.customer_type_code
WHERE r.print_date BETWEEN ? and ? and c.kelurahan=? AND ct.code IN(?)";
$group = ['Q', 'R', 'S'];
$g = join('/', $group);
$g_in = join("','", $group);
$x = new \stdClass;
$x->group = $g;
$x->result = \DB::select(\DB::raw($q), [
$start_date,
$end_date,
$kel->kelurahan, // "KEBON PISANG"
$g_in
]);
the query works well in PgAdmin, but in Laravel it's return 0
, null
. also when $kel->kelurahan
change to something else it works on Laravel too.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire