707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
|
public function schema(string $target)
{
$db = DB::getInstance();
if ($target == 'membres') {
$tables = [
'membres' => $db->firstColumn('SELECT sql FROM sqlite_master WHERE type = \'table\' AND name = \'membres\';'),
'categories' => $db->firstColumn('SELECT sql FROM sqlite_master WHERE type = \'table\' AND name = \'users_categories\';'),
];
}
elseif ($target == 'compta') {
$tables = [
'acc_transactions' => $db->firstColumn('SELECT sql FROM sqlite_master WHERE type = \'table\' AND name = \'acc_transactions\';'),
'acc_transactions_lines' => $db->firstColumn('SELECT sql FROM sqlite_master WHERE type = \'table\' AND name = \'acc_transactions_lines\';'),
];
|
|
|
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
|
public function schema(string $target)
{
$db = DB::getInstance();
if ($target == 'membres') {
$tables = [
'membres' => $db->firstColumn('SELECT sql FROM sqlite_master WHERE type = \'table\' AND name = \'membres\';'),
'users_categories' => $db->firstColumn('SELECT sql FROM sqlite_master WHERE type = \'table\' AND name = \'users_categories\';'),
];
}
elseif ($target == 'compta') {
$tables = [
'acc_transactions' => $db->firstColumn('SELECT sql FROM sqlite_master WHERE type = \'table\' AND name = \'acc_transactions\';'),
'acc_transactions_lines' => $db->firstColumn('SELECT sql FROM sqlite_master WHERE type = \'table\' AND name = \'acc_transactions_lines\';'),
];
|