get_booking_list PHP Code Examples

Example #1

0

Show file

File: user.php Project: BGCX261/zishashop-svn-to-git

    $smarty->assign('tags_from', 'user');
    $smarty->display('user_clips.dwt');
} elseif ($action == 'act_del_tag') {
    include_once ROOT_PATH . 'includes/lib_clips.php';
    $tag_words = isset($_GET['tag_words']) ? trim($_GET['tag_words']) : '';
    delete_tag($tag_words, $user_id);
    ecs_header("Location: user.php?act=tag_list\n");
    exit;
} elseif ($action == 'booking_list') {
    include_once ROOT_PATH . 'includes/lib_clips.php';
    $page = isset($_REQUEST['page']) ? intval($_REQUEST['page']) : 1;
    /* 获取缺货登记的数量 */
    $sql = "SELECT COUNT(*) " . "FROM " . $ecs->table('booking_goods') . " AS bg, " . $ecs->table('goods') . " AS g " . "WHERE bg.goods_id = g.goods_id AND user_id = '{$user_id}'";
    $record_count = $db->getOne($sql);
    $pager = get_pager('user.php', array('act' => $action), $record_count, $page);
    $smarty->assign('booking_list', get_booking_list($user_id, $pager['size'], $pager['start']));
    $smarty->assign('pager', $pager);
    $smarty->display('user_clips.dwt');
} elseif ($action == 'add_booking') {
    include_once ROOT_PATH . 'includes/lib_clips.php';
    $goods_id = isset($_GET['id']) ? intval($_GET['id']) : 0;
    if ($goods_id == 0) {
        show_message($_LANG['no_goods_id'], $_LANG['back_page_up'], '', 'error');
    }
    $smarty->assign('info', get_goodsinfo($goods_id));
    $smarty->display('user_clips.dwt');
} elseif ($action == 'act_add_booking') {
    include_once ROOT_PATH . 'includes/lib_clips.php';
    $booking = array('goods_id' => isset($_POST['id']) ? intval($_POST['id']) : 0, 'goods_amount' => isset($_POST['number']) ? intval($_POST['number']) : 0, 'desc' => isset($_POST['desc']) ? trim($_POST['desc']) : '', 'linkman' => isset($_POST['linkman']) ? trim($_POST['linkman']) : '', 'email' => isset($_POST['email']) ? trim($_POST['email']) : '', 'tel' => isset($_POST['tel']) ? trim($_POST['tel']) : '', 'booking_id' => isset($_POST['rec_id']) ? intval($_POST['rec_id']) : 0);
    // 查看此商品是否已经登记过
    $rec_id = get_booking_rec($user_id, $booking['goods_id']);

Example #2

0

Show file

File: user9-9.php Project: moonlight-wang/feilun

function action_booking_list()
{
    $user = $GLOBALS['user'];
    $_CFG = $GLOBALS['_CFG'];
    $_LANG = $GLOBALS['_LANG'];
    $smarty = $GLOBALS['smarty'];
    $db = $GLOBALS['db'];
    $ecs = $GLOBALS['ecs'];
    $user_id = $GLOBALS['user_id'];
    include_once ROOT_PATH . 'includes/lib_clips.php';
    $page = isset($_REQUEST['page']) ? intval($_REQUEST['page']) : 1;
    /* 获取缺货登记的数量 */
    $sql = "SELECT COUNT(*) " . "FROM " . $ecs->table('booking_goods') . " AS bg, " . $ecs->table('goods') . " AS g " . "WHERE bg.goods_id = g.goods_id AND user_id = '{$user_id}'";
    $record_count = $db->getOne($sql);
    $pager = get_pager('user.php', array('act' => $action), $record_count, $page);
    $smarty->assign('booking_list', get_booking_list($user_id, $pager['size'], $pager['start']));
    $smarty->assign('pager', $pager);
    $smarty->display('user_clips.dwt');
}

Example #3

0

Show file

File: user.php Project: seanguo166/yinoos

function action_booking_list()
{
    $user = $GLOBALS['user'];
    $_CFG = $GLOBALS['_CFG'];
    $_LANG = $GLOBALS['_LANG'];
    $smarty = $GLOBALS['smarty'];
    $db = $GLOBALS['db'];
    $ecs = $GLOBALS['ecs'];
    $user_id = $_SESSION['user_id'];
    include_once ROOT_PATH . 'includes/lib_clips.php';
    $page = isset($_REQUEST['page']) ? intval($_REQUEST['page']) : 1;
    /* 获取缺货登记的数量 */
    $sql = "SELECT COUNT(*) " . "FROM " . $ecs->table('booking_goods') . " AS bg, " . $ecs->table('goods') . " AS g " . "WHERE bg.goods_id = g.goods_id AND user_id = '{$user_id}'";
    $record_count = $db->getOne($sql);
    $pager = get_pager('user.php', array('act' => $action), $record_count, $page);
    // jx 缺货信息添加商家名称和商品图片
    $booking = get_booking_list($user_id, $pager['size'], $pager['start']);
    foreach ($booking as $key => $value) {
        if ($value['supplier_id'] == 0) {
            $sql = "SELECT value FROM" . $ecs->table('shop_config') . "WHERE code='shop_name'";
            $booking[$key]['supplier_id'] = $value['supplier_id'];
            $booking[$key]['supplier_name'] = $db->getOne($sql);
        } else {
            $sql = "SELECT supplier_name FROM " . $ecs->table('supplier') . "WHERE supplier_id='" . $value['supplier_id'] . "'";
            $booking[$key]['supplier_id'] = $value['supplier_id'];
            $booking[$key]['supplier_name'] = $db->getOne($sql);
        }
    }
    $smarty->assign('booking_list', $booking);
    $smarty->assign('pager', $pager);
    $smarty->display('user_clips.dwt');
}

Example #4

0

Show file

File: user.php Project: blowfishJ/galaxyCode


	$page = isset($_REQUEST['page']) ? intval($_REQUEST['page']) : 1;
	$pay_status = PS_PAYED;

	/* 我的债券 */
	$sql = "SELECT count(*) " .
			"FROM " .$ecs->table('goods'). " AS g, " .
			$ecs->table('order_goods') . " AS o, " .$ecs->table('category') . " AS c " .
			"WHERE g.goods_id = o.goods_id AND c.cat_id = g.cat_id AND c.is_standalone = ".$catstatus." AND o.pay_status = ".$pay_status." AND o.user_id = '$user_id'";
	$record_count = $db->getOne($sql);

	$pager = get_pager('user.php', array('act' => $action), $record_count, $page);
	$smarty->assign('bid_list', get_booking_list($user_id, $pager['size'], $pager['start'], $catstatus, GD_INVING));
	$smarty->assign('recover_list', get_booking_list($user_id, $pager['size'], $pager['start'], $catstatus, GD_FULL));
	$smarty->assign('bond_list', get_booking_list($user_id, $pager['size'], $pager['start'], $catstatus, GD_OVER));
	$smarty->assign('pager',        $pager);
	$smarty->display('user_clips.dwt');
}

/* 我的贷款页面*/
elseif ($action == 'loan_list')
{
	$smarty->display('user_clips.dwt');
}

/* 添加缺货登记页面 */
elseif ($action == 'add_booking')
{
    include_once(ROOT_PATH . 'includes/lib_clips.php');

PHP get_booking_list Examples