20140609
list product with vendor
search direct to edit
payment can adjustment
multi Admin
delete function
discount in (po)
20140604
textarea screen for input cannot update (done 20140611)
2 Company copy and pastes po so items.
required bold color blue (done)
Record Lock
Address input is so with rowcol 3 (done 20140528)
Address List in SO (done 20140528)
Address editing in SO (dblick) too long. (done)
Multi User Control
Test SO purchase product supplier information from product.supplier (done 20140527)
combo set to 99999 tableRead (done 20140527)
20140522
product choice can cancel (done 20140523)
line validation e.g. qty cannot be 0 (done 20140526)
timeout logout (done 20140522)
customer invoice create no messagebox (done)
supplier create no messagebox
uom (done)
allow cursor move in the field (done 20140522)
upload document (grn) (done 20140523)
upload supplier invoice (done 20140523)
20140520
formsize dynamic adjust. (done)
email note for not yet approve
20140519
cookie for login (done)
category can input by user (done,not yet announce)
product must click for the product in so (done)
upload document folders (done)
20140515
when Add user, set the default Active
After add user Refresh the menu3
Should show supplier in menu-ok
Customer when new cannot input
20140514
Admin Right
Creator rename to Requestor (done)
old
currency input (done 20140527)
control only chrome can use
discount for purchase order , invoice
who can edit the document
document can edit at 1 time
very old
stock danger list should have supplier name
finish product Doz & PCS
browse pcs, and dozen should have uom
list finish sum up the same kind.
invoice have uom
print envelope : accounts department
bom should have supplier a,b,c
input material stock, last 3 records in & out.
force close / Revoke
Feature
approved (approve, Revoke)
Audit log for active, remark
Multi text search (done)
It is my Computer Notes. Using Guide : object-key or object-key-key e.g. Step 1 Blog Search : [mysql-run] and then Step 2 ctrl+F [mysql-run] {bookMark me : Ctrl+D}
2014年5月15日 星期四
2014年5月13日 星期二
generator-readonly
PROCESSING_MODE=S [config.txt]
formReadOnly=_lookup('SUPPLIER_INVOICE_HEADER.STATUS')::'A' [config.txt]
2014年5月7日 星期三
css-example
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" | |
| "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> | |
| <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> | |
| <head> | |
| <meta http-equiv="content-type" content="text/html; charset=utf-8" /> | |
| <title></title> | |
| <style type="text/css" media="screen"> | |
| div { | |
| margin-bottom: 30px; | |
| } | |
| #divID #sitemap { | |
| font-size: 140%; | |
| font-weight: bold; | |
| color: #f63; | |
| } | |
| #divID #sitemap li ul { | |
| font-size: 90%; | |
| color: #000; | |
| } | |
| </style> | |
| </head> | |
| <body> | |
| <div id="divID"> | |
| <ul id="sitemap"> | |
| <li>This is a test. </li> | |
| <li> | |
| <ul> | |
| <li>This is a test. </li> | |
| <li>This is a test. | |
| <ul> | |
| <li>Part I</li> | |
| <li>Part II</li> | |
| </ul> | |
| </li> | |
| <li>This is a test. </li> | |
| </ul> | |
| </li> | |
| <li>This is a test. </li> | |
| </ul> | |
| </div> | |
| </body> | |
| </html> | |
mysql-update from another table recordno 20141103
SELECT DISTINCT ROW_NO,SALES_ORDER_INV_DESC.PARENT_RECORDID
FROM SALES_ORDER_INV_DESC
LEFT JOIN SALES_ORDER_HEAD ON SALES_ORDER_HEAD.RECORDID=SALES_ORDER_INV_DESC.PARENT_RECORDID
WHERE SALES_ORDER_HEAD.SUBJECT LIKE '%Search String%'AND SALES_ORDER_INV_DESC.ROW_NO=0;
+--------+-----------------+
| ROW_NO | PARENT_RECORDID |
+--------+-----------------+
| 0 | 1422930063870 |
+--------+-----------------+
SET @MTARGET:= 1422930063870;
SELECT ROW_NO,DESCRIPTION FROM SALES_ORDER_INV_DESC WHERE PARENT_RECORDID= @MTARGET ;
SET @rank:=0;
UPDATE SALES_ORDER_INV_DESC SET ROW_NO=@rank:=@rank+1 WHERE PARENT_RECORDID= @MTARGET AND ROW_NO=0;
SELECT ROW_NO,DESCRIPTION FROM SALES_ORDER_INV_DESC WHERE PARENT_RECORDID= @MTARGET;
DROP TABLE IF EXISTS DUMMYX;
CREATE TABLE DUMMYX SELECT RECORDID,CUS_SHORT_FORM FROM GRNBODY;
UPDATE SUPPLIER_INVOICE_LINE
INNER JOIN DUMMYX
ON DUMMYX.RECORDID=SUPPLIER_INVOICE_LINE.GRN_LINE_RECORDID
SET SUPPLIER_INVOICE_LINE.CUS_SHORT_FORM=DUMMYX.CUS_SHORT_FORM;
DROP TABLE DUMMYX;
select RECORDID FROM DNOTE_HEADER WHERE DNOTE_NO LIKE '%3278%';
SELECT RECORDID FROM DNOTE_LINE WHERE PARENT_RECORDID=1433748884403;
create table DNOTE_LINE_BAK_2 SELECT * FROM DNOTE_LINE;
update RECEIPT_LINE
INNER JOIN SALES_HEADER
ON SALES_HEADER.RECORDID=RECEIPT_LINE.INV_RECORDID
SET RECEIPT_LINE.SIGNED_INV=SALES_HEADER.SIGNED_INV;
UPDATE VENDOR_PRODUCT
INNER JOIN PRODUCT
ON PRODUCT.RECORDID=VENDOR_PRODUCT.PARENT_RECORDID
SET VENDOR_PRODUCT.VENDOR_PARTNO=PRODUCT.MODEL
WHERE VENDOR_PRODUCT.VENDOR_PARTNO='';
update GRN_LINE
INNER JOIN GRN_HEADER
ON GRN_HEADER.RECORDID=GRN_LINE.PARENT_RECORDID
SET GRN_LINE.CERT='N/A'
WHERE GRN_HEADER.STATUS='P';
UPDATE SALES_ORDER_HEAD
INNER JOIN TEMP
ON TEMP.RECORDID=SALES_ORDER_HEAD.RECORDID
SET SALES_ORDER_HEAD.TIMESTAMP=TEMP.TIMESTAMP;
UPDATE RECEIPT_HEADER
INNER JOIN RECEIPT_LINE
ON RECEIPT_LINE.PARENT_RECORDID=RECEIPT_HEADER.RECORDID
SET RECEIPT_HEADER.DESCRIPTION=RECEIPT_LINE.DESCRIPTION;
UPDATE SALES_ORDER_PO_DESC_BAK
SET TIMESTAMP=TIMESTAMP, PARENT_RECORDID=
(SELECT PARENT_RECORDID FROM SALES_ORDER_PO_DESC WHERE RECORDID=SALES_ORDER_PO_DESC_BAK.RECORDID;
UPDATE SALES_ORDER_INV_DESC_BAK
SET TIMESTAMP=TIMESTAMP, PARENT_RECORDID=
(SELECT PARENT_RECORDID FROM SALES_ORDER_PO_DESC WHERE RECORDID=SALES_ORDER_INV_DESC_BAK.RECORDID;
Updating entry WITHOUT updating timestamp
DROP TABLE DUMMY0;
CREATE TABLE DUMMY0 SELECT SOH_RECORDID, RECORDID FROM GRNLIST;
UPDATE GRN_HEADER SET TIMESTAMP=TIMESTAMP, SOH_RECORDID=(SELECT DISTINCT SOH_RECORDID FROM DUMMY0 WHERE DUMMY0.RECORDID=GRN_HEADER.RECORDID);
DROP TABLE DUMMY0;
SET @rank:=0;
UPDATE PRODUCT SET NO=@rank:=@rank+1;
update table set name='text name' where id = (select max(id) from table);
update table set field=(select max field)+1 from table) where id in (1,3,5,6,8);
UPDATE RECEIPT_HEADER
SET DESCRIPTION =
(SELECT DESCRIPTION
FROM RECEIPT_LINE
WHERE RECEIPT_LINE.PARENT_RECORDID = RECEIPT_HEADER.RECORDID
);
update from another table with MAX ***
UPDATE SALES_ORDER_HEAD
SET LAST_UPDATE_DATE =
(SELECT MAX(timestamp)
FROM MESSAGE_HEADER
WHERE MESSAGE_HEADER.PARENT_RECORDID = SALES_ORDER_HEAD.RECORDID
);
delimiter $$
update from another table
UPDATE SUPPLIER_INVOICE_LINE
INNER JOIN GRNQTYOS
ON GRNQTYOS.GRN_LINE_RECORDID=SUPPLIER_INVOICE_LINE.GRN_LINE_RECORDID
SET SUPPLIER_INVOICE_LINE.GRN_DDATE=GRNQTYOS.GRN_DDATE;
UPDATE RECEIPT_HEADER
SET DESCRIPTION =
(SELECT DESCRIPTION
FROM RECEIPT_LINE
WHERE RECEIPT_LINE.PARENT_RECORDID = RECEIPT_HEADER.RECORDID
);
UPDATE RECEIPT_LINE
INNER JOIN DUMMY0
ON DUMMY0.RECORDID=RECEIPT_LINE.INV_RECORDID
SET RECEIPT_LINE.DESCRIPTION=DUMMY0.DESCRIPTION;
UPDATE ADDRESS_BOOK
INNER JOIN VENDOR
ON VENDOR.NAME=ADDRESS_BOOK.COMPANY
SET ADDRESS_BOOK.PARENT_RECORDID = VENDOR.RECORDID;
UPDATE ADDRESS_BOOK
INNER JOIN CUSTOMER
ON CUSTOMER.NAME=ADDRESS_BOOK.COMPANY
SET ADDRESS_BOOK.PARENT_RECORDID = CUSTOMER.RECORDID;
UPDATE VENDOR_PRODUCT
INNER JOIN PRODUCT
ON PRODUCT.RECORDID=VENDOR_PRODUCT.PARENT_RECORDID
SET VENDOR_PRODUCT.VENDOR_PARTNO=PRODUCT.MODEL
WHERE VENDOR_PRODUCT.VENDOR_PARTNO='';
UPDATE PRODUCT
INNER JOIN SETTINGS
ON PRODUCT.MANUFACTURER=SETTINGS.DESCRIPTION
SET PRODUCT.MANUFACTURER = SETTINGS.RECORDID
update-recordno
UPDATE DNOTE_HEADER INNER JOIN DNOTE_LINE ON DNOTE_HEADER.RECORDID= DNOTE_LINE.PARENT_RECORDID
SET DNOTE_HEADER.CUSTOMER_NO = DNOTE_LINE.CUSTOMER_NO;
******************************************
* UPDATE PURCHASAE_HEADER.SQD_FILE
******************************************
select SQD_NO, SQD_FILE FROM SALES_ORDER_PO_DESC;
ALTER TABLE PURCHASE_HEADER ADD COLUMN DUMMY NVARCHAR(200) DEFAULT '';
UPDATE PURCHASE_HEADER
INNER JOIN SALES_ORDER_HEAD
ON SALES_ORDER_HEAD.SALES_ORDER=PURCHASE_HEADER.SALES_ORDER
SET PURCHASE_HEADER.DUMMY = SALES_ORDER_HEAD.RECORDID;
UPDATE PURCHASE_HEADER
INNER JOIN SALES_ORDER_PO_DESC
ON SALES_ORDER_PO_DESC.PARENT_RECORDID=PURCHASE_HEADER.DUMMY
SET PURCHASE_HEADER.SQD_FILE = SALES_ORDER_PO_DESC.SQD_FILE;
UPDATE PURCHASE_HEADER SET DUMMY='';
2014年5月2日 星期五
td-same-width even overflow
.textEllipsis{
display:block;
text-overflow:ellipsis;
overflow: hidden;
white-space: nowrap;
}
display:block;
text-overflow:ellipsis;
overflow: hidden;
white-space: nowrap;
}
2014年4月30日 星期三
generator-autocomplete
0.20,CUSTOMER.NAME,autocomplete,100%:380px:400px,400,[NAME],,{autoComplete}TABLE_NAME.FIELD_NAME{/autoComplete}{noDuplicate}
{object}
0.20,VENDOR.NAME,autocomplete,100%:380px:400px,400,Supplier,,
{autoComplete}VENDOR.NAME{/autoComplete}{noDuplicate}
{placeHolder}Full Supplier Name for Cheque Issue{/placeHolder}
{/object}
{object}
0.20,PRODUCT.MANUFACTURER,autocomplete,100%:380px:400px,400,Manufacturer ,,
{spaceLine}
{autoComplete}PRODUCT.MANUFACTURER{/autoComplete}
{onchange}
this.value=='N/A' ? _refreshv2('PRODUCT.MODEL','N/A'):_refreshv2('PRODUCT.MODEL','');
{/onchange}
{tooltips}Manufacturer{/tooltips}
{placeHolder}N/A for nouse{/placeHolder}
{/object}
{object}
0.22,PRODUCT.PRODUCT_LINE,autocomplete,100%:380px:400px,400,Product Line,,
{spaceLine}
{autoComplete}PRODUCT.PRODUCT_LINE{/autoComplete}
{tooltips}Manufacturer{/tooltips}
{placeHolder}N/A for nouse{/placeHolder}
{/object}
/**/
{object}
0.30,PRDTMSTR.MANUFACTURER,autocomplete,100%:380px:400px,400,Manufacturer ,,
{spaceLine}{draftMust}
{autoComplete}PRDTMSTR.MANUFACTURER{/autoComplete}
{onchange}
this.value=='N/A' ? _refreshv2('PRDTMSTR.MODEL','N/A'):_refreshv2('PRDTMSTR.MODEL','');
{/onchange}
{tooltips}e.g. Microsoft{/tooltips}
{placeHolder}N/A for Not Applicable{/placeHolder}
{ondblclick}
if(PROCESSING_MODE=='D'){
this.value='N/A';_refreshv2('PRDTMSTR.MODEL','N/A');
}
{/ondblclick}
{onblur}
this.value=='N/A' ? _refreshv2('PRDTMSTR.MODEL','N/A'):_refreshv2('PRDTMSTR.MODEL','');
{/onblur}
{/object}
{object}
0.20,VENDOR.NAME,autocomplete,100%:380px:400px,400,Supplier,,
{autoComplete}VENDOR.NAME{/autoComplete}{noDuplicate}
{placeHolder}Full Supplier Name for Cheque Issue{/placeHolder}
{/object}
{object}
0.20,PRODUCT.MANUFACTURER,autocomplete,100%:380px:400px,400,Manufacturer ,,
{spaceLine}
{autoComplete}PRODUCT.MANUFACTURER{/autoComplete}
{onchange}
this.value=='N/A' ? _refreshv2('PRODUCT.MODEL','N/A'):_refreshv2('PRODUCT.MODEL','');
{/onchange}
{tooltips}Manufacturer{/tooltips}
{placeHolder}N/A for nouse{/placeHolder}
{/object}
{object}
0.22,PRODUCT.PRODUCT_LINE,autocomplete,100%:380px:400px,400,Product Line,,
{spaceLine}
{autoComplete}PRODUCT.PRODUCT_LINE{/autoComplete}
{tooltips}Manufacturer{/tooltips}
{placeHolder}N/A for nouse{/placeHolder}
{/object}
/**/
{object}
0.30,PRDTMSTR.MANUFACTURER,autocomplete,100%:380px:400px,400,Manufacturer ,,
{spaceLine}{draftMust}
{autoComplete}PRDTMSTR.MANUFACTURER{/autoComplete}
{onchange}
this.value=='N/A' ? _refreshv2('PRDTMSTR.MODEL','N/A'):_refreshv2('PRDTMSTR.MODEL','');
{/onchange}
{tooltips}e.g. Microsoft{/tooltips}
{placeHolder}N/A for Not Applicable{/placeHolder}
{ondblclick}
if(PROCESSING_MODE=='D'){
this.value='N/A';_refreshv2('PRDTMSTR.MODEL','N/A');
}
{/ondblclick}
{onblur}
this.value=='N/A' ? _refreshv2('PRDTMSTR.MODEL','N/A'):_refreshv2('PRDTMSTR.MODEL','');
{/onblur}
{/object}
2014年4月29日 星期二
javascript-indexof
Example
Search an array for the item "Apple":
var fruits = ["Banana", "Orange", "Apple", "Mango"];
var a = fruits.indexOf("Apple");
var a = fruits.indexOf("Apple");
The result of a will be:
2
Meaning that "Apple" is located at position 2 in the array.
訂閱:
文章 (Atom)