$v) { if (!in_array($k, $ws_alipay_table_products)) { unset($_POST[$k]); //$metas[$k] = $v; update_metadata($wpdb->wsaliproductsmetatype, intval($_REQUEST['proid']), $k, $v); } } $wpdb->update($wpdb->wsaliproducts, $_POST, array('proid' => intval($_REQUEST['proid']))); } //----------------------------------------------------------------------- //insert //----------------------------------------------------------------------- if (empty($_POST) && empty($_GET['proid'])) { $wpdb->insert($wpdb->wsaliproducts, array('name' => '未命名')); //echo $wpdb->insert_id; $_GET['proid'] = $wpdb->insert_id; $wpdb->show_errors(); } //----------------------------------------------------------------------- //delete //----------------------------------------------------------------------- if (isset($_GET['action']) && $_GET['action'] == 'delete' && $_GET['proid']) { $_GET['proid'] = esc_sql($_GET['proid']); if (isset($_GET['sure'])) { $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->wsaliproducts} WHERE `proid`=%d;", $_GET['proid'])); return; } ?>
get_results("SELECT * FROM {$wpdb->wsaliproducts} WHERE `proid`={$_GET['proid']} LIMIT 1;", ARRAY_A); $meta = $wpdb->get_results( "SELECT `meta_key`,`meta_value` FROM {$wpdb->wsaliproductsmeta} WHERE `wsaliproducts_id`={$_GET['proid']};" ); foreach ($meta as $k => $item) { $data[0][$item->meta_key] = $item->meta_value; } //$data = array_merge($data,$meta); //print_r($data); if (isset($data[0])) { $data = $data[0]; } $data['buylink'] = get_bloginfo('url') . '/wp-content/plugins/alipay/includes/tpl.cart.php?proid=' . $data['proid']; if (!isset($data['autosrc'])) { $data['autosrc'] = ''; } $htmls = array( array('proid', '商品编号', 'type' => 'hidden'), array('name', '商品名称'), array( 'protype', '商品类型', 'type' => 'select', 'options' => array( 'CUSTOM' => '普通实物', 'VIRTUAL' => '普通虚拟', 'ADP' => '广告位', 'LINK' => '友情链接' ), 'attrs' => array('class' => 'ws_alipay_select_protype') ), array('price', '商品价格'), array('pricePerDay', '每日单价', 'type' => 'hidden', 'attrs' => array('class' => 'ws_alipay_multiPrice')), array('pricePerWeek', '每周单价', 'type' => 'hidden', 'attrs' => array('class' => 'ws_alipay_multiPrice')), array('pricePerMonth', '每月单价', 'type' => 'hidden', 'attrs' => array('class' => 'ws_alipay_multiPrice')), array('pricePerQuarter', '每季单价', 'type' => 'hidden', 'attrs' => array('class' => 'ws_alipay_multiPrice')), array('pricePerYear', '每年单价', 'type' => 'hidden', 'attrs' => array('class' => 'ws_alipay_multiPrice')), array('description', '商品描述'), array('weight', '商品净重(kg)'), array('snum', '已售数量', 'attrs' => array('readonly' => 'readonly')), array('num', '剩余数量'), array('images', '商品图片地址'), array('download', '下载链接'), array('zipcode', '解压密码'), array('tags', '商品标签(,)'), array( 'spfre', '买家承担运费', 'type' => 'select', 'options' => array(0 => '否', 1 => '是'), 'attrs' => array('class' => 'ws_alipay_select_spfre') ), array('freight', '运费价格', 'attrs' => array('class' => 'ws_alipay_select_spfre_rel')), array('location', '商品所在地'), array('atime', '商品添加日期', 'attrs' => array('readonly' => 'readonly')), array('btime', '商品上架时间'), array('etime', '商品下架时间'), array( 'promote', '开启促销', 'type' => 'select', 'options' => array(0 => '关闭', 1 => '开启'), 'attrs' => array('class' => 'ws_alipay_select_promote') ), array( 'protime', '开启每日促销', 'type' => 'select', 'options' => array(0 => '关闭', 1 => '开启'), 'attrs' => array('class' => 'ws_alipay_select_protime ws_alipay_select_promote_rel') ), array( 'probdate', '促销开始日期', 'attrs' => array('class' => 'ws_alipay_select_promote_rel ws_alipay_select_promote_rel') ), array( 'probtime', '促销开始时间', 'attrs' => array('class' => 'ws_alipay_select_protime_rel ws_alipay_select_promote_rel') ), array( 'proedate', '促销结束日期', 'attrs' => array('class' => 'ws_alipay_select_promote_rel ws_alipay_select_promote_rel') ), array( 'proetime', '促销结束时间', 'attrs' => array('class' => 'ws_alipay_select_protime_rel ws_alipay_select_promote_rel') ), array( 'discountb', '促销折扣', 'type' => 'select', 'options' => array(0 => '关闭', 1 => '开启'), 'attrs' => array('class' => 'ws_alipay_select_discountb ws_alipay_select_promote_rel') ), array( 'discount', '折扣比率', 'attrs' => array('class' => 'ws_alipay_select_discountb_rel ws_alipay_select_promote_rel') ), array('tplid', '模版选择'), array( 'autosend', '启用自动货源列表', 'type' => 'select', 'options' => array(0 => '关闭', 1 => '开启'), 'attrs' => array('class' => 'ws_alipay_select_autosend') ), array('autosep', '货源分隔符', 'attrs' => array('class' => 'ws_alipay_select_autosend_rel')), array( 'autosrc', 'html' => '