Menu
▾
▴
andro-hacker — For under-the-hood topics
You can subscribe to this list here.
| 2007 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(2) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008 |
Jan
|
Feb
(58) |
Mar
(126) |
Apr
(96) |
May
(42) |
Jun
(59) |
Jul
(80) |
Aug
(95) |
Sep
(99) |
Oct
(137) |
Nov
(54) |
Dec
(138) |
| 2009 |
Jan
(174) |
Feb
(83) |
Mar
(36) |
Apr
(22) |
May
(16) |
Jun
(11) |
Jul
(7) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: <ken...@us...> - 2009-04-06 18:43:31
|
Revision: 1337
http://andro.svn.sourceforge.net/andro/?rev=1337&view=rev
Author: kendowns
Date: 2009-04-06 18:43:16 +0000 (Mon, 06 Apr 2009)
Log Message:
-----------
Added Paths:
-----------
releases/2009.04.06.1/
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-04-06 18:40:05
|
Revision: 1336
http://andro.svn.sourceforge.net/andro/?rev=1336&view=rev
Author: kendowns
Date: 2009-04-06 18:39:44 +0000 (Mon, 06 Apr 2009)
Log Message:
-----------
Sourceforge 2738278, allow explicit typecasts in chain arguments
Sourceforge 2738280, fix !EMPTY comparison for dates and datetimes
Modified Paths:
--------------
trunk/andro/application/androBuild.php
Modified: trunk/andro/application/androBuild.php
===================================================================
--- trunk/andro/application/androBuild.php 2009-04-06 17:35:31 UTC (rev 1335)
+++ trunk/andro/application/androBuild.php 2009-04-06 18:39:44 UTC (rev 1336)
@@ -5767,8 +5767,13 @@
$retval = $arg1. " $not BETWEEN ".implode(" AND ",$args);
break;
case "!EMPTY":
- $sfb=$this->SQLFORMATBLANK($cta1,true,true);
- $retval = "COALESCE($arg1,$sfb) <> $sfb";
+ if($cta1=='date' || $cta1=='datetime') {
+ $retval = "$arg1 IS NOT NULL";
+ }
+ else {
+ $sfb=$this->SQLFORMATBLANK($cta1,true,true);
+ $retval = "COALESCE($arg1,$sfb) <> $sfb";
+ }
break;
case "EMPTY":
$sfb=$this->SQLFORMATBLANK($cta1,true,true);
@@ -6536,8 +6541,29 @@
$errors+=$this->SpecValidateRI('histcols' ,'retcol' ,'History Definition');
$errors+=$this->SpecValidateRI('tabprojcols' ,'column_id','Projection');
$errors+=$this->SpecValidateRI('colchaintests','column_id','Chain Test Definition');
- $errors+=$this->SpecValidateRI('colchainargs' ,'column_id_arg','Chain Argument Definition');
+ #$errors+=$this->SpecValidateRI('colchainargs' ,"replace(column_id_arg,'::int','')",'Chain Argument Definition');
+
+ $this->LogEntry("Checking column definitions in chain arguments");
+ $errors = 0;
+ $sq="SELECT table_id,column_id_arg as column_id FROM zdd.colchainargs
+ WHERE column_id_arg <> ''
+ AND NOT EXISTS (
+ SELECT * from zdd.tabflat
+ WHERE table_id = zdd.colchainargs.table_id
+ AND column_id = REGEXP_REPLACE(zdd.colchainargs.column_id_arg,'::.*','')
+ )";
+ $results = $this->SQLRead($sq);
+ while ($row=pg_fetch_array($results)) {
+ $retval=false;
+ $this->LogEntry("");
+ $this->LogEntry(
+ "ERROR >> Chain Argument Definition in table colchainargs"
+ ." refers to undefined column ".$row['column_id']
+ );
+ $errors++;
+ }
+
// Some manual RI checks
$sq="SELECT h.history,hc.table_id,hc.column_id
FROM zdd.histcols hc
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-04-06 17:35:40
|
Revision: 1335
http://andro.svn.sourceforge.net/andro/?rev=1335&view=rev
Author: kendowns
Date: 2009-04-06 17:35:31 +0000 (Mon, 06 Apr 2009)
Log Message:
-----------
Added Paths:
-----------
releases/2009.04.06/
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-04-04 13:16:13
|
Revision: 1334
http://andro.svn.sourceforge.net/andro/?rev=1334&view=rev
Author: kendowns
Date: 2009-04-04 13:16:11 +0000 (Sat, 04 Apr 2009)
Log Message:
-----------
Sourceforge 2706257
Modified Paths:
--------------
trunk/andro/clib/x6.js
Modified: trunk/andro/clib/x6.js
===================================================================
--- trunk/andro/clib/x6.js 2009-04-04 13:11:28 UTC (rev 1333)
+++ trunk/andro/clib/x6.js 2009-04-04 13:16:11 UTC (rev 1334)
@@ -6736,12 +6736,16 @@
$('#'+id).height(conOtrHtNew);
$('#'+id+"_inner").height(conInrHtNew);
+ // KFD 4/4/09 Sourceforge 2706257
+ // get scrolltop of window
+ var windowScrollTop = $(window).scrollTop();
+
// now center this guy.
var left = Math.floor( (ww-mw)/2 );
$('#x6modal')
.css('display','none')
.css('left',left)
- .css('top',50)
+ .css('top',windowScrollTop + 50)
.fadeIn('fast',
function() {
x6events.fireEvent('objectFocus',id);
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-04-04 13:11:31
|
Revision: 1333
http://andro.svn.sourceforge.net/andro/?rev=1333&view=rev
Author: kendowns
Date: 2009-04-04 13:11:28 +0000 (Sat, 04 Apr 2009)
Log Message:
-----------
Sourceforge 2706256
Modified Paths:
--------------
trunk/andro/clib/x6.js
Modified: trunk/andro/clib/x6.js
===================================================================
--- trunk/andro/clib/x6.js 2009-04-04 12:48:56 UTC (rev 1332)
+++ trunk/andro/clib/x6.js 2009-04-04 13:11:28 UTC (rev 1333)
@@ -6762,6 +6762,8 @@
$('#x6modalblock').animate({opacity:0},'fast',null
,function() {
$(this).css('display','none');
+ // KFD 4/4/09 Sourceforge 2706256
+ $('body').css('overflow','auto');
x6events.priorFocus();
}
);
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-04-04 12:48:58
|
Revision: 1332
http://andro.svn.sourceforge.net/andro/?rev=1332&view=rev
Author: kendowns
Date: 2009-04-04 12:48:56 +0000 (Sat, 04 Apr 2009)
Log Message:
-----------
Sourceforge 2722150, detect suffix/prefix combos that result in empty column names.
Modified Paths:
--------------
trunk/andro/application/androBuild.php
Modified: trunk/andro/application/androBuild.php
===================================================================
--- trunk/andro/application/androBuild.php 2009-03-24 02:11:19 UTC (rev 1331)
+++ trunk/andro/application/androBuild.php 2009-04-04 12:48:56 UTC (rev 1332)
@@ -6439,6 +6439,26 @@
);
$this->LogEntry("ERROR >> ");
}
+
+ // KFD 4/4/09 Sourceforge 2722150
+ $this->LogEntry("Looking for bad suffix/prefix combos, empty columns");
+ $results = $this->SQLRead(
+ "select table_id,prefix,suffix from zdd.tabflat ".
+ " where column_id_src=''");
+ while($row=pg_fetch_array($results)) {
+ $errors++;
+ $this->LogEntry("");
+ $this->LogEntry(
+ "ERROR >> table ". $row["table_id"]." has an empty column."
+ );
+ $this->LogEntry(
+ "ERROR >> maybe the prefix or suffix is wrong?"
+ );
+ $this->LogEntry("ERROR >> "
+ ." Prefix: ".$row['prefix'].", Suffix: ".$row['suffix']
+ );
+ $this->LogEntry("ERROR >> ");
+ }
// Check for no automation Id for some automations
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <dor...@us...> - 2009-03-24 02:11:22
|
Revision: 1331
http://andro.svn.sourceforge.net/andro/?rev=1331&view=rev
Author: dorgan1983
Date: 2009-03-24 02:11:19 +0000 (Tue, 24 Mar 2009)
Log Message:
-----------
slight mod so that file is truncated if rewritten but clause was added for only writing/creating file when it doesnt exist because user might add custom rewrite rules...we should add a way to create custom rewrite rules to the YAML.
Modified Paths:
--------------
trunk/andro/application/androBuild.php
Modified: trunk/andro/application/androBuild.php
===================================================================
--- trunk/andro/application/androBuild.php 2009-03-24 01:49:11 UTC (rev 1330)
+++ trunk/andro/application/androBuild.php 2009-03-24 02:11:19 UTC (rev 1331)
@@ -10073,15 +10073,12 @@
if ($changequotes) {
$text = str_replace("#","\"",$text);
}
- // Might have to check file line by line in
- // the future for $text and write if doesnt exist
+ $text = $text ."\r\n";
if ( !is_file( $file ) ) {
- $text = $text ."\r\n";
- // DO 3-23-2009 Changed to write only mode
- // Since apache is currently using the .htacess file
- $FILEOUT = fopen( $file , 'a' );
- fwrite($FILEOUT,$text);
- fclose($FILEOUT);
+ // DO 3-23-2009 Changed mode
+ $FILEOUT = fopen( $file , 'w+' );
+ fwrite($FILEOUT,$text);
+ fclose($FILEOUT);
}
}
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <dor...@us...> - 2009-03-24 02:01:14
|
Revision: 1325
http://andro.svn.sourceforge.net/andro/?rev=1325&view=rev
Author: dorgan1983
Date: 2009-03-24 01:41:10 +0000 (Tue, 24 Mar 2009)
Log Message:
-----------
file is generated by builder
Removed Paths:
-------------
trunk/andro/lib/.htaccess
Deleted: trunk/andro/lib/.htaccess
===================================================================
--- trunk/andro/lib/.htaccess 2009-03-23 19:07:55 UTC (rev 1324)
+++ trunk/andro/lib/.htaccess 2009-03-24 01:41:10 UTC (rev 1325)
@@ -1 +0,0 @@
-Deny From All
\ No newline at end of file
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <dor...@us...> - 2009-03-24 01:49:14
|
Revision: 1330
http://andro.svn.sourceforge.net/andro/?rev=1330&view=rev
Author: dorgan1983
Date: 2009-03-24 01:49:11 +0000 (Tue, 24 Mar 2009)
Log Message:
-----------
Change to "smart" builder to fix SB Bug # 2686762 as well as error writing .htaccess files SF Bug #2654713 :)
Modified Paths:
--------------
trunk/andro/application/androBuild.php
Property Changed:
----------------
trunk/andro/application/
trunk/andro/docsapp/
trunk/andro/docslib/
trunk/andro/lib/
trunk/andro/root/
Property changes on: trunk/andro/application
___________________________________________________________________
Modified: svn:ignore
- pg_overrides.php
+ pg_overrides.php
.htaccess
Modified: trunk/andro/application/androBuild.php
===================================================================
--- trunk/andro/application/androBuild.php 2009-03-24 01:43:00 UTC (rev 1329)
+++ trunk/andro/application/androBuild.php 2009-03-24 01:49:11 UTC (rev 1330)
@@ -170,11 +170,11 @@
$changed = false;
$checksums = array();
- $specboot = $parm["SPEC_BOOT"].".add";
+ $specboot = $parm['SPEC_BOOT'].".add";
$checksums[] = array(
'file'=>$specboot,
- 'md5'=>md5_file( $parm['DIR_PUB']."lib/".$specboot ),
- 'fullpath'=>$parm['DIR_PUB']."lib/".$specboot
+ 'md5'=>md5_file( $parm['DIR_PUB'].'lib/' .$specboot ),
+ 'fullpath'=>$parm['DIR_PUB'].'lib/' .$specboot
);
if ( isset( $parm['INST'] ) ) {
@@ -184,18 +184,20 @@
}
if ($parm["SPEC_LIST"]<>"") {
- $speclist = explode(",",$parm["SPEC_LIST"]);
+ $speclist = explode(",",$parm['SPEC_LIST']);
foreach ($speclist as $spec) {
- if(substr($spec,-5)<>'.yaml') {
+ if( substr($spec,-5) <>'.yaml') {
$file = $spec.".add";
} else {
$file = $spec;
}
- $checksums[] = array(
- 'file'=>$file,
- 'md5'=>md5_file( $parm["DIR_PUB"]."application/".$file ),
- 'fullpath'=>$parm["DIR_PUB"]."application/".$file
- );
+ if ( is_file( $parm['DIR_PUB'] .'application/' .$file ) ) {
+ $checksums[] = array(
+ 'file'=>$file,
+ 'md5'=>md5_file( $parm['DIR_PUB'] .'application/' .$file ),
+ 'fullpath'=>$parm['DIR_PUB'] .'application/' .$file
+ );
+ }
}
}
$checkqry = "SELECT relname FROM pg_class WHERE relname='instance_spec_checksums'";
@@ -10069,11 +10071,18 @@
function FS_PUT_CONTENTS($file,$text,$changequotes=false) {
if ($changequotes) {
- $text = str_replace("#","\"",$text);
+ $text = str_replace("#","\"",$text);
}
- $FILEOUT=fopen($file,"w");
- fwrite($FILEOUT,$text);
- fclose($FILEOUT);
+ // Might have to check file line by line in
+ // the future for $text and write if doesnt exist
+ if ( !is_file( $file ) ) {
+ $text = $text ."\r\n";
+ // DO 3-23-2009 Changed to write only mode
+ // Since apache is currently using the .htacess file
+ $FILEOUT = fopen( $file , 'a' );
+ fwrite($FILEOUT,$text);
+ fclose($FILEOUT);
+ }
}
function fs_Skeleton_copy($src,$dst) {
Property changes on: trunk/andro/docsapp
___________________________________________________________________
Added: svn:ignore
+
.htaccess
Property changes on: trunk/andro/docslib
___________________________________________________________________
Added: svn:ignore
+
.htaccess
Property changes on: trunk/andro/lib
___________________________________________________________________
Added: svn:ignore
+
.htaccess
Property changes on: trunk/andro/root
___________________________________________________________________
Added: svn:ignore
+
.htaccess
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <dor...@us...> - 2009-03-24 01:46:23
|
Revision: 1329
http://andro.svn.sourceforge.net/andro/?rev=1329&view=rev
Author: dorgan1983
Date: 2009-03-24 01:43:00 +0000 (Tue, 24 Mar 2009)
Log Message:
-----------
file is generated by builder
Removed Paths:
-------------
trunk/andro/application/.htaccess
Deleted: trunk/andro/application/.htaccess
===================================================================
--- trunk/andro/application/.htaccess 2009-03-24 01:42:31 UTC (rev 1328)
+++ trunk/andro/application/.htaccess 2009-03-24 01:43:00 UTC (rev 1329)
@@ -1 +0,0 @@
-Deny From All
\ No newline at end of file
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <dor...@us...> - 2009-03-24 01:46:23
|
Revision: 1328
http://andro.svn.sourceforge.net/andro/?rev=1328&view=rev
Author: dorgan1983
Date: 2009-03-24 01:42:31 +0000 (Tue, 24 Mar 2009)
Log Message:
-----------
file is generated by builder
Removed Paths:
-------------
trunk/andro/docsapp/.htaccess
Deleted: trunk/andro/docsapp/.htaccess
===================================================================
--- trunk/andro/docsapp/.htaccess 2009-03-24 01:42:10 UTC (rev 1327)
+++ trunk/andro/docsapp/.htaccess 2009-03-24 01:42:31 UTC (rev 1328)
@@ -1 +0,0 @@
-Deny From All
\ No newline at end of file
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <dor...@us...> - 2009-03-24 01:46:23
|
Revision: 1326
http://andro.svn.sourceforge.net/andro/?rev=1326&view=rev
Author: dorgan1983
Date: 2009-03-24 01:41:35 +0000 (Tue, 24 Mar 2009)
Log Message:
-----------
file is generated by builder
Removed Paths:
-------------
trunk/andro/root/.htaccess
Deleted: trunk/andro/root/.htaccess
===================================================================
--- trunk/andro/root/.htaccess 2009-03-24 01:41:10 UTC (rev 1325)
+++ trunk/andro/root/.htaccess 2009-03-24 01:41:35 UTC (rev 1326)
@@ -1 +0,0 @@
-Deny From All
\ No newline at end of file
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <dor...@us...> - 2009-03-24 01:46:23
|
Revision: 1327
http://andro.svn.sourceforge.net/andro/?rev=1327&view=rev
Author: dorgan1983
Date: 2009-03-24 01:42:10 +0000 (Tue, 24 Mar 2009)
Log Message:
-----------
file is generated by builder
Removed Paths:
-------------
trunk/andro/docslib/.htaccess
Deleted: trunk/andro/docslib/.htaccess
===================================================================
--- trunk/andro/docslib/.htaccess 2009-03-24 01:41:35 UTC (rev 1326)
+++ trunk/andro/docslib/.htaccess 2009-03-24 01:42:10 UTC (rev 1327)
@@ -1 +0,0 @@
-Deny From All
\ No newline at end of file
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-03-23 19:08:04
|
Revision: 1324
http://andro.svn.sourceforge.net/andro/?rev=1324&view=rev
Author: kendowns
Date: 2009-03-23 19:07:55 +0000 (Mon, 23 Mar 2009)
Log Message:
-----------
Added Paths:
-----------
releases/2009.03.23/
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-03-23 19:04:50
|
Revision: 1323
http://andro.svn.sourceforge.net/andro/?rev=1323&view=rev
Author: kendowns
Date: 2009-03-23 19:04:46 +0000 (Mon, 23 Mar 2009)
Log Message:
-----------
Sourceforge 2706831.
Modified Paths:
--------------
trunk/andro/application/androBuild.php
Modified: trunk/andro/application/androBuild.php
===================================================================
--- trunk/andro/application/androBuild.php 2009-03-20 18:01:00 UTC (rev 1322)
+++ trunk/andro/application/androBuild.php 2009-03-23 19:04:46 UTC (rev 1323)
@@ -2725,6 +2725,39 @@
"cols_par"=>$pk,
"cols_both"=>$both,
"cols_match"=>$match);
+
+ # KFD 3/23/09 Sourceforge 2706831
+ # HORRIBLE HACK. Make a second list of foreign keys
+ # that includes the prefix also. Good news is we
+ # could gradually switch over to using this proper
+ # one. We cannot change the original one because
+ # we would break all kinds of things.
+ $combo =
+ trim($row["table_id"])."_".
+ trim($row['prefix'])."_".
+ trim($row["table_id_par"])."_".
+ $suffix;
+
+ $this->ufks2[$combo] = array(
+ "combo"=>$combo,
+ "table_id_chd"=>trim($row["table_id"]),
+ "table_id_par"=>trim($row["table_id_par"]),
+ "suffix"=>trim($row["suffix"]),
+ "auto_insert"=>$row["auto_insert"],
+ "copysamecols"=>$row["copysamecols"],
+ "nocolumns"=>$row["nocolumns"],
+ "allow_empty"=>$row["allow_empty"],
+ "allow_orphans"=>$row["allow_orphans"],
+ "delete_cascade"=>$row["delete_cascade"],
+ "prevent_fk_change"=>$row["prevent_fk_change"],
+ "uidisplay"=>$row['uidisplay'],
+ "cols_chd"=>$fk,
+ "cols_par"=>$pk,
+ "cols_both"=>$both,
+ "cols_match"=>$match
+ );
+
+
$rc++;
}
return $retval;
@@ -4270,7 +4303,8 @@
,'auto_prefix'=>$row['auto_prefix']
,'auto_suffix'=>$row['auto_suffix']
);
- $tpi = $row['table_id'].'_'.$tp.'_'.$row['auto_suffix'];
+ # KFD 3/23/09 Sourceforge 2706831 Respect auto_prefix
+ $tpi = $row['table_id'].'_'.$row['auto_prefix'].'_'.$tp.'_'.$row['auto_suffix'];
// This creates definitions grouped by foreign key definitions
if(!isset($ddall[$row['table_id']][$tpi])) {
@@ -4315,16 +4349,19 @@
// Generate the keys match between the two tables
// KFD 2/16/07, big change to allow suffix/prefix
//$keyname = $table_id."_".$table_id_par."_";
+ # KFD 3/23/09 Sourceforge 2706831 Use alternate FK List
$keyname = $foreign_key;
- $keys = $this->ufks[$keyname]["cols_both"];
+ $keys = $this->ufks2[$keyname]["cols_both"];
// KFD 10/12/06, part of general changes to range foreign keys
//$match = str_replace(","," AND new.",$keys);
//$match = "new.".str_replace(":"," = par.",$match);
- $match=str_replace("chd.","new.",$this->ufks[$keyname]['cols_match']);
+ # KFD 3/23/09 Sourceforge 2706831 Use alternate FK List
+ $match=str_replace("chd.","new.",$this->ufks2[$keyname]['cols_match']);
// KFD 6/22/07, don't do a fetch if the foreign key is null
- $keyskids=$this->ufks[$keyname]['cols_chd'];
+ # KFD 3/23/09 Sourceforge 2706831 Use alternate FK List
+ $keyskids=$this->ufks2[$keyname]['cols_chd'];
$akeyskids=explode(',',$keyskids);
$nullchecks = array();
foreach($akeyskids as $akeykid) {
@@ -4332,7 +4369,8 @@
}
// Generate a key change expression for child table
- $keychga = explode(",",$this->ufks[$keyname]["cols_chd"]);
+ # KFD 3/23/09 Sourceforge 2706831 Use alternate FK List
+ $keychga = explode(",",$this->ufks2[$keyname]["cols_chd"]);
$keychgb = array();
foreach($keychga as $keycol) {
$type_id=$this->utabs[$table_id]['flat'][$keycol]['formshort'];
@@ -4442,15 +4480,18 @@
// Generate the keys match between the two tables
// KFD 3/1/07, fix this
$keyname=$foreign_key;
- $keys = $this->ufks[$keyname]["cols_both"];
+ # KFD 3/23/09 Sourceforge 2706831 Use alternate FK List
+ $keys = $this->ufks2[$keyname]["cols_both"];
// KFD 10/12/06, part of range foreign keys actually
// KFD Fixed 6/18/07, this was wrong, making the wrong match
// not picked up cuz we don't use DISTRIBUTE much
- $match=str_replace("chd.",$table_id.".",$this->ufks[$keyname]['cols_match']);
+ # KFD 3/23/09 Sourceforge 2706831 Use alternate FK List
+ $match=str_replace("chd.",$table_id.".",$this->ufks2[$keyname]['cols_match']);
$match=str_replace('par.','new.',$match);
// For "SYNCH" automations, build the reverse match
- $matchr=str_replace("chd.","new.",$this->ufks[$keyname]['cols_match']);
+ # KFD 3/23/09 Sourceforge 2706831 Use alternate FK List
+ $matchr=str_replace("chd.","new.",$this->ufks2[$keyname]['cols_match']);
$matchr=str_replace("par.",$table_id_par.".",$matchr);
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-03-20 18:01:09
|
Revision: 1322
http://andro.svn.sourceforge.net/andro/?rev=1322&view=rev
Author: kendowns
Date: 2009-03-20 18:01:00 +0000 (Fri, 20 Mar 2009)
Log Message:
-----------
Added Paths:
-----------
releases/2009.03.20.1/
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-03-20 17:59:42
|
Revision: 1321
http://andro.svn.sourceforge.net/andro/?rev=1321&view=rev
Author: kendowns
Date: 2009-03-20 17:59:28 +0000 (Fri, 20 Mar 2009)
Log Message:
-----------
Sourceforge 2697962, improved the "hld" variables.
Modified Paths:
--------------
trunk/andro/clib/x6.js
trunk/andro/lib/androX6.php
trunk/andro/lib/index_hidden.php
Modified: trunk/andro/clib/x6.js
===================================================================
--- trunk/andro/clib/x6.js 2009-03-20 15:19:38 UTC (rev 1320)
+++ trunk/andro/clib/x6.js 2009-03-20 17:59:28 UTC (rev 1321)
@@ -1217,6 +1217,12 @@
if(name!=null) {
this.addParm(name,value);
}
+ var self = this;
+ // KFD 3/20/09 Sourceforge 2697962
+ // Make sure hold variables always go through
+ $('[id^=hld]').each(function() {
+ self.addParm( $(this).attr('id'), $(this).val() );
+ });
},
/******/
@@ -2597,6 +2603,15 @@
if(parm!=null) {
this.addParm(parm,value);
}
+
+ // KFD 3/20/09 Sourceforge 2697962
+ // Make sure hold variables always go through
+ var self = this;
+ $('[id^=hld]').each(function() {
+ self.addParm( $(this).attr('id'), $(this).val() );
+ });
+
+
// Create an object
var browser = navigator.appName;
if(browser == "Microsoft Internet Explorer"){
Modified: trunk/andro/lib/androX6.php
===================================================================
--- trunk/andro/lib/androX6.php 2009-03-20 15:19:38 UTC (rev 1320)
+++ trunk/andro/lib/androX6.php 2009-03-20 17:59:28 UTC (rev 1321)
@@ -35,7 +35,10 @@
# put in for the wholdist application to carry
# context from screen to screen.
#
- $this->hld = aFromGp('hld_');
+ # KFD 3/20/09 Sourceforge 2697962
+ # Moved this to index_hidden so it works with
+ # androPage w/o modifying androPage
+ #$this->hld = aFromGp('hld_');
# If the x6exit variable was passed in, put it out
hidden('x6exit',gp('x6exit','N'));
@@ -733,7 +736,9 @@
}
# always at the end, render it
- $this->hldOut($top);
+ # KFD 3/20/09 Sourceforge 2697962
+ # index_hidden calls this now
+ #$this->hldOut($top);
$top->render();
# And a final doo-dad, broadcast a focus event
@@ -838,7 +843,9 @@
jqDocReady('x6events.fireEvent("buttonsNew_'.$table_id.'",true)');
# Render it! That's it!
- $this->hldOut($div);
+ # KFD 3/20/09 Sourceforge 2697962
+ # index_hidden calls this now
+ #$this->hldOut($top);
$div->render();
}
@@ -1021,7 +1028,9 @@
# the browse
jqDocReady("x6events.fireEvent('objectFocus','{$grid->hp['id']}')");
- $this->hldOut($top);
+ # KFD 3/20/09 Sourceforge 2697962
+ # index_hidden calls this now
+ #$this->hldOut($top);
$top->render();
}
@@ -1134,17 +1143,37 @@
return arr($dd,"ui$perm","Y") == 'N' ? false : true;
}
- function hldOut(&$top) {
+ # KFD 3/20/09 Sourceforge 2697962 Moved entire routine into
+ # index_hidden
+ /*
+ function hldOut(&$top=null) {
if(isset($this->hld)) {
foreach($this->hld as $name=>$value) {
- $inp = $top->h('input');
- $inp->hp['type'] = 'hidden';
- $inp->hp['name'] = $inp->hp['id'] = 'hld_'.$name;
- $inp->hp['value'] = $value;
+ # KFD 3/20/09 Sourceforge 2697962
+ # Put out as hidden instead
+ hidden('hld_'.$name,$value);
+ #$inp = $top->h('input');
+ #$inp->hp['type'] = 'hidden';
+ #$inp->hp['name'] = $inp->hp['id'] = 'hld_'.$name;
+ #$inp->hp['value'] = $value;
}
}
}
+ */
+ # KFD 3/20/09 Sourceforge 2697962
+ # Various improvements to hold variables
+ function clearHold($name='') {
+ if($name=='') {
+ $this->hld=array();
+ }
+ else {
+ if(isset($this->hld[$name])) {
+ unset($this->hld[$name]);
+ }
+ }
+ }
+
function fetchParent() {
$ddpar = ddTable(gp('tableIdPar'));
$pks = $ddpar['pks'];
Modified: trunk/andro/lib/index_hidden.php
===================================================================
--- trunk/andro/lib/index_hidden.php 2009-03-20 15:19:38 UTC (rev 1320)
+++ trunk/andro/lib/index_hidden.php 2009-03-20 17:59:28 UTC (rev 1321)
@@ -681,12 +681,32 @@
# and what method to call, so go for it.
ob_start();
$obj = new $x6class();
+ # KFD 3/30/09 Sourceforge 2697962 Do this here, so it
+ # does not matter if androX6 or androPage
+ $obj->hld = aFromGp('hld_');
$obj->dd = ddTable($x6page);
$obj->x6page= $x6page;
$obj->view = arr($obj->dd,'viewname','');
$obj->$x6method();
$HTML = ob_get_clean();
+ # KFD 3/20/09 Sourceforge 2697962
+ # Make sure programmer never has to send out
+ # hold variables, they should go automatically
+ if(gp('json')<>1) {
+ if(isset($obj->hld)) {
+ foreach($obj->hld as $name=>$value) {
+ # KFD 3/20/09 Sourceforge 2697962
+ # Put out as hidden instead
+ hidden('hld_'.$name,$value);
+ #$inp = $top->h('input');
+ #$inp->hp['type'] = 'hidden';
+ #$inp->hp['name'] = $inp->hp['id'] = 'hld_'.$name;
+ #$inp->hp['value'] = $value;
+ }
+ }
+ }
+
# Now if they made a "main" call, see if they want us to
# send back some script as well
if($x6method=='x6main') {
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-03-20 15:19:47
|
Revision: 1320
http://andro.svn.sourceforge.net/andro/?rev=1320&view=rev
Author: kendowns
Date: 2009-03-20 15:19:38 +0000 (Fri, 20 Mar 2009)
Log Message:
-----------
1 item: Sourceforge 2697442, correct vertical sizing of child detail edit panes.
Added Paths:
-----------
releases/2009.03.20/
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-03-20 14:07:48
|
Revision: 1319
http://andro.svn.sourceforge.net/andro/?rev=1319&view=rev
Author: kendowns
Date: 2009-03-20 14:07:40 +0000 (Fri, 20 Mar 2009)
Log Message:
-----------
Sourceforge 2697442, Child detail tables must size according to window height.
Modified Paths:
--------------
trunk/andro/clib/x6.js
Modified: trunk/andro/clib/x6.js
===================================================================
--- trunk/andro/clib/x6.js 2009-03-07 16:27:08 UTC (rev 1318)
+++ trunk/andro/clib/x6.js 2009-03-20 14:07:40 UTC (rev 1319)
@@ -6566,6 +6566,10 @@
/*
* Core function: display myself
*/
+
+ // KFD 3/20/09 Sourceforge 2697442
+ // STRAY CODE, EARLIER VERSION
+ /*
self.display = function(title) {
if(title==null) title = '';
@@ -6660,7 +6664,7 @@
}
);
}
-
+ */
}
@@ -6669,7 +6673,7 @@
* Core function: display one of them
*/
display: function(id) {
- x6.console.group("x6modals.display: "+id);
+ x6.console.group("x6modals.display: "+id);
// start by making everybody inside the modal
// invisible, then make the one we are interested
// in visible later on
@@ -6703,6 +6707,19 @@
var mw = $('#x6modal').width();
var ww = $(window).width();
var wh = $(window).height();
+
+ // KFD 3/20/09 Sourceforge 2697442
+ // Must set height by window, shrink it
+ // down if necessary
+ // Prefix "con" means "content"
+ // Inr = Inner, Otr = Outer, Ht = Height
+ var conInrHt = $('#'+id).attr('xInnerHeight');
+ var conOtrHt = $('#'+id).attr('xHeight');
+ var delta = conOtrHt - conInrHt;
+ var conOtrHtNew = wh-100;
+ var conInrHtNew = conOtrHtNew - delta;
+ $('#'+id).height(conOtrHtNew);
+ $('#'+id+"_inner").height(conInrHtNew);
// now center this guy.
var left = Math.floor( (ww-mw)/2 );
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-03-07 16:27:16
|
Revision: 1318
http://andro.svn.sourceforge.net/andro/?rev=1318&view=rev
Author: kendowns
Date: 2009-03-07 16:27:08 +0000 (Sat, 07 Mar 2009)
Log Message:
-----------
Added Paths:
-----------
releases/2009.03.07.1/
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-03-07 16:22:48
|
Revision: 1317
http://andro.svn.sourceforge.net/andro/?rev=1317&view=rev
Author: kendowns
Date: 2009-03-07 16:22:39 +0000 (Sat, 07 Mar 2009)
Log Message:
-----------
Sourceforge bug 2671622, inputs now respect table permissions, if a user cannot update the inputs are all grayed out.
Modified Paths:
--------------
trunk/andro/lib/androLib.php
Modified: trunk/andro/lib/androLib.php
===================================================================
--- trunk/andro/lib/androLib.php 2009-03-07 16:01:14 UTC (rev 1316)
+++ trunk/andro/lib/androLib.php 2009-03-07 16:22:39 UTC (rev 1317)
@@ -3799,7 +3799,11 @@
$xRoUpd = 'Y';
}
}
-
+ # KFD 3/7/09 Sourceforge 2671622 perms should be controlled
+ # at top level by table permissions.
+ if(ddUserPerm($table_id,'ins')==false) $xRoIns = 'Y';
+ if(ddUserPerm($table_id,'upd')==false) $xRoUpd = 'Y';
+
# First decision is to work out what kind of control to make
if(arr($colinfo,'x6view','')=='window') {
$input = html('a');
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-03-07 16:01:24
|
Revision: 1316
http://andro.svn.sourceforge.net/andro/?rev=1316&view=rev
Author: kendowns
Date: 2009-03-07 16:01:14 +0000 (Sat, 07 Mar 2009)
Log Message:
-----------
Sourceforge 2671619, profile twosides respect row/col security.
Modified Paths:
--------------
trunk/andro/lib/androX6.php
Modified: trunk/andro/lib/androX6.php
===================================================================
--- trunk/andro/lib/androX6.php 2009-03-07 15:38:21 UTC (rev 1315)
+++ trunk/andro/lib/androX6.php 2009-03-07 16:01:14 UTC (rev 1316)
@@ -785,7 +785,8 @@
$awhere[] = sqlfilter($this->dd['flat'][$colname],$value);
}
if(count($awhere)>0) $where = 'WHERE '.implode(' AND ',$awhere);
- $sql = "Select skey,$uisearch from $table_id $where ORDER BY $ob";
+ $view_id = ddView($table_id);
+ $sql = "Select skey,$uisearch from $view_id $where ORDER BY $ob";
$rows = SQL_AllRows($sql);
$aColumns = explode(',',$uisearch);
foreach($rows as $row) {
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-03-07 15:38:38
|
Revision: 1315
http://andro.svn.sourceforge.net/andro/?rev=1315&view=rev
Author: kendowns
Date: 2009-03-07 15:38:21 +0000 (Sat, 07 Mar 2009)
Log Message:
-----------
Added Paths:
-----------
apps/finance/releases/2009.03.07/
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-03-07 15:35:32
|
Revision: 1314
http://andro.svn.sourceforge.net/andro/?rev=1314&view=rev
Author: kendowns
Date: 2009-03-07 15:35:23 +0000 (Sat, 07 Mar 2009)
Log Message:
-----------
About 6 or 7 Sourceforge bugs fixed.
Added Paths:
-----------
releases/2009.03.07/
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <ken...@us...> - 2009-03-07 15:33:43
|
Revision: 1313
http://andro.svn.sourceforge.net/andro/?rev=1313&view=rev
Author: kendowns
Date: 2009-03-07 15:33:22 +0000 (Sat, 07 Mar 2009)
Log Message:
-----------
Modified Paths:
--------------
apps/finance/trunk/application/finance.dd.yaml
Modified: apps/finance/trunk/application/finance.dd.yaml
===================================================================
--- apps/finance/trunk/application/finance.dd.yaml 2009-03-07 15:18:05 UTC (rev 1312)
+++ apps/finance/trunk/application/finance.dd.yaml 2009-03-07 15:33:22 UTC (rev 1313)
@@ -136,7 +136,7 @@
table orderlines:
- description: lines
+ description: Order Lines
module: ordering
uisort: 110
nomenu: "Y"
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
