Atitit. Management of Registration module

Atitit. Management of Registration module

1 . 1. Statistical Registration Data 1

1 . 2. Storage 1

1 . 3. Registration 1

1 . 4. View Registration Data 3

1.1. Statistical Registration Data

Select COUNT (*) as nums from Wxb_order where good_id= ' 83467583 '

http://192.168.1.122:8080/wrmiservlet?iocx=nonex&searchtext=& $method = com.attilax.dataservice.dataservice.exe& $callback =page_load_callback& $mod =usermod& $view _store_path =com/attilax/order& $op =q& $TB =select%20count (*)%20as%20nums%20from%20wxb_order%20where%20good_id%3d% 2783467583%27& $tbtype =sq& $trigger 000=com.attilax.dataservice.meta_data_pars_from_txt_trigger&$ trigtime=after&order_id= $uuid &good_id=83467583&user_id= $uid & $fldAppFun =%7b%7d

1.2. Storage

Wxb_order

Author :: ★ (Attilax) >>>    nickname : old Wow's paw   (   full name:: ATTILAX AKBAR AL RAPANUI  Attilax   Baroque   Alpha   Rapa Nui   )   Kanji name: Ayron, Email:[email protected]

reprint Please indicate source: http://www.cnblogs.com/attilax/

1.3. Registration

-- ----------------------------

DROP TABLE IF EXISTS ' Wxb_order ';

CREATE TABLE ' Wxb_order ' (

' OID ' int (one) not NULL auto_increment COMMENT ' ID ',

' order_id ' varchar (+) DEFAULT NULL COMMENT ' order number ',

' buyer_phone ' varchar DEFAULT NULL COMMENT ' buyer phone ',

' good_id ' varchar DEFAULT NULL COMMENT ' product number ',

' Order_time ' datetime DEFAULT NULL COMMENT ' order time ',

' channel_id ' varchar DEFAULT NULL COMMENT ' channel number ',

' State ' int (ten) DEFAULT NULL COMMENT ' status ',

' Buy_num ' int (one) DEFAULT NULL COMMENT ' purchase quantity ',

' Province ' varchar (+) DEFAULT NULL COMMENT ' province ',

' City ' varchar (+) DEFAULT NULL COMMENT ' cities ',

' Area ' varchar (+) DEFAULT NULL COMMENT ' region ',

' BUYER_REAMRK ' varchar ($) DEFAULT NULL COMMENT ' message ',

' Pay_type ' int (one) DEFAULT NULL COMMENT ' payment method ',

' Buyer_name ' varchar (+) DEFAULT NULL COMMENT ' buyer name ',

' sku_id ' varchar DEFAULT NULL COMMENT ' selected package ',

' user_id ' varchar DEFAULT NULL COMMENT ' proxy user ',

' Address ' varchar (+) DEFAULT NULL COMMENT ' detailed address ',

' courier_id ' varchar (+) DEFAULT NULL COMMENT ' Express ticket ',

' Order_remark ' varchar DEFAULT NULL COMMENT ' memo information ',

' sender_type ' varchar DEFAULT NULL COMMENT ' courier company ',

' Order_type ' int (one) DEFAULT ' 0 ' COMMENT ' 0 normal order 1 generation customer record 2 Abnormal orders ',

' Admin_remark ' varchar ($) DEFAULT NULL COMMENT ' background notes ',

' operator ' varchar DEFAULT NULL COMMENT ' auditor ',

' Check_time ' datetime DEFAULT NULL COMMENT ' order audit time ',

' order_ip ' varchar (+) DEFAULT NULL COMMENT ' next single IP ',

' Update_time ' datetime DEFAULT NULL COMMENT ' last modified time ',

' Stat ' varchar (255) DEFAULT NULL,

' Accept ' int (one) DEFAULT NULL,

PRIMARY KEY (' oid '),

UNIQUE KEY ' oid ' (' oid ')

) Engine=innodb auto_increment=122 DEFAULT Charset=utf8;

-- ----------------------------

--Records of Wxb_order

-- ----------------------------

insert into ' Wxb_order ' VALUES (' 104 ', ' 28605202 ', ' 13433223322 ', ' 13878976 ', ' 2015-06-29 13:00:19 ', ', ' 7 ', ' 1 ', ' Jiangsu province Wuxi ', '

insert into ' Wxb_order ' VALUES (' 105 ', ' 59820182 ', ' 13824763294 ', ' 13878976 ', ' 2015-06-29 17:07:08 ', ', ' 1 ', ' 1 ', ' Tianjin ', ' got it.

INSERT into ' Wxb_order ' VALUES (' 106 ', ' AAA ', ' ', ' ', ' 0000-00-00 00:00:00 ', ' ', ' 0 ', ' 0 ', ' ', ' ', ' ', ' ', ' 0 ', ', ', ') , ', ', ', ', ', ' 0 ', ', ', ', ' 0000-00-00 00:00:00 ', ' ', ' 0000-00-00 00:00:00 ', null, NULL);

INSERT into ' Wxb_order ' VALUES (' 119 ', ' 0301_152839_177 ', null, ' sq ', null, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL , NULL, NULL, NULL, NULL, NULL, NULL, NULL, ' 0 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT into ' Wxb_order ' VALUES (' + ', ' 0301_152839_178 ', null, ' 83467577 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL , NULL, NULL, NULL, ' 63248302 ', NULL, NULL, NULL, NULL, ' 0 ', NULL, NULL, NULL, NULL, NULL, NULL, ' 0 ');

INSERT into ' Wxb_order ' VALUES (' 121 ', ' 0426_130833_046 ', ' 63248302 ', ' 83467577 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL , NULL, NULL, NULL, NULL, ' 63248302 ', NULL, NULL, NULL, NULL, ' 0 ', NULL, NULL, NULL, NULL, NULL, NULL, ' 1 ');

1.4. View Registration Data

Xxx

Atitit. Management of Registration module