public function paginate($page, $per_page = 20, $where = '') { //$page = abs($page) - 1; $skip = ($page - 1) * $per_page; $sql = "SELECT * FROM `{$this->table}` {$where} LIMIT {$per_page} OFFSET {$skip}"; return db_get_all($sql); }
public function getAllByUserId($user_id) { $first_day_this_month = date("Y-m-d", strtotime('first day of this month')); $first_day_next_month = date("Y-m-d", strtotime('first day of next month')); $sql = "SELECT * FROM `{$this->table}`\n WHERE `user_id` = " . intval($user_id) . "\n AND `paid_day` >= '" . $first_day_this_month . "'\n AND `paid_day` < '" . $first_day_next_month . "'"; return db_get_all($sql); }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); $sessid = session_id(); $sql = 'SELECT c_member_id, nickname FROM c_member WHERE c_member_id <> ?'; $params = array($u); $members = db_get_all($sql, $params); $sql = 'SELECT c_member_id, nickname FROM c_member WHERE c_member_id = ?'; $params = array($u); $my_info = db_get_row($sql, $params); array_unshift($members, $my_info); $id = $requests['target_id']; $group = biz_getGroupData($id); if ($u != $group['admin_id']) { die('アクセスできません。'); } foreach ($members as $key => $value) { if (biz_isGroupMember($value['c_member_id'], $id)) { $members[$key]['joined'] = true; } else { $members[$key]['joined'] = false; } } $this->set('inc_navi', fetch_inc_navi('h')); $this->set("c_invite_list", $members); $this->set("group", $group); $this->set("c_member_id", $u); return 'success'; }
public function getBy($value, $field = null) { if ($field === null) { $field = $this->primary_key; } $sql = "SELECT `{$this->table}`.*,`posts`.`Title` FROM `{$this->table}`,`posts` WHERE `{$this->table}`.`{$field}` = " . esc($value) . " and `{$this->table}`.`{$field}`= `posts`.`post_id`"; $rows = db_get_all($sql); return isset($rows) ? $rows : false; }
public function check_true($value, $field = null) { if ($field === null) { $field = $this->primary_key; } $sql = "SELECT * FROM `{$this->table}` WHERE `{$field}` = '" . esc($value) . "' LIMIT 1"; $rows = db_get_all($sql); return isset($rows[0]) ? true : false; }
function db_get_one($sql, $_db = NULL) { $result = db_get_all($sql, MDB2_FETCHMODE_ASSOC, $_db); if (PEAR::isError($result) || count($result) == 0) { return NULL; } else { return $result[0]; } }
/** * c_admin_config から設定値を読み込み * ひとまず定数として定義 */ function db_load_config() { $sql = 'SELECT * FROM c_admin_config'; $configs = db_get_all($sql); foreach ($configs as $config) { if (!$this->is_allowed($config['name'])) { continue; } defined($config['name']) or define($config['name'], $config['value']); } }
public function getCartList($cart) { $str = ""; foreach ($cart as $c) { if ($c['book_id'] == end($cart)['book_id']) { $str .= $c['book_id']; } else { $str .= $c['book_id'] . ','; } } $sql = "SELECT id, name, image, price FROM books where id in (" . $str . ")"; return db_get_all($sql); }
function db_rss_list_c_rss_cache_list_date($c_member_id, $year, $month, $day = 0) { if ($day) { $s_date = date('Y-m-d H:i:s', mktime(0, 0, 0, $month, $day, $year)); $e_date = date('Y-m-d H:i:s', mktime(0, 0, 0, $month, $day + 1, $year)); } else { $s_date = date('Y-m-d H:i:s', mktime(0, 0, 0, $month, 1, $year)); $e_date = date('Y-m-d H:i:s', mktime(0, 0, 0, $month + 1, 1, $year)); } $sql = 'SELECT * FROM c_rss_cache WHERE c_member_id = ?' . ' AND r_datetime >= ? AND r_datetime < ?' . ' ORDER BY r_datetime DESC'; $params = array(intval($c_member_id), $s_date, $e_date); $lst = db_get_all($sql, $params); foreach ($lst as $key => $value) { $lst[$key]['c_member'] = db_member_c_member4c_member_id($value['c_member_id']); } return $lst; }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); $sessid = session_id(); $sql = 'SELECT c_member_id, nickname FROM c_member WHERE c_member_id <> ?'; $params = array(intval($u)); $members = db_get_all($sql, $params); $sql = 'SELECT c_member_id, nickname FROM c_member WHERE c_member_id = ?'; $params = array(intval($u)); $my_info = db_get_row($sql, $params); array_unshift($members, $my_info); $this->set('inc_navi', fetch_inc_navi('h')); $this->set("c_invite_list", $members); $this->set("c_member_id", $u); $member_list = unserialize($requests['memberlist']); $this->set("name", $requests['name']); $this->set("info", $requests['info']); $this->set("member_list", $member_list); return 'success'; }
function get_comment_data($input, $id) { //日記の場合 if ($input['data_type'] < 2) { $sql = 'SELECT c_diary_comment_id as id,c_member_id as uid,body as comment,r_datetime as date ' . ' FROM c_diary_comment' . ' WHERE c_diary_id = ?' . ' ORDER BY c_diary_comment_id'; //トピック/イベントの場合 } else { $sql = 'SELECT c_commu_topic_comment_id as id,c_member_id as uid,body as comment,r_datetime as date ' . ' FROM c_commu_topic_comment' . ' WHERE c_commu_topic_id = ? AND number > 0 ' . ' ORDER BY c_commu_topic_comment_id'; } $params = array(intval($id)); $data = db_get_all($sql, $params); return $data; }
public function getBillDetails($bill_id) { $sql = "SELECT * FROM bill_details WHERE bill_id=" . $bill_id; return db_get_all($sql); }
/** * 登録済み画像のファイルサイズを求める */ function get_image_size($category, $params, $handle) { // request $table = $params[0]; $filename = $params[1]; $c_member_id = $params[2]; // c_image 参照先 $image_dsn = array('main', 'image'); foreach ($image_dsn as $key => $dsn) { if (!isset($GLOBALS['_OPENPNE_DSN_LIST'][$dsn])) { continue; } $imagedb =& db_get_instance($dsn); // 取り出し $sql = 'SELECT '; if ($table != 'biz_shisetsu') { $sql .= $c_member_id . ' as c_member_id, '; } $sql .= $filename . ' as image_filename '; if ($table == 'c_member') { $sql .= ',r_date '; } elseif ($table != 'biz_group' && $table != 'biz_shisetsu') { $sql .= ',r_datetime '; } $sql .= 'FROM ' . $table; $sql .= ' WHERE ' . $filename . ' <> ""'; $sql .= ' AND ' . $filename . ' is not NULL'; $data_list = db_get_all($sql); $lines = 0; if ($data_list) { fwrite($handle, 'INSERT INTO c_image_size VALUES'); } foreach ($data_list as $data) { // get image size $sql = 'SELECT bin FROM c_image WHERE filename = ?'; $params = array($data['image_filename']); $c_image_list = $imagedb->get_all($sql, $params); foreach ($c_image_list as $c_image) { $filesize = strlen(base64_decode($c_image['bin'])); } $ins_data = ''; if ($lines) { $ins_data .= ','; } $ins_data .= '('; if ($GLOBALS['_OPENPNE_DSN_LIST']['main']['dsn']['phptype'] == 'pgsql') { $ins_data .= " nextval('c_image_size_c_image_size_id_seq')"; } else { $ins_data .= ' null'; } $ins_data .= ",'" . $data['image_filename'] . "'"; $ins_data .= ",'" . $data['c_member_id'] . "'"; $ins_data .= ",'" . $filesize . "'"; $ins_data .= ",'" . $category . "'"; if ($table == 'biz_group' || $table == 'biz_shisetsu') { $ins_data .= ",'" . db_now() . "'"; } elseif ($table == 'c_member') { $ins_data .= ",'" . $data['r_date'] . "'"; } else { $ins_data .= ",'" . $data['r_datetime'] . "'"; } $ins_data .= ')'; fwrite($handle, $ins_data); $lines++; } if ($lines) { fwrite($handle, ";\n"); } } }
public function checkUser($username) { $sql = "select * from `{$this->table}` where `user_name`='{$username}'"; return db_get_all($sql); }
function test_offair_rep_migration() { $status = $this->migr->setup('*****@*****.**'); $this->assertTrue($status == 3); // Migrate $status = $this->migr->migrate(); $this->assertTrue($status == 3); $users = $this->migr->get_users('*****@*****.**'); $u = $users[1]; $this->assertTrue($u['id'] == 131); $this->assertTrue($u['institution_id'] == 789); $this->assertTrue($u['telephone_number'] == '012345'); $this->assertTrue($u['offair_notifications'] == 255); // Rights are migrated $this->assertIdentical($this->migr->get_user_rights(131), array('offair_rep')); // Migration has also changed off-air order IDs $sql = 'SELECT * FROM Orders'; $orders = db_get_all($sql, DB_FETCHMODE_ASSOC, $this->migr->db); $this->assertTrue($orders[0]['off_air_rep_id'] == 131); $this->assertTrue($orders[1]['off_air_rep_id'] == 131); $this->assertTrue($orders[2]['off_air_rep_id'] == 999); }
public function getPost_byTagid($id) { $sql = "SELECT * FROM `{$this->table}` JOIN `post_tag` on `ID` = `post_id` where `tag_id`={$id}"; return db_get_all($sql); }
function _db_get($options) { $cache =& $this->cache; $_ = $options; $_name = $_['name']; $sql_name = _es($_name); if (empty($_name)) { return null; } $_where = $_['where']; $_limit = $_['limit']; // prepare where $where = []; foreach ($_where as $field => $value) { list($field, $value) = $this->_field_to_sql($field, $value); if (!$field) { return null; } if (isset($value)) { $values = (array) $value; foreach ($values as $i => $v) { if (!is_int($v) && !is_null($v)) { $values[$i] = "'{$v}'"; } } $where[] = $field . ' IN( ' . implode(', ', $values) . ' )'; } } $sql_where = ''; if (!empty($where)) { $sql_where = 'WHERE ' . implode(' AND ', $where); } // prepare limit $sql_limit = ''; if ($_limit > 0 && (is_string($_limit) || is_int($_limit))) { $sql_limit = 'LIMIT ' . $_limit; } // prepare sql $sql = sprintf('SELECT * FROM %s %s %s', db($sql_name), $sql_where, $sql_limit); $result = db_get_all($sql, '-1'); // var_dump( $sql, $result ); exit; return $result; }
public function getAllComment($id) { $sql = "SELECT * FROM comments WHERE blogs_id =" . $id; return db_get_all($sql); }
// require_once($CONF['path'] . 'modules/trilt/src/TriltQueryConverter.class.php'); $db_name = $argv[1]; //### FIXME: error handling db_init($CONF['db_user'], $CONF['db_pass'], $CONF['db_server'], $db_name, FALSE); // Dummy classes class ZueryList { } class Zuery { } // Single quotes in the old database are escaped with this string define('_UDB_ESCAPE', '&;!'); // $converter = new TriltQueryConverter(); $sql = "SELECT id,data FROM User"; $users = db_get_all($sql); foreach ($users as $user) { $id = $user[0]; xlog(3, "Converting user: {$id}"); // Insert default rights $sql = "INSERT INTO UserRight (user_id, right_id)\n SELECT {$id}, id FROM Rights WHERE name IN('" . join("', '", $CONF['default_user_rights']) . "')"; db_query($sql); // Convert data $userdata = $user[1]; // Avoid clashing with the new classes $userdata = str_ireplace('"query', '"Zuery', $userdata); // Remove old escape hack $userdata = str_replace(_UDB_ESCAPE, '\\', $userdata); $legacy_data = @unserialize($userdata); if ($legacy_data === FALSE) { xlog(3, "No data: {$id}");
/** */ function view_order() { $_GET['id'] = intval($_GET['id']); if ($_GET['id']) { if ($this->SUPPLIER_ID) { $sql = 'SELECT o.* FROM ' . db('shop_orders') . ' AS o INNER JOIN ' . db('shop_order_items') . ' AS i ON i.order_id = o.id INNER JOIN ' . db('shop_products') . ' AS p ON i.product_id = p.id INNER JOIN ' . db('shop_admin_to_supplier') . ' AS m ON m.supplier_id = p.supplier_id WHERE o.id=' . intval($_GET['id']) . ' AND m.admin_id=' . intval(main()->ADMIN_ID) . ' GROUP BY o.id'; } else { $sql = 'SELECT * FROM ' . db('shop_orders') . ' WHERE id=' . intval($_GET['id']); } $order_info = db()->query_fetch($sql); } if (empty($order_info)) { return _e('No such order'); } $recount_price = false; $_class_price = _class('_shop_price', 'modules/shop/'); $_class_units = _class('_shop_product_units', 'modules/shop/'); $_class_basket = _class('shop_basket', 'modules/shop/'); if (main()->is_post()) { module('manage_shop')->_product_check_first_revision('order', intval($_GET['id'])); $order_id = (int) $_GET['id']; foreach ($_POST as $k => $v) { if ($k == 'status_item') { foreach ($v as $k1 => $status) { list($product_id, $param_id) = explode('_', $k1); db()->UPDATE(db('shop_order_items'), ['status' => $status], ' order_id=' . $_GET['id'] . ' AND product_id=' . intval($product_id) . ' AND param_id=' . intval($param_id)); } } elseif ($k == 'delete') { foreach ($v as $k1 => $is_del) { list($product_id, $param_id) = explode('_', $k1); if ($is_del == 1) { db()->query('DELETE FROM ' . db('shop_order_items') . ' WHERE order_id=' . $_GET['id'] . ' AND product_id=' . intval($product_id) . ' AND param_id=' . intval($param_id)); } } $recount_price = true; } elseif ($k == 'qty') { foreach ($v as $k1 => $qty) { list($product_id, $param_id) = explode('_', $k1); if (intval($qty) == 0) { db()->query('DELETE FROM ' . db('shop_order_items') . ' WHERE order_id=' . $_GET['id'] . ' AND product_id=' . intval($product_id) . ' AND param_id=' . intval($param_id)); } else { db()->UPDATE(db('shop_order_items'), ['quantity' => intval($qty)], ' order_id=' . $_GET['id'] . ' AND product_id=' . intval($product_id) . ' AND param_id=' . intval($param_id)); } $recount_price = true; } } elseif ($k == 'unit') { foreach ($v as $k1 => $unit) { $unit = (int) $unit; list($product_id, $param_id) = explode('_', $k1); $product_id = (int) $product_id; $param_id = (int) $param_id; if ($unit > 0) { $units = $_class_units->get_by_product_ids($product_id); if (isset($units[$product_id][$unit])) { db()->UPDATE(db('shop_order_items'), ['unit' => $unit], ' order_id=' . $order_id . ' AND product_id=' . $product_id . ' AND param_id=' . $param_id); $products = db_get_all('SELECT * FROM ' . db('shop_products') . ' WHERE id = ' . $product_id); $product = $products[$product_id]; list($price) = $_class_price->markup_down($product['price'], $product_id); $item = ['price' => $price, 'unit' => $unit, 'units' => $units[$product_id]]; $price_one = $_class_basket->_get_price_one($item); $item = ['order_id' => $order_id, 'product_id' => $product_id, 'param_id' => $param_id]; $item_price = $item + ['price' => $price_one]; $this->_item_update_price_unit($item_price); $recount_price = true; } } } } elseif ($k == 'price_unit') { foreach ($v as $k1 => $price) { list($product_id, $param_id) = explode('_', $k1); $this->_item_update_price_unit(['price' => $price, 'order_id' => $order_id, 'product_id' => (int) $product_id, 'param_id' => (int) $param_id]); $recount_price = true; } } } $sql = []; foreach (['address', 'phone', 'address', 'house', 'apartment', 'floor', 'porch', 'intercom', 'delivery_price', 'status', 'region', 'discount', 'discount_add', 'delivery_type', 'delivery_id', 'delivery_location'] as $f) { if (isset($_POST[$f])) { $sql[$f] = $_POST[$f]; if ($f == 'delivery_price' && $_POST['delivery_price'] != $order_info['delivery_price']) { $sql['is_manual_delivery_price'] = 1; $order_info['is_manual_delivery_price'] = 1; $order_info['delivery_price'] = $sql['delivery_price']; $recount_price = true; } if ($f == 'discount') { $discount = $_class_price->_number_mysql($sql['discount']); $order_info['discount'] = $discount; $sql['discount'] = $discount; $recount_price = true; } if ($f == 'discount_add') { $discount = $_class_price->_number_mysql($sql['discount_add']); $order_info['discount_add'] = $discount; $sql['discount_add'] = $discount; } if ($f == 'delivery_id') { $value = (int) $sql[$f]; $value = $value > 0 ? $value : $order_info[$f]; $sql[$f] = $value; } if ($f == 'delivery_type') { $value = (int) $sql[$f]; $order_info['payment'] = $value; $sql['payment'] = $value; } } } if (count($sql) > 0) { db()->update_safe(db('shop_orders'), $sql, 'id=' . intval($_GET['id'])); } if ($recount_price) { list($order_info['total_sum'], $order_info['delivery_price']) = $this->_order_recount_price($order_info['id'], $order_info); } module('manage_shop')->_order_add_revision('edit', intval($_GET['id'])); return js_redirect('./?object=' . main()->_get('object') . '&action=view_order&id=' . $order_info['id']); } $products_ids = []; $Q = db()->query('SELECT * FROM ' . db('shop_order_items') . ' WHERE `order_id`=' . intval($order_info['id'])); while ($_info = db()->fetch_assoc($Q)) { if ($_info['product_id']) { $products_ids[$_info['product_id']] = $_info['product_id']; } $order_items[$_info['product_id'] . "_" . $_info['param_id']] = $_info; } if (!empty($products_ids)) { $products_infos = db()->query_fetch_all('SELECT * FROM ' . db('shop_products') . ' WHERE id IN(' . implode(',', $products_ids) . ')'); $products_atts = module('manage_shop')->_get_products_attributes($products_ids); } $price_total = 0; foreach ((array) $order_items as $_info) { $_product = $products_infos[$_info['product_id']]; $_units = []; if (intval($_info['type']) == 1) { $images[0]['thumb'] = _class('_shop_products', 'modules/shop/')->_product_set_image($_info["product_id"], $_product['cat_id'], 'thumb', false); $link = './?object=' . main()->_get('object') . '&action=product_set_edit&id=' . $_info['product_id']; } else { $images = _class('_shop_products', 'modules/shop/')->_product_image($_info["product_id"], false, false); $link = './?object=' . main()->_get('object') . '&action=product_edit&id=' . $_info['product_id']; $_units = $_class_units->get_by_product_ids($_info['product_id']); } $image = $images[0]['thumb'] ?: _class('_shop_categories', 'modules/shop/')->get_icon_url($_product['cat_id'], 'item'); $dynamic_atts = []; if (strlen($_info['attributes']) > 3) { foreach ((array) unserialize($_info['attributes']) as $_attr_id) { $_attr_info = $products_atts[$_info['product_id']][$_attr_id]; $dynamic_atts[$_attr_id] = '- ' . $_attr_info['name'] . ' ' . $_attr_info['value']; $price += $_attr_info['price']; } } $product_id = (int) $_info['product_id']; $param_id = (int) $_info['param_id']; $price_one = tofloat($_info['price']); $quantity = (int) $_info['quantity']; $price_item = $price_one * $quantity; // product unit $unit = (int) $_info['unit']; $units = null; $unit_name = 'шт.'; if ($_units[$product_id]) { $units = $_units[$product_id]; $units[$unit] && ($unit_name = $units[$unit]['title']); } $products[$_info['product_id'] . '_' . $_info['param_id']] = ['product_id' => intval($_info['product_id']), 'param_id' => intval($_info['param_id']), 'param_name' => _class('_shop_product_params', 'modules/shop/')->_get_name_by_option_id($_info['param_id']), 'name' => _prepare_html($_product['name']), 'image' => $image, 'link' => $link, 'unit' => $unit, 'unit_name' => $unit_name, 'units' => $units, 'price_unit' => $price_one, 'price' => $price_item, 'currency' => _prepare_html(module('manage_shop')->CURRENCY), 'quantity' => intval($_info['quantity']), 'details_link' => process_url('./?object=' . main()->_get('object') . '&action=view&id=' . $_product['id']), 'dynamic_atts' => !empty($dynamic_atts) ? implode('<br />' . PHP_EOL, $dynamic_atts) : '', 'status' => module('manage_shop')->_box('status_item', $_info['status']), 'delete' => '']; $price_total += $price_item; } // discount $discount = $order_info['discount']; $discount_add = $order_info['discount_add']; $_discount = $discount; $discount_price = $_class_price->apply_price($price_total, $_discount); $discount_price -= $price_total; $discount_price = $_class_price->_number_round($discount_price); $_discount = $discount_add; $discount_add_price = $_class_price->apply_price($price_total, $_discount); $discount_add_price -= $price_total; $total_price = tofloat($order_info['total_sum']); $replace = my_array_merge($replace, _prepare_html($order_info)); $replace = my_array_merge($replace, ['form_action' => './?object=' . main()->_get('object') . '&action=' . $_GET['action'] . '&id=' . $_GET['id'], 'order_id' => $order_info['id'], 'price_total_info' => module('manage_shop')->_format_price($price_total), 'discount' => $_class_price->_number_format($discount), 'discount_add' => $_class_price->_number_format($discount_add), 'discount_price_info' => $_class_price->_price_format($discount_price), 'discount_add_price_info' => $_class_price->_price_format($discount_add_price), 'delivery_info' => module('manage_shop')->_format_price($order_info['delivery_price']), 'total_sum' => module('manage_shop')->_format_price($total_price), 'user_link' => _profile_link($order_info['user_id']), 'user_name' => _display_name(user($order_info['user_id'])), 'error_message' => _e(), 'products' => (array) $products, 'total_price' => module('manage_shop')->_format_price($total_price), 'ship_type' => module('manage_shop')->_ship_types[$order_info['ship_type']], 'pay_type' => module('manage_shop')->_pay_types[$order_info['pay_type']], 'date' => $order_info['date'], 'status_box' => module('manage_shop')->_box('status', $order_info['status']), 'back_url' => './?object=' . main()->_get('object') . '&action=show_orders', 'print_url' => './?object=' . main()->_get('object') . '&action=show_print&id=' . $order_info['id'], 'payment' => common()->get_static_conf('payment_methods', $order_info['payment'])]); $link_invoice = './?object=manage_shop&action=invoice&id=' . $replace['id']; $link_invoice_add = $link_invoice . '&with_discount_add=y'; $link_pdf_invoice = $link_invoice . '&pdf=y'; $link_pdf_invoice_add = $link_invoice_add . '&pdf=y'; $region = _class('_shop_region', 'modules/shop/')->_get_list(); array_unshift($region, '- регион не выбран -'); $out = form2($replace, ['dd_mode' => 1, 'big_labels' => true])->info('id')->info('price_total_info', ['desc' => 'Сумма'])->row_start(['desc' => 'Скидка, %'])->number('discount', ['desc' => 'Скидка, %'])->info('discount_price_info')->link('Invoice', $link_invoice, ['title' => 'Накладная без учета добавочной скидки', 'icon' => 'fa fa-file-o', 'target' => '_blank'])->link('PDF', $link_pdf_invoice, ['title' => 'Накладная PDF без учета добавочной скидки', 'icon' => 'fa fa-file-text-o', 'target' => '_blank'])->row_end()->row_start(['desc' => 'Скидка добавочная, %'])->number('discount_add', ['desc' => 'Скидка добавочная, %'])->info('discount_add_price_info', ['desc' => ' '])->link(t('Invoice') . '+', $link_invoice_add, ['title' => 'Накладная с учетом добавочной скидки', 'icon' => 'fa fa-file-o', 'target' => '_blank'])->link(t('PDF') . '+', $link_pdf_invoice_add, ['title' => 'Накладная PDF с учетом добавочной скидки', 'icon' => 'fa fa-file-text-o', 'target' => '_blank'])->row_end()->info('delivery_info', ['desc' => 'Доставка'])->info('total_sum', '', ['desc' => 'Итоговая сумма', 'tip' => 'Итоговая сумма без учета добавочной скидки', 'no_escape' => 1])->info_date('date', ['format' => 'full'])->info('name')->email('email')->info('phone')->container('<a href="./?object=' . main()->_get('object') . '&action=send_sms&phone=' . urlencode($replace["phone"]) . '" class="btn">Send SMS</a><br /><br />')->select_box('region', $region, ['desc' => 'Регион доставки', 'class_add_wrapper' => 'region_type_wrap'])->select_box('delivery_type', _class('_shop_delivery', 'modules/shop/')->_get_types(), ['desc' => 'Тип доставки', 'class_add_wrapper' => 'delivery_type_wrap'])->select_box('delivery_id', _class('_shop_delivery', 'modules/shop/')->_get_locations_by_type($replace['delivery_type']), ['class' => 'delivery_id', 'class_add_wrapper' => 'delivery_id_wrap', 'desc' => 'Отделение'])->text('delivery_location', 'Отделение доставки', ['class' => 'delivery_location', 'class_add_wrapper' => 'delivery_location_wrap'])->text('address')->text('house')->text('apartment')->text('floor')->text('porch')->text('intercom')->info('comment')->text('delivery_time')->price('delivery_price')->user_info('user_id')->info('payment', 'Payment method')->info('transaction_id', 'Transaction id')->container(table2($products)->image('product_id', ['width' => '50px', 'no_link' => true, 'web_path' => '', 'img_path_check' => false, 'img_path_callback' => function ($_p1, $_p2, $row) { return $row['image']; }])->func('link', function ($f, $p, $row) { $result = "<a class='btn' href='{$row[link]}'>{$row[product_id]}</a>"; return $result; })->func('name', function ($f, $p, $row) { $row['name'] = $row['name'] . ($row['param_name'] != '' ? "<br /><small>" . $row['param_name'] . "</small>" : ''); return $row['name']; })->func('unit', function ($f, $p, $row) { $values = []; if (!empty($row['units'])) { $values[0] = ' - '; foreach ($row['units'] as $id => $item) { $values[$id] = $item['title']; } } $desc = 'Ед. измерения'; $width = '7em'; $result = sprintf(' <style> .unit_current { width: %s; } </style> <div class="unit_current"> %s <span class="btn btn-mini unit_change"> <i class="icon-edit fa fa-edit"></i> </span> </div> ', $width, $row['unit_name']) . _class('html')->select2_box(['desc' => $desc, 'name' => 'unit[' . $row['product_id'] . '_' . $row['param_id'] . ']', 'values' => $values, 'js_options' => ['width' => $width, 'containerCssClass' => 'select2_box']]); return $result; })->func('quantity', function ($f, $p, $row) { $row['quantity'] = "<input type='text' name='qty[" . $row['product_id'] . "_" . $row['param_id'] . "]' value='" . intval($row['quantity']) . "' style='width:50px;'>"; return $row['quantity']; })->func('price_unit', function ($f, $p, $row) { $row['price_unit'] = "<input type='text' name='price_unit[" . $row['product_id'] . "_" . $row['param_id'] . "]' value='" . $row['price_unit'] . "' style='width:100px;'>"; return $row['price_unit']; })->text('price')->func('status', function ($f, $p, $row) { $row['status'] = str_replace("status_item", "status_item[" . $row['product_id'] . "_" . $row['param_id'] . "]", $row['status']); return $row['status']; })->func('delete', function ($f, $p, $row) { $row['delete'] = "<input type='checkbox' name='delete[" . $row['product_id'] . "_" . $row['param_id'] . "]' value='1'>"; return $row['delete']; }), ['wide' => 1])->container(tpl()->parse('manage_shop/product_search_order', ['order_id' => $_GET['id']]), 'Add product')->box('status_box', 'Status order', ['selected' => $order_info['status']])->save_and_back(); // misc handlers css(' .select2_box { display: none; } .unit_current { position : relative; } .btn.unit_change { display : none; position : absolute; right : 0; } '); jquery(' $(".delivery_id").on( "change", function( event ) { var location = $(this).find( "option:selected" ).text(); $(".delivery_location").val( location ); }); var delivery_type__on_change = function( target ) { var value = +$(target).find( "option:selected" ).val(); if( value == 1 ) { $(".delivery_id_wrap").hide(); $(".delivery_location_wrap").hide(); } else if( value == 2 ) { var count = +$(".delivery_id_wrap").find( "option" ).length; if( count > 1 ) { $(".delivery_id_wrap").show(); $(".delivery_location_wrap").show(); } } } delivery_type__on_change( $(".delivery_type_wrap") ); $(".delivery_type_wrap").on( "change", function( event ) { delivery_type__on_change( event.target ); }); $( ".unit_change" ).on( "click", function( event ) { var $this = $( this ); var $select2 = $this.parent().next(); $select2.toggle() }).each( function( i ) { var $this = $( this ); if( $this.parent().next().length ) { $this.show(); } }); '); // get similar orders $sql = "SELECT o.*, COUNT(*) AS num_items FROM `" . db('shop_orders') . "` AS `o`\n\t\t\t\tINNER JOIN " . db('shop_order_items') . " AS i ON i.order_id = o.id\n\t\t\t\tWHERE `o`.`id`!='" . $order_info['id'] . "'\n\t\t\t\t\tAND `o`.`phone`='" . $order_info['phone'] . "'\n\t\t\t\t\tAND `o`.`status`='" . $order_info['status'] . "'\n\t\t\t\tGROUP BY o.id ORDER BY o.id DESC"; $out .= "<br /><br /><h3>" . t('Similar orders') . "</h3>" . table($sql)->text('id')->date('date', ['format' => 'full', 'nowrap' => 1])->user('user_id')->text('name')->text('phone')->text('total_sum', ['nowrap' => 1])->text('num_items')->btn_edit('', './?object=' . main()->_get('object') . '&action=view_order&id=%d', ['no_ajax' => 1])->btn('Merge', './?object=' . main()->_get('object') . '&action=merge_order&id=' . $order_info['id'] . '&merge_id=%d', ['no_ajax' => 1]); // $out .= tpl()->parse('manage_shop/product_search',array()); return $out; }
/** * メンバーのプロフィール情報を取得する * * @param int $c_member_id メンバーID * @return array メンバープロフィール情報 */ function op_get_member_profile_list($c_member_id) { $sql = 'SELECT'; $sql .= ' cp.name,'; $sql .= ' cp.caption,'; $sql .= ' cp.form_type,'; $sql .= ' cm.value,'; $sql .= ' cm.public_flag'; $sql .= ' FROM c_member_profile as cm, c_profile as cp'; $sql .= ' WHERE cm.c_member_id = ?'; $sql .= ' AND cm.c_profile_id = cp.c_profile_id'; $sql .= ' ORDER BY cp.sort_order, cm.c_member_profile_id'; $params = array(intval($c_member_id)); return db_get_all($sql, $params); }
function db_schedule_c_member_list4mail() { $sql = 'SELECT * FROM c_schedule WHERE start_date = ? AND is_receive_mail = 1'; $params = array(date('Y-m-d')); return db_get_all($sql, $params); }
function getorder_byIdtran($id) { $sql = "SELECT o.*,p.name as name_product FROM `{$this->table}` o JOIN product p ON o.product_id=p.id WHERE transaction_id=" . $id; return db_get_all($sql); }
function get_product_index($order_by, $limit, $where = '') { $sql = "SELECT * FROM `{$this->table}`" . $where . " ORDER BY " . $order_by . " DESC LIMIT " . $limit; return db_get_all($sql); }
function news_index($order_by, $limit) { $sql = "SELECT * FROM `{$this->table}` ORDER BY " . $order_by . " DESC LIMIT " . $limit; return db_get_all($sql); }
public function getThree() { $sql = "SELECT * FROM `{$this->table}`\n WHERE `id` < 4"; return db_get_all($sql); }
/** * 受信メッセージの送信者リストを取得 */ function db_message_c_message_receiver_list4c_member_id($c_member_id) { $where = "c_member_id_from = ?" . " AND is_deleted_from = 0" . " AND is_send = 1"; if ($GLOBALS['_OPENPNE_DSN_LIST']['main']['dsn']['phptype'] == 'pgsql') { $sql = "SELECT c_member_id_to" . " FROM" . "(" . "SELECT distinct on(c_member_id_to) *" . " FROM" . " c_message" . " WHERE " . $where . ") as sub_member_tbl"; } else { $sql = "SELECT distinct c_member_id_to FROM c_message"; $sql .= " WHERE {$where}"; } $sql .= " ORDER BY r_datetime DESC"; $params = array(intval($c_member_id)); $c_message_list = db_get_all($sql, $params); foreach ($c_message_list as $key => $value) { $c_member = db_member_c_member4c_member_id_LIGHT($value['c_member_id_to']); $c_message_list[$key]['nickname'] = $c_member['nickname']; } return $c_message_list; }
function biz_getPostedTodo($id, $limit = null) { $sql = 'SELECT * FROM biz_todo WHERE writer_id = ? ORDER BY r_datetime DESC'; $params = array(intval($id)); if ($limit) { $tmp = db_get_all_limit($sql, 0, intval($limit), $params); } else { $tmp = db_get_all($sql, $params); } $list = array(); foreach ($tmp as $key => $value) { if (!biz_isPermissionTodo($id, $value['biz_todo_id'])) { continue; } $list[$key] = $value; $sql = 'SELECT nickname FROM c_member WHERE c_member_id = ?'; $params = array(intval($list[$key]['c_member_id'])); $list[$key]['member_name'] = db_get_one($sql, $params); } return $list; }
public function getCount() { $sql = "SELECT COUNT(*) as count FROM books"; $rows = db_get_all($sql); return isset($rows[0]) ? $rows[0]['count'] : false; }
public function getAllBycategory() { $sql = "SELECT * FROM `{$this->table}`\n WHERE `status` = 1 "; return db_get_all($sql); }