generator-labelOndblclick example

 {labelOndblclick} RetrievalStatus=0;currentChoose='';hadEdit=1; $('#popup-wrapper').width(800).height(500).css({top: -350, left: -100, position:'absolute'}); $('#moralFrame').prop('src','input.jsp?input=addressList.txt&config=addressListConfig.txt&mode=CHOICE'); $('#clicker').click();{/labelOndblclick}



{suffixLabel}Mths{/suffixLabel}

dialog property properties

function xxfnOpenNormalDialog() {
if (hadEdit==1){
    $("#dialog-confirm").html("Are you sure ?");
    $("#dialog-confirm").dialog({
modal: true,
minHeight: 200,
minWidth: 300,
dialogClass: "no-close",
center: true,
my: "center",
at: "center",
of: window,
autoOpen:true,
resizable: false,
modal: true,
title: "Exit",
dialogClass: 'dlgfixed',
position: ['center','middle'],
      buttons: {
            "Yes": function () {
                $(this).dialog('close');
                callback(true);
            },
                "No": function () {
                $(this).dialog('close');
                callback(false);
            }
        }
    }).css("font-size", "15px") ;
}else{
parent.exitMoralBox();
}
}

generator-messageBox

function saveMessage(p_saveAction, p_messageBoxCaption,p_code){
p_code=p_code?p_code:'';
saveAction=p_saveAction; messageBoxCaption=p_messageBoxCaption;
messageBoxPopup();$('#moralFrame').prop('src','input.jsp?mode=MINPUT&input=message.txt&config=messageConfig.txt&submitEvent='+p_code);
}



$('#popup-wrapper').width('400').height('200').css({top: -350, left: -100, position:'absolute'});
$('#moralFrame').prop('src','messageBox.jsp?message=Confirm Exit ?&boxType=2');
$('#clicker').click();}

16 = X
32 = ?
48 = exclamation
64 = information

_messagebox('Not Authorized !!',0,16);

_messagebox('You have unsaved changes that will be lost.',2,32,'Are you sure to cancel ?');

foxpro-properties

curval() - returns field values directly from disk for a table or a remote data source.
curval() Return types : Character,currency , date, datetime, double,float,logical,numeric, or memo. The field values returned by curval() and oldval() can be compared to determine if another user on a network chaned the field values while the fields were being edited. curval() and oldval() can only return different values when optimistic row or table bufering is enabled. Optimistic row or table buffering is enabled with cursorsetprop().


height property - specifies the height of an object on the screen.

hide method - hides a form formset or toolbar by setting the value property to false(.f.)
controls on a hidden from are not accessible to the user but are still available and can be accessed in code. Although they are not visible, concotols, contained in an invisible. Form retain their own Vsible property setting.
When the Visible property of the formset is set to false(.f.) the user cannot see the forms it contains. Forms in a hidden formset are not accessible to the user, but are still available and can be accessed in code. The Hide method for  Formset does not set the visible propertyof the child forms, so when a form is contained in a formset, you must check the visible property settingof both the form and formset to determine if the form is visible.

icon property - specifies the icon displayed for a form at run time when the form is mimimized.

jquery-getjson example

function _ip(){
var r="";
    $.getJSON( "http://smart-ip.net/geoip-json?callback=?",
    function(data){r=data.host;})
    return r;
}

java-array-2d java-2d-array java 2d arraj java 2darraj java-2darraj

String aTableNames[] = TableNames.split(",");
String [] listFields,listLabels ;
String [] listRefresh ; //   _refreshv2()
String [] listFormats ; //   e.g. s,s,s,s
String [] listTables  ; // e.g. 0_361
String [][] alistTables  ; // e.g. 0_361
String [] sqlTableName  ; // e.g. po


String [][] alistTables  ;
alistTables  = new String[iTableCount][];
alistTables[i]=new String[10];
alistTables[i][0]="value1";
alistTables[i][1]="value2";

standard (aat Terms)

Analysis - Requriement Specification

Applications Software - payroll programs, stock control programs, a single aplications program is often called a job , a job can divided into task.

Asynchronous - Asynchronous mode of transmission refers to the process of encoding data in a continuous steam.

Batch Data - for the cake of convenience and to facilitate control routines, it is customary, particular with operations performce offline, to process source documents in batches. Bindery : A database of definitions for entities such as users, groups , and work groups. The bindery lets you design an organized and secure operating environment based on each entities requirements.  The bindery has three components. Objects - Physical or logical entities hava a names. Properties - characteries of each object.

Computer Bureaus - an organisation providing electronic data.

Control Programs - controls the way in whch hardware is used, usually at least two programs are within main storage. one is applications and the other is control program ..

Data encryption - scrambles all the data in the course of transmission and reassemble it at the receiving encl. Data collection : Data collection is the process of getting data in a form suitable for processing against master file.  Data Preparation : Transcription of data from the source document to a machine, sensible medium . Two kinds, original trnscription itself, verification process.

Design - system specification

Dumping - data copy out from database.

Duplex - transmission is possible is two directions simulataneously;

Executive or Supervision Programs - which are able to allow a number of applications programs to run concurrently and in sequence without the intervention of user.

Feasibleity Study -

Half duplex- transmission is possible in two direction but not at once;

Hit rates - the hit ratio refers to the number of records requiring amendment on a file compared to the total record population. High hit rate files are most effieniently processed bybatchmethods, have hit rate file are often processed by direct access methods.  initial study - job specification

management - terms of refeence

modem - encoder, decoder , digitial -pulses -digitial -analogue

Multiplexor - serveral terminal devices connected to a processor;

Object - an entity that is defined on the network and given access to the file server. Object types include uses, group , servers. Print servers, and archieve servers and are defined in the file server's bindery. Operating System - allow a number of programs to be run on the computer withut human intervention by an operator.  Polling - Polling is the name given to the means of controlling the multiple use of transmission lines. The comuter signals and terminal device in turn to ascertain whether they wish to transmit data. Rolling is resorted to when multiplexors are not available and each terminal device has its own independent line to the host computers.

Power - is the potential to influence others to act according to our wishes.

Property : A description feature of a bindery object such as : A password, account restriction, an account balance, an internet work address, a list of out clients.  Purging - is the process by which the entire contents of a tape or disk are erased. Once purged, the files can be used to hold fresh data.

Remote - job entry - this is a term of describe a computer configuration by which a computer user has access to a manframe located off his or her own permises.

Routers : Internetworks that adopt the packet-switching protocol often use routers to keep routing tables; answer queries, boadcat ouuting information, and deliver packets to their destinations. Each router constantly broadcasts its current status, updates other router's distance and location in its routing table, abd coose the most efficient rout whan a change of routing occurs in the internetwork (such as a file server going down, or a new network being added). Simplex - transmission is possible in one direction only.

Synchronous - Synchronous receiver expects certain bits to arrive at  repreat ermined intervals by means of interal clock pulses.

System Software - provide by the manufacturer this software will be programs which contribute to the control and performance of the computer system. Such programs are given the collective name system software. e.g. DBMS.

Terminals - input / output devices

Time-sharing - when multi-access interactive users are to use a system which gives each user both a fair share of processor time and conversational facilities. A clock is used to divided up processor time into 'time slices'. A typical time-slice lasts less than one hundredth of one second.

Translators - converts statements written in one language into statements in another language.

Uncertainty - is defined as the lack of information about future events that make their outcomes less predictable.

Updating - a master file amend

Linux install

make depend
make install

make uninstall

dom, dom-parent

function myFunction()
{
document.getElementById("myDIV").style.wordWrap = "break-word";
}


window.parent.$( "a" ).css( "display", "none" );
window.parent.$( "input" ).css( "display", "none" );
window.parent.$( ".oe_secondary_menu_section" ).css( "display", "none" );
window.open("timeOut.jsp","_self");

css-center

<div id="MessageButton" style="background:lightblue;margin-top:50px;  border-bottom:1px  lightgray solid; width:100%;">

<h1 style="font-size:1em;text-align:center;">Active History</h1>

</div>

erp-outstand

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)

generator-readonly

PROCESSING_MODE=S [config.txt]

formReadOnly=_lookup('SUPPLIER_INVOICE_HEADER.STATUS')::'A'  [config.txt]

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='test-name' order by id desc limit 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='';

td-same-width even overflow

.textEllipsis{
display:block;
text-overflow:ellipsis;
overflow: hidden;
white-space: nowrap;
}