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);
}
