select '0000-00-00' as date, 'Opening Balance' as narration, (SELECT debit FROM `account_sub_journal` where id=1)as debit, (SELECT credit FROM `account_sub_journal` where id=1)as credit, '0' as transaction_entry_id,'0' as account_sub_journal_id UNION SELECT * FROM `ledgertransactions` where account_sub_journal_id = 1 and `date` BETWEEN '2014-04-01' and '2014-04-10' В настоящее время я делаю это как статическую функцию в модели. Я не мог изобразить это так, поскольку laravel говорит, что это не объект
public static function ledgerbook_to($account_id,$date){ $book = DB::select( DB::raw("SELECT '0000-00-00' AS DATE, 'Opening Balance' AS narration, (SELECT debit FROM `account_sub_journal` WHERE id =1) AS debit, (SELECT credit FROM `account_sub_journal` WHERE id = :account_id) AS credit, '0' AS transaction_entry_id, '0' AS account_sub_journal_id UNION SELECT * FROM `ledgertransactions` WHERE account_sub_journal_id =:account_id_t and `date` <= :date_to "), array( 'account_id' => $account_id,'account_id_t' => $account_id,'date_to' => $date)); return $book; }
Я мог бы объединить это, если хотя бы разрешить ниже запрос в красноречиве.
SELECT '0000-00-00' AS DATE, 'Opening Balance' AS narration, (SELECT debit FROM `account_sub_journal` WHERE id =1) AS debit, (SELECT credit FROM `account_sub_journal` WHERE id =1) AS credit, '0' AS transaction_entry_id, '0' AS account_sub_journal_id
Спасибо за Вашу поддержку