public function getJson($input)
{
$table = 'order_detail as a';
$select = 'a.*';
$replace_field = [['old_name' => 'order_id', 'new_name' => 'a.order_id'], ['old_name' => 'quantity', 'new_name' => 'a.quantity'], ['old_name' => 'total_price', 'new_name' => 'a.total_price'], ['old_name' => 'total_weight', 'new_name' => 'a.total_weight']];
$param = ['input' => $input, 'select' => $select, 'table' => $table, 'replace_field' => $replace_field];
$lionade = new Lionade();
$data = $lionade->lionade_query($param, function ($data) {
return $data;
});
}
public function getJson($input)
{
$table = 'order as a';
$select = 'a.*';
$replace_field = [['old_name' => 'no_invoice', 'new_name' => 'a.no_invoice'], ['old_name' => 'progress', 'new_name' => 'a.progress'], ['old_name' => 'total_price', 'new_name' => 'a.total_price'], ['old_name' => 'order_name', 'new_name' => 'a.order_name'], ['old_name' => 'order_phone', 'new_name' => 'a.order_phone'], ['old_name' => 'order_address', 'new_name' => 'a.order_address'], ['old_name' => 'total_weight', 'new_name' => 'a.total_weight'], ['old_name' => 'discount_code', 'new_name' => 'a.discount_code'], ['old_name' => 'total_discount', 'new_name' => 'a.total_discount'], ['old_name' => 'shipping_price', 'new_name' => 'a.shipping_price']];
$param = ['input' => $input, 'select' => $select, 'table' => $table, 'replace_field' => $replace_field];
$lionade = new Lionade();
$data = $lionade->lionade_query($param, function ($data) {
return $data;
});
}
public function getJson($input)
{
$table = 'subcategory as a';
$select = 'a.*';
$replace_field = [['old_name' => 'subname', 'new_name' => 'a.subname'], ['old_name' => 'slug', 'new_name' => 'a.slug'], ['old_name' => 'properties', 'new_name' => 'a.properties'], ['old_name' => 'total_product', 'new_name' => 'a.total_product']];
$param = ['input' => $input, 'select' => $select, 'table' => $table, 'replace_field' => $replace_field];
$lionade = new Lionade();
$data = $lionade->lionade_query($param, function ($data) {
return $data;
});
}
public function getJson($input)
{
$table = 'option as a';
$select = 'a.*';
$replace_field = [['old_name' => 'meta_key', 'new_name' => 'a.meta_key'], ['old_name' => 'meta_value', 'new_name' => 'a.meta_value']];
$param = ['input' => $input, 'select' => $select, 'table' => $table, 'replace_field' => $replace_field];
$lionade = new Lionade();
$data = $lionade->lionade_query($param, function ($data) {
return $data;
});
}
public function getJson($input)
{
$table = 'payment_confirmation as a';
$select = 'a.*';
$replace_field = [['old_name' => 'no_invoice', 'new_name' => 'a.no_invoice'], ['old_name' => 'account_name', 'new_name' => 'a.account_name'], ['old_name' => 'bank_account', 'new_name' => 'a.bank_account'], ['old_name' => 'bank_name', 'new_name' => 'a.bank_name'], ['old_name' => 'admin_account', 'new_name' => 'a.admin_account'], ['old_name' => 'total_transfer', 'new_name' => 'a.total_transfer'], ['old_name' => 'transfer_date', 'new_name' => 'a.transfer_date']];
$param = ['input' => $input, 'select' => $select, 'table' => $table, 'replace_field' => $replace_field];
$lionade = new Lionade();
$data = $lionade->lionade_query($param, function ($data) {
return $data;
});
}
public function getJson($input)
{
$table = 'users as a';
$select = 'a.*';
$replace_field = [['old_name' => 'email', 'new_name' => 'a.email'], ['old_name' => 'first_name', 'new_name' => 'a.first_name'], ['old_name' => 'last_name', 'new_name' => 'a.last_name'], ['old_name' => 'phone', 'new_name' => 'a.phone'], ['old_name' => 'status', 'new_name' => 'a.status']];
$param = ['input' => $input, 'select' => $select, 'table' => $table, 'replace_field' => $replace_field];
$lionade = new Lionade();
$data = $lionade->lionade_query($param, function ($data) {
return $data;
});
}
public function getJson($input)
{
$table = 'product as a';
$select = 'a.*';
$replace_field = [['old_name' => 'name', 'new_name' => 'a.name'], ['old_name' => 'slug', 'new_name' => 'a.slug'], ['old_name' => 'desc', 'new_name' => 'a.desc'], ['old_name' => 'price', 'new_name' => 'a.price'], ['old_name' => 'quantity', 'new_name' => 'a.quantity'], ['old_name' => 'rating', 'new_name' => 'a.rating'], ['old_name' => 'sold', 'new_name' => 'a.sold'], ['old_name' => 'image', 'new_name' => 'a.image']];
$param = ['input' => $input, 'select' => $select, 'table' => $table, 'replace_field' => $replace_field];
$lionade = new Lionade();
$data = $lionade->lionade_query($param, function ($data) {
return $data;
});
}
