$label
EOD;
}
/*
if($ReadOnly==1){
$STR_HTML .= <<
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow=1;
$TheRow=1;
while($data=mysql_fetch_array($result) ){
$ID=$data[$PrinaryKey];
$Status=$data[$FieldsStatus];
$theAction=($Status=="" or $FieldsStatus =="" or $StatusColor=="") ? "#F4F4F4" : $StatusColor[$Status];//defind color
$theDefaultColor="#FFCCFF"; //pink
$thePointerColor="#FFCC99"; // red
$linkpage2=($ReadOnly==1) ? "top.location.href='$linkInfo?rowkey=edit&ID=$ID'" : "";
$FldColor=$data[$FieldsColor];
$FontColor=$ValueColor[$FldColor];
$STR_HTML .= <<
$data[RuningCount] " : "";
$xstr2=($PrinaryKey==$fields) ? " $xstr1$data[$fields]$xstr2
EOD;
}else{
$STR_HTML .= <<$data[$fields]
EOD;
}
}else{
$STR_HTML .= <<$data[$fields]
EOD;
}
}
/*
if($ReadOnly==1){
$strlink="$strlink
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow++;
$TheRow++;
}
$STR_HTML .= <<
EOD;
return $STR_HTML;
}
// **** ADDPAGE_TEMPLATE ****
function ADDPAGE_TEMPLATE_TESOLE($tbname,$JoinSQL,$showfields,$NumrowPerPage,$linkInfo,$PrinaryKey,$fldWhere,$fldOrderBy,$lableAdd,$ReadOnly){
global $search,$PageNo,$fldSearch,$SearchCon,$Keyword1,$Keyword2,$SearchSubmit, $showtitle,
$HiddenNew,$HiddenPrint,$PrintCode,$ColumnWidth,$FilterArray,$KeyFilter,$Filter,$DoDate1,$DoDate2,$showfields2,$sql_roc, $xgroupby,$showfields_total;
global $OrderByField,$FieldsStatus,$StatusColor,$SelectField,$FieldsColor,$ValueColor,$ofset;
echo $DoDate1.$DoDate2;
$action=substr(strrchr ($_SERVER['PHP_SELF'], "/"),1);
$backselfphp=$action;
$whrofset=($ofset <> "" ) ? "AND $PrinaryKey='$ofset' " : "";
$PageNo=($PageNo=="") ? 1 : $PageNo;
$Keyword1=str_replace("%27","'",$Keyword1);
$Keyword1=str_replace("\\'","'",$Keyword1);
$Keyword1=stripslashes($Keyword1);
$Keyword1=htmlspecialchars($Keyword1,ENT_NOQUOTES);
$Keyword1=htmlspecialchars($Keyword1,ENT_QUOTES);
$FilterWhr=="";
if($Filter <> "") $FilterWhr="AND $KeyFilter='$Filter' ";
if($search=="y"){
if($SearchCon==1) $xwhr=" AND $fldSearch LIKE '$Keyword1%' ";
if($SearchCon==2) $xwhr=" AND $fldSearch LIKE '%$Keyword1' ";
if($SearchCon==3) $xwhr=" AND $fldSearch LIKE '$Keyword1' ";
if($SearchCon==4) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
//if($SearchCon==5) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
$whr=str_replace("AND"," WHERE ",$xwhr);
//$whr=$xwhr;
$whr.="$fldWhere $whrofset $FilterWhr";
$xlink="&fldSearch=$fldSearch&SearchCon=$SearchCon&Keyword1=$Keyword1&Keyword2=$Keyword2&Filter=$Filter&DoDate1=$DoDate1&DoDate2=$DoDate2";
$xlink=str_replace("'","%27",$xlink);
//echo $xlink;
}else{
//$fldWhere=trim($fldWhere);
//$whr=str_replace("AND"," WHERE ",$fldWhere)." $whrofset";
//if($fldWhere == "" ) $whr=str_replace("AND"," WHERE ",$whrofset);
//echo $whrofset;
$whr=" WHERE $PrinaryKey LIKE '%' $fldWhere $whrofset $FilterWhr";
}
$sqlCommand=$sql_roc.$whr.$xgroupby;
//$sqlCommand="SELECT * FROM $tbname $whr";
//echo $sqlCommand;
$result=mysql_query($sqlCommand);
$TotalRow=mysql_num_rows($result);
//$TotalRow =20;
$TotalPage=ceil($TotalRow / $NumrowPerPage);
//echo $TotalPage;
$FirstRecord=(($PageNo-1) * $NumrowPerPage) + 1 ;
$LastRecord=($FirstRecord+$NumrowPerPage)-1;
$NextPage=($PageNo >= $TotalPage) ? $TotalPage : $PageNo+1;
$PrevPage=($PageNo == 1) ? 1 : $PageNo-1;
if($PageNo==1 AND $TotalPage > 1){
$STR_PAGE="
$label
EOD;
}
/*
if($ReadOnly==1){
$STR_HTML .= <<
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow=1;
$TheRow=1;
$xi=$FirstRecord ;
$i=1;
//echo "555";
$total1=$total2=$total3=0;
while($data=mysql_fetch_array($result)){
//echo "6666666";
$total1+=$data["quant"];
$total2+=$data["uprice"];
$total3+=$data["tprice"];
$ID=$data[$PrinaryKey];
$Status=$data[$FieldsStatus];
$theAction=($Status=="" or $FieldsStatus =="" or $StatusColor=="") ? "#F4F4F4" : $StatusColor[$Status];//defind color
$theDefaultColor="#FFCCFF"; //pink
$thePointerColor="#FFCC99"; // red
$linkpage2=($ReadOnly==1) ? "top.location.href='$linkInfo?rowkey=edit&ID=$ID'" : "";
$FldColor=$data[$FieldsColor];
$FontColor=$ValueColor[$FldColor];
$STR_HTML .= <<
$xi " : "";
$xstr2=($PrinaryKey==$fields) ? " $xstr1$data[$fields]$xstr2
EOD;
}else{
$STR_HTML .= <<$data[$fields]
EOD;
}
}else{
//,"quant"=>"ӹǹ","uprice"=>"Ҥҵ˹","tprice"=>"Ҥ
if(strstr($fields,"~")<>""){
$xdec=substr(strrchr ($fields, "~"),1);
$fields=substr($fields,0,strrpos ($fields, "~"));
$data[$fields]=($data[$fields]<>0) ? number_format($data[$fields],$xdec) : "";
}
$STR_HTML .= <<$data[$fields]
EOD;
}
}
/*
if($ReadOnly==1){
$strlink="$strlink
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow++;
$TheRow++;
$xi++;
$i++;
}
$total2=number_format($total2,2);
$total3=number_format($total3,2);
/*$STR_HTML .= <<
$total1
$total2
$total3
EOD;
*/
$STR_HTML .= <<
$label
EOD;
}
/*
if($ReadOnly==1){
$STR_HTML .= <<
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow=1;
$TheRow=1;
$xi=$FirstRecord ;
$i=1;
//echo "555";
$total1=$total2=$total3=0;
while($data=mysql_fetch_array($result)){
//echo "6666666";
$total1+=$data["quant"];
$total2+=$data["uprice"];
$total3+=$data["tprice"];
$ID=$data[$PrinaryKey];
$Status=$data[$FieldsStatus];
$theAction=($Status=="" or $FieldsStatus =="" or $StatusColor=="") ? "#F4F4F4" : $StatusColor[$Status];//defind color
$theDefaultColor="#FFCCFF"; //pink
$thePointerColor="#FFCC99"; // red
$linkpage2=($ReadOnly==1) ? "top.location.href='$linkInfo?rowkey=edit&ID=$ID'" : "";
$FldColor=$data[$FieldsColor];
$FontColor=$ValueColor[$FldColor];
$STR_HTML .= <<
$xi " : "";
$xstr2=($PrinaryKey==$fields) ? " $xstr1$data[$fields]$xstr2
EOD;
}else{
$STR_HTML .= <<$data[$fields]
EOD;
}
}else{
//,"quant"=>"ӹǹ","uprice"=>"Ҥҵ˹","tprice"=>"Ҥ
if(strstr($fields,"~")<>""){
$xdec=substr(strrchr ($fields, "~"),1);
$fields=substr($fields,0,strrpos ($fields, "~"));
$data[$fields]=($data[$fields]<>0) ? number_format($data[$fields],$xdec) : "";
}
$STR_HTML .= <<$data[$fields]
EOD;
}
}
/*
if($ReadOnly==1){
$strlink="$strlink
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow++;
$TheRow++;
$xi++;
$i++;
}
$total2=number_format($total2,2);
$total3=number_format($total3,2);
/*$STR_HTML .= <<
$total1
$total2
$total3
EOD;
*/
$STR_HTML .= <<
$label
EOD;
}
/*
if($ReadOnly==1){
$STR_HTML .= <<
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow=1;
$TheRow=1;
$xi=$FirstRecord ;
$i=1;
//echo "555";
$total1=$total2=$total3=0;
while($data=mysql_fetch_array($result)){
//echo "6666666";
$total1+=$data["quant"];
$total2+=$data["uprice"];
$total3+=$data["tprice"];
$ID=$data[$PrinaryKey];
$Status=$data[$FieldsStatus];
$theAction=($Status=="" or $FieldsStatus =="" or $StatusColor=="") ? "#F4F4F4" : $StatusColor[$Status];//defind color
$theDefaultColor="#E67A86"; //pink
$thePointerColor="#FFCC99"; // red
$linkpage2=($ReadOnly==1) ? "top.location.href='$linkInfo?rowkey=edit&ID=$ID'" : "";
$FldColor=$data[$FieldsColor];
$FontColor=$ValueColor[$FldColor];
$STR_HTML .= <<
$xi " : "";
$xstr2=($PrinaryKey==$fields) ? " $xstr1$data[$fields]$xstr2
EOD;
}else{
$STR_HTML .= <<$data[$fields]
EOD;
}
}else{
//,"quant"=>"ӹǹ","uprice"=>"Ҥҵ˹","tprice"=>"Ҥ
if(strstr($fields,"~")<>""){
$xdec=substr(strrchr ($fields, "~"),1);
$fields=substr($fields,0,strrpos ($fields, "~"));
$data[$fields]=($data[$fields]<>0) ? number_format($data[$fields],$xdec) : "";
}
$STR_HTML .= <<$data[$fields]
EOD;
}
}
/*
if($ReadOnly==1){
$strlink="$strlink
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow++;
$TheRow++;
$xi++;
$i++;
}
$total2=number_format($total2,2);
$total3=number_format($total3,2);
/*$STR_HTML .= <<
$total1
$total2
$total3
EOD;
*/
$STR_HTML .= <<
EOD;
return $STR_HTML;
}
//*****
//****pas
function ADDPAGE_TEMPLATE_NEWSAINOY_PAS($tbname,$JoinSQL,$showfields,$NumrowPerPage,$linkInfo,$PrinaryKey,$fldWhere,$fldOrderBy,$lableAdd,$ReadOnly){
global $search,$PageNo,$fldSearch,$SearchCon,$Keyword1,$Keyword2,$SearchSubmit, $showtitlem,$export_filename,$export_file_program,
$HiddenNew,$HiddenPrint,$PrintCode,$ColumnWidth,$FilterArray,$KeyFilter,$Filter,$DoDate1,$DoDate2,$showfields2,$sql_roc, $xgroupby,$showfields_total;
global $OrderByField,$FieldsStatus,$StatusColor,$SelectField,$FieldsColor,$ValueColor,$ofset,$total1,$total2,$filename ;
//echo $DoDate1.$DoDate2;
$action=substr(strrchr ($_SERVER['PHP_SELF'], "/"),1);
$backselfphp=$action;
$whrofset=($ofset <> "" ) ? "AND $PrinaryKey='$ofset' " : "";
$PageNo=($PageNo=="") ? 1 : $PageNo;
$Keyword1=str_replace("%27","'",$Keyword1);
$Keyword1=str_replace("\\'","'",$Keyword1);
$Keyword1=stripslashes($Keyword1);
$Keyword1=htmlspecialchars($Keyword1,ENT_NOQUOTES);
$Keyword1=htmlspecialchars($Keyword1,ENT_QUOTES);
$FilterWhr=="";
if($Filter <> "") $FilterWhr="AND $KeyFilter='$Filter' ";
if($search=="y"){
//if($SearchCon==1) $xwhr=" AND $fldSearch LIKE '$Keyword1%' ";
//if($SearchCon==2) $xwhr=" AND $fldSearch LIKE '%$Keyword1' ";
//if($SearchCon==3) $xwhr=" AND $fldSearch LIKE '$Keyword1' ";
//if($SearchCon==4) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
//if($SearchCon==5) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
$xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
$whr=str_replace("AND"," WHERE ",$xwhr);
//$whr=$xwhr;
$whr.="$fldWhere $whrofset $FilterWhr";
$xlink="&fldSearch=$fldSearch&SearchCon=$SearchCon&Keyword1=$Keyword1&Keyword2=$Keyword2&Filter=$Filter&DoDate1=$DoDate1&DoDate2=$DoDate2";
$xlink=str_replace("'","%27",$xlink);
//echo $xlink;
}else{
//$fldWhere=trim($fldWhere);
//$whr=str_replace("AND"," WHERE ",$fldWhere)." $whrofset";
//if($fldWhere == "" ) $whr=str_replace("AND"," WHERE ",$whrofset);
//echo $whrofset;
$whr=" WHERE $PrinaryKey LIKE '%' $fldWhere $whrofset $FilterWhr";
}
$sqlCommand=$sql_roc.$whr.$xgroupby;
//$sqlCommand="SELECT * FROM $tbname $whr";
//echo $sqlCommand;
$result=mysql_query($sqlCommand);
$TotalRow=mysql_num_rows($result);
//$TotalRow =20;
$TotalPage=ceil($TotalRow / $NumrowPerPage);
//echo $TotalPage;
$FirstRecord=(($PageNo-1) * $NumrowPerPage) + 1 ;
$LastRecord=($FirstRecord+$NumrowPerPage)-1;
$NextPage=($PageNo >= $TotalPage) ? $TotalPage : $PageNo+1;
$PrevPage=($PageNo == 1) ? 1 : $PageNo-1;
if($PageNo==1 AND $TotalPage > 1){
$STR_PAGE="
$label
EOD;
}
/*
if($ReadOnly==1){
$STR_HTML .= <<
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow=1;
$TheRow=1;
$xi=$FirstRecord ;
$i=1;
//echo "555";
$total1=$total2=$total3=0;
while($data=mysql_fetch_array($result)){
//echo "6666666";
$total1+=$data["quant"];
$total2+=$data["uprice"];
$total3+=$data["tprice"];
$ID=$data[$PrinaryKey];
$Status=$data[$FieldsStatus];
$theAction=($Status=="" or $FieldsStatus =="" or $StatusColor=="") ? "#F4F4F4" : $StatusColor[$Status];//defind color
$theDefaultColor="red"; //pink
$thePointerColor="#FFCC99"; // red
$linkpage2=($ReadOnly==1) ? "top.location.href='$linkInfo?rowkey=edit&ID=$ID'" : "";
$FldColor=$data[$FieldsColor];
$FontColor=$ValueColor[$FldColor];
$STR_HTML .= <<
$xi " : "";
$xstr2=($PrinaryKey==$fields) ? " $xstr1$data[$fields]$xstr2
EOD;
}else{
$STR_HTML .= <<$data[$fields]
EOD;
}
}else{
//,"quant"=>"ӹǹ","uprice"=>"Ҥҵ˹","tprice"=>"Ҥ
if(strstr($fields,"~")<>""){
$xdec=substr(strrchr ($fields, "~"),1);
$fields=substr($fields,0,strrpos ($fields, "~"));
$data[$fields]=($data[$fields]<>0) ? number_format($data[$fields],$xdec) : "";
}
$STR_HTML .= <<$data[$fields]
EOD;
}
}
/*
if($ReadOnly==1){
$strlink="$strlink
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow++;
$TheRow++;
$xi++;
$i++;
}
$total2=number_format($total2,2);
$total3=number_format($total3,2);
/*$STR_HTML .= <<
$total1
$total2
$total3
EOD;
*/
$STR_HTML .= <<
EOD;
return $STR_HTML;
}
//****
function ADDPAGE_TEMPLATE_NEWSAINOY($tbname,$JoinSQL,$showfields,$NumrowPerPage,$linkInfo,$PrinaryKey,$fldWhere,$fldOrderBy,$lableAdd,$ReadOnly){
global $search,$PageNo,$fldSearch,$SearchCon,$Keyword1,$Keyword2,$SearchSubmit, $showtitlem,$export_filename,$export_file_program,
$HiddenNew,$HiddenPrint,$PrintCode,$ColumnWidth,$FilterArray,$KeyFilter,$Filter,$DoDate1,$DoDate2,$showfields2,$sql_roc, $xgroupby,$showfields_total;
global $OrderByField,$FieldsStatus,$StatusColor,$SelectField,$FieldsColor,$ValueColor,$ofset,$total1,$total2,$filename ;
//echo $DoDate1.$DoDate2;
$action=substr(strrchr ($_SERVER['PHP_SELF'], "/"),1);
$backselfphp=$action;
$whrofset=($ofset <> "" ) ? "AND $PrinaryKey='$ofset' " : "";
$PageNo=($PageNo=="") ? 1 : $PageNo;
$Keyword1=str_replace("%27","'",$Keyword1);
$Keyword1=str_replace("\\'","'",$Keyword1);
$Keyword1=stripslashes($Keyword1);
$Keyword1=htmlspecialchars($Keyword1,ENT_NOQUOTES);
$Keyword1=htmlspecialchars($Keyword1,ENT_QUOTES);
$FilterWhr=="";
if($Filter <> "") $FilterWhr="AND $KeyFilter='$Filter' ";
if($search=="y"){
//if($SearchCon==1) $xwhr=" AND $fldSearch LIKE '$Keyword1%' ";
//if($SearchCon==2) $xwhr=" AND $fldSearch LIKE '%$Keyword1' ";
//if($SearchCon==3) $xwhr=" AND $fldSearch LIKE '$Keyword1' ";
//if($SearchCon==4) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
//if($SearchCon==5) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
$xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
$whr=str_replace("AND"," WHERE ",$xwhr);
//$whr=$xwhr;
$whr.="$fldWhere $whrofset $FilterWhr";
$xlink="&fldSearch=$fldSearch&SearchCon=$SearchCon&Keyword1=$Keyword1&Keyword2=$Keyword2&Filter=$Filter&DoDate1=$DoDate1&DoDate2=$DoDate2";
$xlink=str_replace("'","%27",$xlink);
//echo $xlink;
}else{
//$fldWhere=trim($fldWhere);
//$whr=str_replace("AND"," WHERE ",$fldWhere)." $whrofset";
//if($fldWhere == "" ) $whr=str_replace("AND"," WHERE ",$whrofset);
//echo $whrofset;
$whr=" WHERE $PrinaryKey LIKE '%' $fldWhere $whrofset $FilterWhr";
}
$sqlCommand=$sql_roc.$whr.$xgroupby;
//$sqlCommand="SELECT * FROM $tbname $whr";
//echo $sqlCommand;
$result=mysql_query($sqlCommand);
$TotalRow=mysql_num_rows($result);
//$TotalRow =20;
$TotalPage=ceil($TotalRow / $NumrowPerPage);
//echo $TotalPage;
$FirstRecord=(($PageNo-1) * $NumrowPerPage) + 1 ;
$LastRecord=($FirstRecord+$NumrowPerPage)-1;
$NextPage=($PageNo >= $TotalPage) ? $TotalPage : $PageNo+1;
$PrevPage=($PageNo == 1) ? 1 : $PageNo-1;
if($PageNo==1 AND $TotalPage > 1){
$STR_PAGE="
$label
EOD;
}
/*
if($ReadOnly==1){
$STR_HTML .= <<
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow=1;
$TheRow=1;
$xi=$FirstRecord ;
$i=1;
//echo "555";
$total1=$total2=$total3=0;
while($data=mysql_fetch_array($result)){
//echo "6666666";
$total1+=$data["quant"];
$total2+=$data["uprice"];
$total3+=$data["tprice"];
$ID=$data[$PrinaryKey];
$Status=$data[$FieldsStatus];
$theAction=($Status=="" or $FieldsStatus =="" or $StatusColor=="") ? "#F4F4F4" : $StatusColor[$Status];//defind color
$theDefaultColor="#B7D787"; //pink
$thePointerColor="#FFCC99"; // red
$linkpage2=($ReadOnly==1) ? "top.location.href='$linkInfo?rowkey=edit&ID=$ID'" : "";
$FldColor=$data[$FieldsColor];
$FontColor=$ValueColor[$FldColor];
$STR_HTML .= <<
$xi " : "";
$xstr2=($PrinaryKey==$fields) ? " $xstr1$data[$fields]$xstr2
EOD;
}else{
$STR_HTML .= <<$data[$fields]
EOD;
}
}else{
//,"quant"=>"ӹǹ","uprice"=>"Ҥҵ˹","tprice"=>"Ҥ
if(strstr($fields,"~")<>""){
$xdec=substr(strrchr ($fields, "~"),1);
$fields=substr($fields,0,strrpos ($fields, "~"));
$data[$fields]=($data[$fields]<>0) ? number_format($data[$fields],$xdec) : "";
}
$STR_HTML .= <<$data[$fields]
EOD;
}
}
/*
if($ReadOnly==1){
$strlink="$strlink
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow++;
$TheRow++;
$xi++;
$i++;
}
$total2=number_format($total2,2);
$total3=number_format($total3,2);
/*$STR_HTML .= <<
$total1
$total2
$total3
EOD;
*/
$STR_HTML .= <<
EOD;
return $STR_HTML;
}
function ADDPAGE_TEMPLATE_BACK_OS($tbname,$JoinSQL,$showfields,$NumrowPerPage,$linkInfo,$PrinaryKey,$fldWhere,$fldOrderBy,$lableAdd,$ReadOnly){
global $search,$PageNo,$fldSearch,$SearchCon,$Keyword1,$Keyword2,$SearchSubmit, $showtitlem,$export_filename,$export_file_program,
$HiddenNew,$HiddenPrint,$PrintCode,$ColumnWidth,$FilterArray,$KeyFilter,$Filter,$DoDate1,$DoDate2,$showfields2,$sql_roc, $xgroupby,$showfields_total,$PrinaryKey2,$PrinaryKey3,$tbname2,$company,$lang;
global $OrderByField,$FieldsStatus,$StatusColor,$SelectField,$FieldsColor,$ValueColor,$ofset,$total1,$total2,$filename,$button_search,$button_show ,$button_next_page;
//echo $DoDate1.$DoDate2;
$action=substr(strrchr ($_SERVER['PHP_SELF'], "/"),1);
$backselfphp=$action;
$whrofset=($ofset <> "" ) ? "AND $PrinaryKey='$ofset' " : "";
$PageNo=($PageNo=="") ? 1 : $PageNo;
$Keyword1=str_replace("%27","'",$Keyword1);
$Keyword1=str_replace("\\'","'",$Keyword1);
$Keyword1=stripslashes($Keyword1);
$Keyword1=htmlspecialchars($Keyword1,ENT_NOQUOTES);
$Keyword1=htmlspecialchars($Keyword1,ENT_QUOTES);
$FilterWhr=="";
if($Filter <> "") $FilterWhr="AND $KeyFilter='$Filter' ";
if($search=="y"){
//if($SearchCon==1) $xwhr=" AND $fldSearch LIKE '$Keyword1%' ";
//if($SearchCon==2) $xwhr=" AND $fldSearch LIKE '%$Keyword1' ";
//if($SearchCon==3) $xwhr=" AND $fldSearch LIKE '$Keyword1' ";
//if($SearchCon==4) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
//if($SearchCon==5) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
$xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
$whr=str_replace("AND"," WHERE ",$xwhr);
//$whr=$xwhr;
$whr.="$fldWhere $whrofset $FilterWhr";
$xlink="&company=$company&lang=$lang&fldSearch=$fldSearch&SearchCon=$SearchCon&Keyword1=$Keyword1&Keyword2=$Keyword2&Filter=$Filter&DoDate1=$DoDate1&DoDate2=$DoDate2";
$xlink=str_replace("'","%27",$xlink);
//echo $xlink;
}else{
//$fldWhere=trim($fldWhere);
//$whr=str_replace("AND"," WHERE ",$fldWhere)." $whrofset";
//if($fldWhere == "" ) $whr=str_replace("AND"," WHERE ",$whrofset);
//echo $whrofset;
$whr=" WHERE $PrinaryKey LIKE '%' $fldWhere $whrofset $FilterWhr";
}
$sqlCommand=$sql_roc.$whr.$xgroupby;
//$sqlCommand="SELECT * FROM $tbname $whr";
//echo $sqlCommand;
$result=mysql_query($sqlCommand);
$TotalRow=mysql_num_rows($result);
//$TotalRow =20;
$TotalPage=ceil($TotalRow / $NumrowPerPage);
//echo $TotalPage;
$FirstRecord=(($PageNo-1) * $NumrowPerPage) + 1 ;
$LastRecord=($FirstRecord+$NumrowPerPage)-1;
$NextPage=($PageNo >= $TotalPage) ? $TotalPage : $PageNo+1;
$PrevPage=($PageNo == 1) ? 1 : $PageNo-1;
if($PageNo==1 AND $TotalPage > 1){
$STR_PAGE="
$deslable
EOD;
}
/*
if($ReadOnly==1){
$STR_HTML .= <<
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow=1;
$TheRow=1;
$xi=$FirstRecord ;
$i=1;
//echo "555";
$total1=$total2=$total3=0;
while($data=mysql_fetch_array($result)){
//echo "6666666";
$total1+=$data["quant"];
$total2+=$data["uprice"];
$total3+=$data["tprice"];
//foreach($showfields as $fields => $label){
/// $widht=$ColumnWidth[$fields];
//}
$ID=$data[$PrinaryKey];
$ID2=$data[$PrinaryKey2];
$ID3=$data[$PrinaryKey3];
$Status=$data[$FieldsStatus];
$theAction=($Status=="" or $FieldsStatus =="" or $StatusColor=="") ? "#F4F4F4" : $StatusColor[$Status];//defind color
$theDefaultColor="#B7D787"; //pink
$thePointerColor="#FFCC99"; // red
//if($ID2<>"") $whid2=" and XID='$ID2'";
$linkpage2=($ReadOnly==1) ? "top.location.href='$linkInfo?rowkey=edit&ID=$ID&XID=$ID2&XXID=$ID3&lang=$lang&company=$company'" : "";
$FldColor=$data[$FieldsColor];
$FontColor=$ValueColor[$FldColor];
$STR_HTML .= <<
$xi
EOD;
foreach($showfields as $fields => $label){
//if($fields=="quant")$align="xright"; else $align="xleft";
//if($fields=="uprice")$align="xright"; else $align="xleft";
//if($fields=="tprice")$align="xright"; else $align="xleft";
//echo $fields;
//if($fields==$xfields)$align="xright"; else $align="xleft";
if($PrinaryKey==$fields) $ID=$data[$PrinaryKey];
if($fields==$FieldsColor or $ofset <> ""){
if($ofset <> ""){
$FontColor=($PrinaryKey==$fields) ? "red" : "";
$xstr1=($PrinaryKey==$fields) ? "" : "";
$xstr2=($PrinaryKey==$fields) ? " $xstr1$data[$fields]$xstr2
EOD;
}else{
$STR_HTML .= <<$data[$fields]
EOD;
}
}else{
//,"quant"=>"ӹǹ","uprice"=>"Ҥҵ˹","tprice"=>"Ҥ
if(strstr($fields,"~")<>""){
$xdec=substr(strrchr ($fields, "~"),1);
$fields=substr($fields,0,strrpos ($fields, "~"));
$data[$fields]=($data[$fields]<>0) ? number_format($data[$fields],$xdec) : "";
}
$STR_HTML .= << $data[$fields]
EOD;
}
}
/*
if($ReadOnly==1){
$strlink="$strlink
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow++;
$TheRow++;
$xi++;
$i++;
}
$total2=number_format($total2,2);
$total3=number_format($total3,2);
/*$STR_HTML .= <<
$total1
$total2
$total3
EOD;
*/
$STR_HTML .= <<
EOD;
return $STR_HTML;
}
function ADDPAGE_TEMPLATE_TESOLE_SAINOY($tbname,$JoinSQL,$showfields,$NumrowPerPage,$linkInfo,$PrinaryKey,$fldWhere,$fldOrderBy,$lableAdd,$ReadOnly){
global $search,$PageNo,$fldSearch,$SearchCon,$Keyword1,$Keyword2,$SearchSubmit, $showtitlem,$export_filename,$export_file_program,
$HiddenNew,$HiddenPrint,$PrintCode,$ColumnWidth,$FilterArray,$KeyFilter,$Filter,$DoDate1,$DoDate2,$showfields2,$sql_roc, $xgroupby,$showfields_total;
global $OrderByField,$FieldsStatus,$StatusColor,$SelectField,$FieldsColor,$ValueColor,$ofset,$total1,$total2,$filename ;
echo $DoDate1."".$DoDate2;
$action=substr(strrchr ($_SERVER['PHP_SELF'], "/"),1);
$backselfphp=$action;
$whrofset=($ofset <> "" ) ? "AND $PrinaryKey='$ofset' " : "";
$PageNo=($PageNo=="") ? 1 : $PageNo;
$Keyword1=str_replace("%27","'",$Keyword1);
$Keyword1=str_replace("\\'","'",$Keyword1);
$Keyword1=stripslashes($Keyword1);
$Keyword1=htmlspecialchars($Keyword1,ENT_NOQUOTES);
$Keyword1=htmlspecialchars($Keyword1,ENT_QUOTES);
$FilterWhr=="";
if($Filter <> "") $FilterWhr="AND $KeyFilter='$Filter' ";
if($search=="y"){
if($SearchCon==1) $xwhr=" AND $fldSearch LIKE '$Keyword1%' ";
if($SearchCon==2) $xwhr=" AND $fldSearch LIKE '%$Keyword1' ";
if($SearchCon==3) $xwhr=" AND $fldSearch LIKE '$Keyword1' ";
if($SearchCon==4) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
//if($SearchCon==5) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
$whr=str_replace("AND"," WHERE ",$xwhr);
//$whr=$xwhr;
$whr.="$fldWhere $whrofset $FilterWhr";
$xlink="&fldSearch=$fldSearch&SearchCon=$SearchCon&Keyword1=$Keyword1&Keyword2=$Keyword2&Filter=$Filter&DoDate1=$DoDate1&DoDate2=$DoDate2";
$xlink=str_replace("'","%27",$xlink);
//echo $xlink;
}else{
//$fldWhere=trim($fldWhere);
//$whr=str_replace("AND"," WHERE ",$fldWhere)." $whrofset";
//if($fldWhere == "" ) $whr=str_replace("AND"," WHERE ",$whrofset);
//echo $whrofset;
$whr=" WHERE $PrinaryKey LIKE '%' $fldWhere $whrofset $FilterWhr";
}
$sqlCommand=$sql_roc.$whr.$xgroupby;
//$sqlCommand="SELECT * FROM $tbname $whr";
echo $sqlCommand;
$result=mysql_query($sqlCommand);
$TotalRow=mysql_num_rows($result);
//$TotalRow =20;
$TotalPage=ceil($TotalRow / $NumrowPerPage);
//echo $TotalPage;
$FirstRecord=(($PageNo-1) * $NumrowPerPage) + 1 ;
$LastRecord=($FirstRecord+$NumrowPerPage)-1;
$NextPage=($PageNo >= $TotalPage) ? $TotalPage : $PageNo+1;
$PrevPage=($PageNo == 1) ? 1 : $PageNo-1;
if($PageNo==1 AND $TotalPage > 1){
$STR_PAGE="
$label
EOD;
}
/*
if($ReadOnly==1){
$STR_HTML .= <<
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow=1;
$TheRow=1;
$xi=$FirstRecord ;
$i=1;
//echo "555";
$total1=$total2=$total3=0;
while($data=mysql_fetch_array($result)){
//echo "6666666";
$total1+=$data["quant"];
$total2+=$data["uprice"];
$total3+=$data["tprice"];
$ID=$data[$PrinaryKey];
$Status=$data[$FieldsStatus];
$theAction=($Status=="" or $FieldsStatus =="" or $StatusColor=="") ? "#F4F4F4" : $StatusColor[$Status];//defind color
$theDefaultColor="#FFCCFF"; //pink
$thePointerColor="#FFCC99"; // red
$linkpage2=($ReadOnly==1) ? "top.location.href='$linkInfo?rowkey=edit&ID=$ID'" : "";
$FldColor=$data[$FieldsColor];
$FontColor=$ValueColor[$FldColor];
$STR_HTML .= <<
$xi " : "";
$xstr2=($PrinaryKey==$fields) ? " ""){
$xdec=substr(strrchr ($fields, "~"),1);
$fields=substr($fields,0,strrpos ($fields, "~"));
$data[$fields]=($data[$fields]<>0) ? number_format($data[$fields],$xdec) : "";
}
$STR_HTML .= <<$data[$fields]
EOD;
}
}
/*
if($ReadOnly==1){
$strlink="$strlink
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow++;
$TheRow++;
$xi++;
$i++;
}
$total2=number_format($total2,2);
$total3=number_format($total3,2);
/*$STR_HTML .= <<
$total1
$total2
$total3
EOD;
*/
$STR_HTML .= <<
$label
EOD;
}
/*
if($ReadOnly==1){
$STR_HTML .= <<
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow=1;
$TheRow=1;
while($data=mysql_fetch_array($result) ){
$ID=$data[$PrinaryKey];
$Status=$data[$FieldsStatus];
$theAction=($Status=="" or $FieldsStatus =="" or $StatusColor=="") ? "#F4F4F4" : $StatusColor[$Status];//defind color
$theDefaultColor="#FFCCFF"; //pink
$thePointerColor="#FFCC99"; // red
$linkpage2=($ReadOnly==1) ? "top.location.href='$linkInfo?rowkey=edit&ID=$ID'" : "";
$FldColor=$data[$FieldsColor];
$FontColor=$ValueColor[$FldColor];
$STR_HTML .= <<
$data[RuningCount] " : "";
$xstr2=($PrinaryKey==$fields) ? " $xstr1$data[$fields]$xstr2
EOD;
}else{
$STR_HTML .= <<$data[$fields]
EOD;
}
}else{
$align="left";
if(strstr($fields,"~")<>""){
$xdec=substr(strrchr ($fields, "~"),1);
$fields=substr($fields,0,strrpos ($fields, "~"));
$data[$fields]=($data[$fields]<>0) ? number_format($data[$fields],$xdec) : "";
$align="right";
}
$STR_HTML .= <<$data[$fields]
EOD;
}
}
/*
if($ReadOnly==1){
$strlink="$strlink
EOD;
}
*/
$STR_HTML .= <<
EOD;
$NumRow++;
$TheRow++;
}
$STR_HTML .= <<
";
for($y=$newyy+1;$y > $newyy-3;$y--){
if($y==$newyy){
$stryy.="$y";
}else{
$stryy.=" $y";
}
}
$stryy.=" ";
$whrofset=($ofset <> "" ) ? "AND $PrinaryKey='$ofset' " : "";
$xfld=($FieldsYY <> "") ? $FieldsYY : $PrinaryKey;
$PageNo=($PageNo=="") ? 1 : $PageNo;
$Keyword1=str_replace("%27","'",$Keyword1);
$Keyword1=str_replace("\\'","'",$Keyword1);
$Keyword1=stripslashes($Keyword1);
$Keyword1=htmlspecialchars($Keyword1,ENT_NOQUOTES);
$Keyword1=htmlspecialchars($Keyword1,ENT_QUOTES);
if($search=="y"){
if($SearchCon==1) $xwhr=" AND $fldSearch LIKE '$Keyword1%' ";
if($SearchCon==2) $xwhr=" AND $fldSearch LIKE '%$Keyword1' ";
if($SearchCon==3) $xwhr=" AND $fldSearch LIKE '$Keyword1' ";
if($SearchCon==4) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
if($SearchCon==5) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
$whr=str_replace("AND"," WHERE ",$xwhr);
$whr.=" AND $xfld LIKE '%$newyy%' $fldWhere $whrofset";
$xlink="&fldSearch=$fldSearch&SearchCon=$SearchCon&Keyword1=$Keyword1&Keyword2=$Keyword2";
$xlink=str_replace("'","%27",$xlink);
}else{
$whr=" WHERE $xfld LIKE '%$newyy%' $fldWhere $whrofset ";
}
$sqlCommand="SELECT * FROM $tbname $whr ";
//echo $sqlCommand;
$result=mysql_query($sqlCommand);
$TotalRow=mysql_num_rows($result);
$TotalPage=ceil($TotalRow / $NumrowPerPage);
// echo $TotalRow;
$FirstRecord=(($PageNo-1) * $NumrowPerPage) + 1 ;
$LastRecord=($FirstRecord+$NumrowPerPage)-1;
$NextPage=($PageNo >= $TotalPage) ? $TotalPage : $PageNo+1;
$PrevPage=($PageNo == 1) ? 1 : $PageNo-1;
if($PageNo==1 AND $TotalPage > 1){
$STR_PAGE="
$showtitle
$label
EOD;
}
/*
if($ReadOnly==1){
$STR_HTML .= <<
EOD;
}*/
$STR_HTML .= <<
EOD;
$NumRow=1;
$TheRow=1;
while($data=mysql_fetch_array($result) ){
$ID=$data[$PrinaryKey];
$Status=$data[$FieldsStatus];
$theAction=($Status=="" or $FieldsStatus =="" or $StatusColor=="") ? "#F4F4F4" : $StatusColor[$Status];//defind color
$theDefaultColor="#FFCCFF"; //pink
$thePointerColor="#FFCC99"; // red
$linkpage2=($ReadOnly==1) ? "top.location.href='$linkInfo?rowkey=edit&ID=$ID'" : "";
$FldColor=$data[$FieldsColor];
$FontColor=$ValueColor[$FldColor];
$STR_HTML .= <<
EOD;
$STR_HTML .= <<$data[RuningCount]
EOD;
foreach($showfields as $fields => $label){
if($PrinaryKey==$fields) $ID=$data[$PrinaryKey];
if($fields==$FieldsColor or $ofset <> ""){
if($ofset <> ""){
$FontColor=($PrinaryKey==$fields) ? "red" : "";
$xstr1=($PrinaryKey==$fields) ? "" : "";
$xstr2=($PrinaryKey==$fields) ? " $xstr1$data[$fields]$xstr2
EOD;
}else{
$STR_HTML .= <<$data[$fields]
EOD;
}
}else{
$align="left";
if(strstr($fields,"~")<>""){
$xdec=substr(strrchr ($fields, "~"),1);
$fields=substr($fields,0,strrpos ($fields, "~"));
$data[$fields]=($data[$fields]<>0) ? number_format($data[$fields],$xdec) : "";
$align="right";
}
$STR_HTML .= <<$data[$fields]
EOD;
}
}
/*if($ReadOnly==1){
$strlink="$strlink
EOD;
}*/
$STR_HTML .= <<
EOD;
$NumRow++;
$TheRow++;
}
$STR_HTML .= <<
EOD;
if($xdisplay==1){
$STR_HTML .= <<
open_select_media('../../','open_select_media.php') ;
EOD;
}
return $STR_HTML;
}
// **** ADDPAGE_TEMPLATE2 ****
function ADDPAGE_TEMPLATE2($tbname,$JoinSQL,$showfields,$NumrowPerPage,$linkInfo,$PrinaryKey,$fldWhere,$fldOrderBy,$lableAdd,$ReadOnly){
global $search,$PageNo,$fldSearch,$SearchCon,$Keyword1,$newyy,$newmm,$Keyword2,$PrintCode,
$SearchSubmit, $showtitle,$HiddenNew,$HiddenPrint,$PrintCode,$ColumnWidth;
global $OrderByField,$FieldsStatus,$StatusColor,$SelectField,$FieldsColor,$ValueColor,
$ofset,$ctrltime,$AutoRefresh,$DisplayPopUp,$FilterArray,$KeyFilter,$Filter;
$action=substr(strrchr ($_SERVER['PHP_SELF'], "/"),1);
$backselfphp=$action;
//echo $PrintCode;
//echo "ѡáѧ Class (ADDPAGE_TEMPLATE2) ";
if($newyy <> ""){
$_SESSION["newyyyy"]=$newyy;
}else{
if($_SESSION["newyyyy"]=="") $_SESSION["newyyyy"]=Date("Y");
}
$newyy=$_SESSION["newyyyy"];
if($newmm <> ""){
$_SESSION["newmmmm"]=$newmm;
}else{
if($_SESSION["newmmmm"]=="") $_SESSION["newmmmm"]=Date("m");
}
$newmm=$_SESSION["newmmmm"];
$yyyymm=$newyy.$newmm;
$stryy="";
for($y=$newyy+1;$y > $newyy-3;$y--){
if($y==$newyy){
$stryy.="$y";
}else{
$stryy.=" $y";
}
}
$stryy.=" ";
$strmm="";
for($m=1;$m<=12;$m++){
$xm=substr("0$m",-2);
if($xm==$newmm){
$strmm.="$xm";
}else{
$strmm.=" $xm";
}
}
$strmm.=" ";
$whrofset=($ofset <> "" ) ? "AND $PrinaryKey='$ofset' " : "";
$PageNo=($PageNo=="") ? 1 : $PageNo;
$FilterWhr=="";
if($Filter <> "") $FilterWhr="AND $KeyFilter='$Filter' ";
$Keyword1=str_replace("%27","'",$Keyword1);
$Keyword1=str_replace("\\'","'",$Keyword1);
$Keyword1=stripslashes($Keyword1);
$Keyword1=htmlspecialchars($Keyword1,ENT_NOQUOTES);
$Keyword1=htmlspecialchars($Keyword1,ENT_QUOTES);
if($search=="y"){
if($SearchCon==1) $xwhr=" AND $fldSearch LIKE '$Keyword1%' ";
if($SearchCon==2) $xwhr=" AND $fldSearch LIKE '%$Keyword1' ";
if($SearchCon==3) $xwhr=" AND $fldSearch LIKE '$Keyword1' ";
if($SearchCon==4) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
if($SearchCon==5) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
$whr=str_replace("AND"," WHERE ",$xwhr);
$whr.=" AND $PrinaryKey LIKE '%$newyy$newmm%' $fldWhere $whrofset $FilterWhr";
$xlink="&fldSearch=$fldSearch&SearchCon=$SearchCon&Keyword1=$Keyword1&Keyword2=$Keyword2&Filter=$Filter";
$xlink=str_replace("'","%27",$xlink);
}else{
$whr=" WHERE $PrinaryKey LIKE '%$newyy$newmm%' $fldWhere $whrofset";
}
$sqlCommand="SELECT * FROM $tbname $whr $FilterWhr ";
//echo $sqlCommand;
$result=mysql_query($sqlCommand);
$TotalRow=mysql_num_rows($result);
$TotalPage=ceil($TotalRow / $NumrowPerPage);
// echo $TotalRow;
$FirstRecord=(($PageNo-1) * $NumrowPerPage) + 1 ;
$LastRecord=($FirstRecord+$NumrowPerPage)-1;
$NextPage=($PageNo >= $TotalPage) ? $TotalPage : $PageNo+1;
$PrevPage=($PageNo == 1) ? 1 : $PageNo-1;
if($PageNo==1 AND $TotalPage > 1){
$STR_PAGE="
$showtitle
$label
EOD;
}
/*
if($ReadOnly==1){
$STR_HTML .= <<
EOD;
}*/
$STR_HTML .= <<
EOD;
$NumRow=1;
$TheRow=1;
while($data=mysql_fetch_array($result) ){
$ID=$data[$PrinaryKey];
$Status=$data[$FieldsStatus];
$theAction=($Status=="" or $FieldsStatus =="" or $StatusColor=="") ? "#F4F4F4" : $StatusColor[$Status];//defind color
$theDefaultColor="#FFCCFF"; //pink
$thePointerColor="#FFCC99"; // red
$linkpage2=($ReadOnly==1) ? "top.location.href='$linkInfo?rowkey=edit&ID=$ID'" : "";
$FldColor=$data[$FieldsColor];
$FontColor=$ValueColor[$FldColor];
$align="left";
$STR_HTML .= <<
EOD;
$STR_HTML .= <<$data[RuningCount]
EOD;
foreach($showfields as $fields => $label){
if($PrinaryKey==$fields) $ID=$data[$PrinaryKey];
if($fields==$FieldsColor or $ofset <> ""){
if($ofset <> ""){
$FontColor=($PrinaryKey==$fields) ? "red" : "";
$xstr1=($PrinaryKey==$fields) ? "" : "";
$xstr2=($PrinaryKey==$fields) ? " $xstr1$data[$fields]$xstr2
EOD;
}else{
$STR_HTML .= <<$data[$fields]
EOD;
}
}else{
$align="left";
if(strstr($fields,"~")<>""){
$xdec=substr(strrchr ($fields, "~"),1);
$fields=substr($fields,0,strrpos ($fields, "~"));
$data[$fields]=($data[$fields]<>0) ? number_format($data[$fields],$xdec) : "";
$align="right";
}
$STR_HTML .= <<$data[$fields]
EOD;
}
}
/*if($ReadOnly==1){
$strlink="$strlink
EOD;
}*/
$STR_HTML .= <<
EOD;
$NumRow++;
$TheRow++;
}
$STR_HTML .= <<
EOD;
if($xdisplay==1){
$STR_HTML .= <<
open_select_media('../../','open_select_media.php') ;
EOD;
}
return $STR_HTML;
}
function ADDPAGE_TEMPLATE3($tbname,$JoinSQL,$showfields,$NumrowPerPage,$linkInfo,$PrinaryKey,$fldWhere,$fldOrderBy,$lableAdd,$ReadOnly){
global $search,$PageNo,$fldSearch,$SearchCon,$Keyword1,$newyy,$newmm,$newdd,$Keyword2,
$SearchSubmit, $showtitle,$HiddenNew,$HiddenPrint,$PrintCode,$ColumnWidth,$PrinaryKey2;
global $OrderByField,$FieldsStatus,$StatusColor,$SelectField,$FieldsColor,$ValueColor,$DisplayPopUp,
$ofset,$ctrltime,$AutoRefresh,$XStatusArray,$XStatus,$Status;
$action=substr(strrchr ($_SERVER['PHP_SELF'], "/"),1);
$backselfphp=$action;
//echo $ctrltime;
if($newyy <> ""){
$_SESSION["newyyyy"]=$newyy;
}else{
if($_SESSION["newyyyy"]=="") $_SESSION["newyyyy"]=Date("Y");
}
$newyy=$_SESSION["newyyyy"];
if($newmm <> ""){
$_SESSION["newmmmm"]=$newmm;
}else{
if($_SESSION["newmmmm"]=="") $_SESSION["newmmmm"]=Date("m");
}
$newmm=$_SESSION["newmmmm"];
if($newdd <> ""){
$_SESSION["newdddd"]=$newdd;
}else{
if($_SESSION["newdddd"]=="") $_SESSION["newdddd"]=Date("d");
}
$newdd=$_SESSION["newdddd"];
$stryy="";
for($y=$newyy+1;$y > $newyy-3;$y--){
if($y==$newyy){
$stryy.="$y";
}else{
$stryy.=" $y";
}
}
$stryy.=" ";
$strmm="";
for($m=1;$m<=12;$m++){
$xm=substr("0$m",-2);
if($xm==$newmm){
$strmm.="$xm";
}else{
$strmm.=" $xm";
}
}
$strmm.=" ";
$days=get_dayinmonth("$newyy$newmm");
$strdd="";
for($d=1;$d<=$days;$d++){
$xd=substr("0$d",-2);
if($xd==$newdd){
$strdd.="$xd";
}else{
$strdd.=" $xd";
}
}
$strdd.=" ";
//$XStatusArray,$XStatus
if($XStatus==1){
$XStatus2="";
foreach($XStatusArray as $key=>$val){
if($key=="$Status"){
$XStatus2.="$val";
}else{
$XStatus2.=" $val";
}
//$XCategory.=" $val";
}
$XStatus2.=" ";
if($Status=="")$whr_Status="AND Status='10'";else $whr_Status="AND Status='$Status'";
}
$yymmdd=substr($newyy,-2)."$newmm$newdd";
$whrofset=($ofset <> "" ) ? "AND $PrinaryKey='$ofset' " : "";
$PageNo=($PageNo=="") ? 1 : $PageNo;
$Keyword1=str_replace("%27","'",$Keyword1);
$Keyword1=str_replace("\\'","'",$Keyword1);
$Keyword1=stripslashes($Keyword1);
$Keyword1=htmlspecialchars($Keyword1,ENT_NOQUOTES);
$Keyword1=htmlspecialchars($Keyword1,ENT_QUOTES);
if($search=="y"){
if($SearchCon==1) $xwhr=" AND $fldSearch LIKE '$Keyword1%' ";
if($SearchCon==2) $xwhr=" AND $fldSearch LIKE '%$Keyword1' ";
if($SearchCon==3) $xwhr=" AND $fldSearch LIKE '$Keyword1' ";
if($SearchCon==4) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
if($SearchCon==5) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
$whr=str_replace("AND"," WHERE ",$xwhr);
$whr.=" AND $PrinaryKey LIKE '%$yymmdd%' $whr_Status $fldWhere $whrofset";
$xlink="&fldSearch=$fldSearch&SearchCon=$SearchCon&Keyword1=$Keyword1&Keyword2=$Keyword2";
$xlink=str_replace("'","%27",$xlink);
}else{
$whr=" WHERE $PrinaryKey LIKE '%$yymmdd%' $whr_Status $fldWhere $whrofset";
}
$sqlCommand="SELECT * FROM $tbname $whr ";
//echo $sqlCommand;
$result=mysql_query($sqlCommand);
$TotalRow=mysql_num_rows($result);
$TotalPage=ceil($TotalRow / $NumrowPerPage);
// echo $TotalRow;
$FirstRecord=(($PageNo-1) * $NumrowPerPage) + 1 ;
$LastRecord=($FirstRecord+$NumrowPerPage)-1;
$NextPage=($PageNo >= $TotalPage) ? $TotalPage : $PageNo+1;
$PrevPage=($PageNo == 1) ? 1 : $PageNo-1;
if($PageNo==1 AND $TotalPage > 1){
$STR_PAGE="
$showtitle
$label
EOD;
}
/*
if($ReadOnly==1){
$STR_HTML .= <<
EOD;
}*/
$STR_HTML .= <<
EOD;
$NumRow=1;
$TheRow=1;
while($data=mysql_fetch_array($result) ){
$ID=$data[$PrinaryKey];
if($PrinaryKey2 <> ""){
$ID2=$data[$PrinaryKey2];
$ID.=":$ID2";
}
$Status=$data[$FieldsStatus];
$theAction=($Status=="" or $FieldsStatus =="" or $StatusColor=="") ? "#F4F4F4" : $StatusColor[$Status];//defind color
$theDefaultColor="#FFCCFF"; //pink
$thePointerColor="#FFCC99"; // red
$FldColor=$data[$FieldsColor];
$FontColor=$ValueColor[$FldColor];
$linkpage2=($ReadOnly==1) ? "top.location.href='$linkInfo?rowkey=edit&ID=$ID'" : "";
$STR_HTML .= <<
EOD;
$STR_HTML .= <<$data[RuningCount]
EOD;
foreach($showfields as $fields => $label){
if($PrinaryKey==$fields) $ID=$data[$PrinaryKey];
if($fields==$FieldsColor or $ofset <> ""){
if($ofset <> ""){
$FontColor=($PrinaryKey==$fields) ? "red" : "";
$xstr1=($PrinaryKey==$fields) ? "" : "";
$xstr2=($PrinaryKey==$fields) ? " $xstr1$data[$fields]$xstr2
EOD;
}else{
$STR_HTML .= <<$data[$fields]
EOD;
}
}else{
$STR_HTML .= <<$data[$fields]
EOD;
}
}
$STR_HTML .= <<
EOD;
$NumRow++;
$TheRow++;
}
$STR_HTML .= <<
EOD;
if($xdisplay==1){
$STR_HTML .= <<
open_select_media('../../','open_select_media.php') ;
EOD;
}
return $STR_HTML;
}
function ADDPAGE_TEMPLATE_SELECTCODE($tbname,$JoinSQL,$showfields,$NumrowPerPage,$PrinaryKey,$fldWhere){
global $search,$PageNo,$fldSearch,$SearchCon,$Keyword1,$Keyword2,$SearchSubmit,
$showtitle,$fldOrderBy;
$xargv=$_SERVER['argv'];
$action=substr(strrchr ($_SERVER['PHP_SELF'], "/"),1);
$action=$action."?".$xargv[0];
$bgcolor="#EEEEEE";
$PageNo=($PageNo=="") ? 1 : $PageNo;
$Keyword1=str_replace("%27","'",$Keyword1);
$Keyword1=str_replace("\\'","'",$Keyword1);
$Keyword1=stripslashes($Keyword1);
$Keyword1=htmlspecialchars($Keyword1,ENT_NOQUOTES);
$Keyword1=htmlspecialchars($Keyword1,ENT_QUOTES);
if($fldWhere <> ""){
$fldWhere=trim($fldWhere);
$fldWhere=str_replace("WHERE","AND",$fldWhere);
$fldWhere=str_replace("Where","AND",$fldWhere);
$fldWhere=str_replace("where","AND",$fldWhere);
$fldWhere=substr($fldWhere,4,strlen($fldWhere));
}
if($search=="y"){
if($SearchCon==1) $xwhr=" AND $fldSearch LIKE '$Keyword1%' ";
if($SearchCon==2) $xwhr=" AND $fldSearch LIKE '%$Keyword1' ";
if($SearchCon==3) $xwhr=" AND $fldSearch LIKE '$Keyword1' ";
if($SearchCon==4) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
if($SearchCon==5) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
if($fldWhere <> ""){
$whr .= "WHERE $fldWhere $xwhr ";
}else{
$xwhr=trim($xwhr);
$xwhr=substr($xwhr,4,strlen($xwhr));
$whr .= "WHERE $xwhr ";
}
$xlink="&fldSearch=$fldSearch&SearchCon=$SearchCon&Keyword1=$Keyword1&Keyword2=$Keyword2";
$xlink=str_replace("'","%27",$xlink);
}else{
if($fldWhere <> ""){
$whr .= "WHERE $fldWhere";
}
}
$sqlCommand="SELECT * FROM $tbname $whr";
echo $sqlCommand;
$result=mysql_query($sqlCommand);
$TotalRow=mysql_num_rows($result);
$TotalPage=ceil($TotalRow / $NumrowPerPage);
$FirstRecord=(($PageNo-1) * $NumrowPerPage) + 1 ;
$LastRecord=($FirstRecord+$NumrowPerPage)-1;
$NextPage=($PageNo >= $TotalPage) ? $TotalPage : $PageNo+1;
$PrevPage=($PageNo == 1) ? 1 : $PageNo-1;
if($PageNo==1 AND $TotalPage > 1){
$STR_PAGE="
";
for($y=$newyy+1;$y > $newyy-3;$y--){
if($y==$newyy){
$stryy.="$y";
}else{
$stryy.=" $y";
}
}
$stryy.=" ";
$strmm="";
for($m=1;$m<=12;$m++){
$xm=substr("0$m",-2);
if($xm==$newmm){
$strmm.="$xm";
}else{
$strmm.=" $xm";
}
}
$strmm.=" ";
$PageNo=($PageNo=="") ? 1 : $PageNo;
$Keyword1=str_replace("%27","'",$Keyword1);
$Keyword1=str_replace("\\'","'",$Keyword1);
$Keyword1=stripslashes($Keyword1);
$Keyword1=htmlspecialchars($Keyword1,ENT_NOQUOTES);
$Keyword1=htmlspecialchars($Keyword1,ENT_QUOTES);
if($fldWhere <> ""){
$fldWhere=trim($fldWhere);
$fldWhere=str_replace("WHERE","AND",$fldWhere);
$fldWhere=str_replace("Where","AND",$fldWhere);
$fldWhere=str_replace("where","AND",$fldWhere);
$fldWhere=substr($fldWhere,4,strlen($fldWhere));
}
if($search=="y"){
if($SearchCon==1) $xwhr=" AND $fldSearch LIKE '$Keyword1%' ";
if($SearchCon==2) $xwhr=" AND $fldSearch LIKE '%$Keyword1' ";
if($SearchCon==3) $xwhr=" AND $fldSearch LIKE '$Keyword1' ";
if($SearchCon==4) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
if($SearchCon==5) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
if($fldWhere <> ""){
$whr .= "WHERE $fldWhere $xwhr AND $PrinaryKey LIKE '%$newyy$newmm%' ";
}else{
$xwhr=trim($xwhr);
$xwhr=substr($xwhr,4,strlen($xwhr));
$whr .= "WHERE $xwhr AND $PrinaryKey LIKE '%$newyy$newmm%' ";
}
$xlink="&fldSearch=$fldSearch&SearchCon=$SearchCon&Keyword1=$Keyword1&Keyword2=$Keyword2";
$xlink=str_replace("'","%27",$xlink);
}else{
$whr=" WHERE $PrinaryKey LIKE '%$newyy$newmm%' ";
if($fldWhere <> ""){
$whr=" WHERE $fldWhere AND $PrinaryKey LIKE '%$newyy$newmm%' ";
}
}
$sqlCommand="SELECT * FROM $tbname $whr";
//echo $sqlCommand;
$result=mysql_query($sqlCommand);
$TotalRow=mysql_num_rows($result);
$TotalPage=ceil($TotalRow / $NumrowPerPage);
$FirstRecord=(($PageNo-1) * $NumrowPerPage) + 1 ;
$LastRecord=($FirstRecord+$NumrowPerPage)-1;
$NextPage=($PageNo >= $TotalPage) ? $TotalPage : $PageNo+1;
$PrevPage=($PageNo == 1) ? 1 : $PageNo-1;
if($PageNo==1 AND $TotalPage > 1){
$STR_PAGE="
";
for($y=$newyy+1;$y > $newyy-3;$y--){
if($y==$newyy){
$stryy.="$y";
}else{
$stryy.=" $y";
}
}
$stryy.=" ";
$strmm="";
for($m=1;$m<=12;$m++){
$xm=substr("0$m",-2);
if($xm==$newmm){
$strmm.="$xm";
}else{
$strmm.=" $xm";
}
}
$strmm.=" ";
$strdd="";
for($d=1;$d<=31;$d++){
$xd=substr("0$d",-2);
if($xd==$newdd){
$strdd.="$xd";
}else{
$strdd.=" $xd";
}
}
$strdd.=" ";
$PageNo=($PageNo=="") ? 1 : $PageNo;
$yymmdd=substr($newyy,-2)."$newmm$newdd";
$Keyword1=str_replace("%27","'",$Keyword1);
$Keyword1=str_replace("\\'","'",$Keyword1);
$Keyword1=stripslashes($Keyword1);
$Keyword1=htmlspecialchars($Keyword1,ENT_NOQUOTES);
$Keyword1=htmlspecialchars($Keyword1,ENT_QUOTES);
if($fldWhere <> ""){
$fldWhere=trim($fldWhere);
$fldWhere=str_replace("WHERE","AND",$fldWhere);
$fldWhere=str_replace("Where","AND",$fldWhere);
$fldWhere=str_replace("where","AND",$fldWhere);
$fldWhere=substr($fldWhere,4,strlen($fldWhere));
}
if($search=="y"){
if($SearchCon==1) $xwhr=" AND $fldSearch LIKE '$Keyword1%' ";
if($SearchCon==2) $xwhr=" AND $fldSearch LIKE '%$Keyword1' ";
if($SearchCon==3) $xwhr=" AND $fldSearch LIKE '$Keyword1' ";
if($SearchCon==4) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
if($SearchCon==5) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
if($fldWhere <> ""){
$whr .= "WHERE $fldWhere $xwhr AND $PrinaryKey LIKE '%$yymmdd%' ";
}else{
$xwhr=trim($xwhr);
$xwhr=substr($xwhr,4,strlen($xwhr));
$whr .= "WHERE $xwhr AND $PrinaryKey LIKE '%$yymmdd%' ";
}
$xlink="&fldSearch=$fldSearch&SearchCon=$SearchCon&Keyword1=$Keyword1&Keyword2=$Keyword2";
$xlink=str_replace("'","%27",$xlink);
}else{
$whr.=" WHERE $PrinaryKey LIKE '%$yymmdd%' ";
if($fldWhere <> ""){
$whr=" WHERE $fldWhere AND $PrinaryKey LIKE '%$yymmdd%' ";
}
}
$sqlCommand="SELECT * FROM $tbname $whr";
//echo $sqlCommand;
$result=mysql_query($sqlCommand);
$TotalRow=mysql_num_rows($result);
$TotalPage=ceil($TotalRow / $NumrowPerPage);
$FirstRecord=(($PageNo-1) * $NumrowPerPage) + 1 ;
$LastRecord=($FirstRecord+$NumrowPerPage)-1;
$NextPage=($PageNo >= $TotalPage) ? $TotalPage : $PageNo+1;
$PrevPage=($PageNo == 1) ? 1 : $PageNo-1;
if($PageNo==1 AND $TotalPage > 1){
$STR_PAGE="
ѡáѧ Class (ADDPAGE_TEMPLATE2) ";
if($newyy <> ""){
$_SESSION["newyyyy"]=$newyy;
}else{
if($_SESSION["newyyyy"]=="") $_SESSION["newyyyy"]=Date("Y");
}
$newyy=$_SESSION["newyyyy"];
if($newmm <> ""){
$_SESSION["newmmmm"]=$newmm;
}else{
if($_SESSION["newmmmm"]=="") $_SESSION["newmmmm"]=Date("m");
}
$newmm=$_SESSION["newmmmm"];
$yyyymm=$newyy.$newmm;
$stryy="";
for($y=$newyy+1;$y > $newyy-3;$y--){
if($y==$newyy){
$stryy.="$y";
}else{
$stryy.=" $y";
}
}
$stryy.=" ";
$strmm="";
for($m=1;$m<=12;$m++){
$xm=substr("0$m",-2);
if($xm==$newmm){
$strmm.="$xm";
}else{
$strmm.=" $xm";
}
}
$strmm.=" ";
$whrofset=($ofset <> "" ) ? "AND $PrinaryKey='$ofset' " : "";
$PageNo=($PageNo=="") ? 1 : $PageNo;
$Keyword1=str_replace("%27","'",$Keyword1);
$Keyword1=str_replace("\\'","'",$Keyword1);
$Keyword1=stripslashes($Keyword1);
$Keyword1=htmlspecialchars($Keyword1,ENT_NOQUOTES);
$Keyword1=htmlspecialchars($Keyword1,ENT_QUOTES);
if($search=="y"){
if($SearchCon==1) $xwhr=" AND $fldSearch LIKE '$Keyword1%' ";
if($SearchCon==2) $xwhr=" AND $fldSearch LIKE '%$Keyword1' ";
if($SearchCon==3) $xwhr=" AND $fldSearch LIKE '$Keyword1' ";
if($SearchCon==4) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
if($SearchCon==5) $xwhr=" AND $fldSearch LIKE '%$Keyword1%' ";
$whr=str_replace("AND"," WHERE ",$xwhr);
$whr.=" AND $PrinaryKey LIKE '%$newyy$newmm%' $fldWhere $whrofset";
$xlink="&fldSearch=$fldSearch&SearchCon=$SearchCon&Keyword1=$Keyword1&Keyword2=$Keyword2";
$xlink=str_replace("'","%27",$xlink);
}else{
$whr=" WHERE $PrinaryKey LIKE '%$newyy$newmm%' $fldWhere $whrofset";
}
$sqlCommand="SELECT * FROM $tbname $whr ";
//echo $sqlCommand;
$result=mysql_query($sqlCommand);
$TotalRow=mysql_num_rows($result);
$TotalPage=ceil($TotalRow / $NumrowPerPage);
// echo $TotalRow;
$FirstRecord=(($PageNo-1) * $NumrowPerPage) + 1 ;
$LastRecord=($FirstRecord+$NumrowPerPage)-1;
$NextPage=($PageNo >= $TotalPage) ? $TotalPage : $PageNo+1;
$PrevPage=($PageNo == 1) ? 1 : $PageNo-1;
if($PageNo==1 AND $TotalPage > 1){
$STR_PAGE="
$showtitle
$label
EOD;
}
/*
if($ReadOnly==1){
$STR_HTML .= <<
EOD;
}*/
$STR_HTML .= <<
EOD;
$NumRow=1;
$TheRow=1;
while($data=mysql_fetch_array($result) ){
$ID=$data[$PrinaryKey];
$Status=$data[$FieldsStatus];
$theAction=($Status=="" or $FieldsStatus =="" or $StatusColor=="") ? "#F4F4F4" : $StatusColor[$Status];//defind color
$theDefaultColor="#FFCCFF"; //pink
$thePointerColor="#FFCC99"; // red
$linkpage2=($ReadOnly==1) ? "top.location.href='$linkInfo?rowkey=edit&ID=$ID'" : "";
$FldColor=$data[$FieldsColor];
$FontColor=$ValueColor[$FldColor];
$STR_HTML .= <<
EOD;
$STR_HTML .= <<$data[RuningCount]
EOD;
foreach($showfields as $fields => $label){
if($PrinaryKey==$fields) $ID=$data[$PrinaryKey];
if($fields==$FieldsColor or $ofset <> ""){
if($ofset <> ""){
$FontColor=($PrinaryKey==$fields) ? "red" : "";
$xstr1=($PrinaryKey==$fields) ? "" : "";
$xstr2=($PrinaryKey==$fields) ? " $xstr1$data[$fields]$xstr2
EOD;
}else{
$STR_HTML .= <<$data[$fields]
EOD;
}
}else{
$STR_HTML .= <<$data[$fields]
EOD;
}
}
/*if($ReadOnly==1){
$strlink="$strlink
EOD;
}*/
$STR_HTML .= <<
EOD;
$NumRow++;
$TheRow++;
}
$STR_HTML .= <<
EOD;
if($xdisplay==1){
$STR_HTML .= <<
open_select_media('../../','open_select_media.php') ;
EOD;
}
return $STR_HTML;
}
//-----------------------------------------------------------------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------------------------------------------------------------
function check_auth_user($root){
$user=$_SESSION["UID"];
if($user=="" or empty($user) ){
Header('Content-Type: text/html; charset=windows-874;');
echo "
..سԷҹк سҵǨͺա.. ...ôѡ кѧѺ..
";
redirect_page2($root."index.php",3);
exit;
}
}
function ActiveTap($TabArray,$DataArray,$w,$h){
global $tabonclick;
$number=Count($TabArray);
$xwid=($number*100) +($number*6);
$ewid=$w-$xwid+20;
$ewid=$ewid."px";
$h=$h."px";
$w=$w."px";
$STR_HTML .= <<
EOD;
$i=0;
foreach($TabArray as $IdTab => $TabValue){
$jscommand=$tabonclick[$i];
$TabValue=trim($TabValue);
$STR_HTML .= <<
$TabValue
EOD;
$i++;
}//end foreach
$colspan=($number*2)+3;
$STR_HTML .= <<
EOD;
$i=0;
foreach($DataArray as $key=> $Data){
$id="Tab$i";
$stlye="display:none;height: $h;width: $w;";
if($i==0) $stlye="display:block;height: $h;width: $w;";
$STR_HTML .= <<
$Data
EOD;
$i=0;
foreach($TabArray as $IdTab => $TabValue){
$STR_HTML .= <<
$TabValue
EOD;
$i++;
}//end foreach
$STR_HTML .= <<
EOD;
$i=0;
foreach($DataArray as $key=> $Data){
$id="Tab$i";
$stlye="display:none;height: $h;width: $w; OVERFLOW-Y: auto;OVERFLOW-X: auto; SCROLLBAR-HIGHLIGHT-COLOR: #e8e8e8; SCROLLBAR-SHADOW-COLOR: #e8e8e8; SCROLLBAR-3DLIGHT-COLOR: #d6d6d6; SCROLLBAR-ARROW-COLOR: #bacbdb; SCROLLBAR-TRACK-COLOR: #ffffff; SCROLLBAR-DARKSHADOW-COLOR: #d6d6d6; SCROLLBAR-BASE-COLOR: #d6d6d6 ";
if($i==0) $stlye="display:block;height: $h;width: $w; OVERFLOW-Y: auto;OVERFLOW-X: auto;SCROLLBAR-HIGHLIGHT-COLOR: #e8e8e8; SCROLLBAR-SHADOW-COLOR: #e8e8e8; SCROLLBAR-3DLIGHT-COLOR: #d6d6d6; SCROLLBAR-ARROW-COLOR: #bacbdb; SCROLLBAR-TRACK-COLOR: #ffffff; SCROLLBAR-DARKSHADOW-COLOR: #d6d6d6; SCROLLBAR-BASE-COLOR: #d6d6d6";
$STR_HTML .= << $Data
EOD;
$i++;
}//end foreach
echo $STR_HTML;
}// end function DisplayActiveTap
function DisplayActiveTap2($TabArray,$DataArray,$w,$h){
$number=Count($TabArray);
$h=$h."px";
$w=$w."px";
$STR_HTML .= <<
EOD;
$i=0;
foreach($TabArray as $IdTab => $TabValue){
$STR_HTML .= << $TabValue
EOD;
$i++;
}//end foreach
$STR_HTML .= <<
EOD;
$i=0;
foreach($DataArray as $key=> $Data){
$id="Tab$i";
$htbl=$h-30;
$wtbl=$w-20;
$stlye="display:none;height: $h;width: $w;";
if($i==0) $stlye="display:block;height: $h;width: $w;";
$STR_HTML .= <<
EOD;
$i++;
}//end foreach
echo $STR_HTML;
}// end function DisplayActiveTap
function NEWTEXTAREA($Name,$Attribute){
$xstr.="var frm = document.getElementById('myform');";
$xstr.="var $Name = document.createElement('TEXTAREA');";
$xstr.="$Name.setAttribute('name', '$Name'+newrowlabel);";
$xstr.="$Name.setAttribute('id', '$Name'+newrowlabel);";
$flag=0;
foreach($Attribute as $key => $val){
switch($key){
case "onclick" :
$xstr.="
$Name.onclick=function(){
$val
};";
break;
case "onchange" :
$xstr.="
$Name.onchange=function(){
$val
};";
break;
case "ondblclick" :
$xstr.="
$Name.ondblclick=function(){
$val
};";
break;
case "onkeyup" :
$xstr.="
$Name.onkeyup=function(){
$val
};";
break;
case "onkeypress" :
$xstr.="
$Name.onkeypress=function(){
$val
};";
break;
case "onblur" :
$xstr.="
$Name.onblur=function(){
$val
};";
break;
case "onfocus" :
$xstr.="
$Name.onfocus=function(){
$val
};";
break;
case "onmouseover" :
//$xstr.="$Name.setAttribute('style', '$val');";
break;
default :
$xstr.="$Name.setAttribute('$key', '$val');";
break;
}
}
$xstr.="frm.appendChild($Name);";
return $xstr;
}
function NEWSELECT($Name,$Attribute,$data){
$xstr.="var frm = document.getElementById('myform');";
$xstr.="var $Name = document.createElement('SELECT');";
$xstr.="$Name.setAttribute('name', '$Name'+newrowlabel);";
$xstr.="$Name.setAttribute('id', '$Name'+newrowlabel);";
$i=1;
foreach($data as $key => $val){
$opt="opt$Name$i";
$xstr.="var $opt = document.createElement('OPTION');";
$xstr.="$opt.text='$val';";
$xstr.="$opt.value='$key';";
$xstr.="$Name.add($opt);";
$i++;
}
foreach($Attribute as $key => $val){
switch($key){
case "onclick" :
$xstr.="
$Name.onclick=function(){
$val
};";
break;
case "onchange" :
$xstr.="
$Name.onchange=function(){
$val
};";
break;
case "ondblclick" :
$xstr.="
$Name.ondblclick=function(){
$val
};";
break;
case "onkeyup" :
$xstr.="
$Name.onkeyup=function(){
$val
};";
break;
case "onkeypress" :
$xstr.="
$Name.onkeypress=function(){
$val
};";
break;
case "onblur" :
$xstr.="
$Name.onblur=function(){
$val
};";
break;
case "onfocus" :
$xstr.="
$Name.onfocus=function(){
$val
};";
break;
case "onmouseover" :
//$xstr.="$Name.setAttribute('style', '$val');";
break;
default :
$xstr.="$Name.setAttribute('$key', '$val');";
break;
}
}
$xstr.="frm.appendChild($Name);";
return $xstr;
}
function NEWINPUT($Name,$Attribute){
$xstr.="var frm = document.getElementById('myform');";
$xstr.="var $Name = document.createElement('INPUT');";
$xstr.="$Name.setAttribute('name', '$Name'+newrowlabel);";
$xstr.="$Name.setAttribute('id', '$Name'+newrowlabel);";
$flag=0;
foreach($Attribute as $key => $val){
switch($key){
case "onclick" :
$xstr.="
$Name.onclick=function(){
$val
};";
break;
case "onchange" :
$xstr.="
$Name.onchange=function(){
$val
};";
break;
case "onpropertychange" :
$xstr.="
$Name.onpropertychange=function(){
$val
};";
break;
case "ondblclick" :
$xstr.="
$Name.ondblclick=function(){
$val
};";
break;
case "onkeyup" :
$xstr.="
$Name.onkeyup=function(){
$val
};";
break;
case "onkeypress" :
$xstr.="
$Name.onkeypress=function(){
$val
};";
break;
case "onblur" :
$xstr.="
$Name.onblur=function(){
$val
};";
break;
case "onfocus" :
$xstr.="
$Name.onfocus=function(){
$val
};";
break;
case "onmouseover" :
//$xstr.="$Name.setAttribute('style', '$val');";
break;
default :
$xstr.="$Name.setAttribute('$key', '$val');";
break;
}
}
$xstr.="frm.appendChild($Name);";
return $xstr;
}
function NEWLABEL($Name,$Attribute){
$xstr.="var frm = document.getElementById('myform');";
$xstr.="var $Name = document.createElement('SPAN');";
$xstr.="$Name.setAttribute('name', '$Name'+newrowlabel);";
$xstr.="$Name.setAttribute('id', '$Name'+newrowlabel);";
//$xstr.="var str;";
//echo "$xstr ![](\"../../images/nav_first.gif\")
![](\"../../images/nav_previous.gif\")
![](\"../../images/nav_next.gif\")
![](\"../../images/nav_last.gif\")
";
}
if($PageNo==$TotalPage AND $TotalPage > 1){
$STR_PAGE="
![](\"../../icon/document_text.gif\"){kind=icon}
![](\"../images/nav_first.gif\")
![](\"../images/nav_previous.gif\")
![](\"../images/nav_next.gif\")
![](\"../images/nav_last.gif\")
";
}
if($PageNo==$TotalPage AND $TotalPage > 1){
$STR_PAGE="
![](\"images/nav_next.gif\")
![](\"images/nav_last.gif\")
";
}
if($PageNo==$TotalPage AND $TotalPage > 1){
$STR_PAGE="
![](\"images/nav_first.gif\")
![](\"images/nav_previous.gif\")
