navigation  interaction  search

 other resources

Changeset 68

Show
Ignore:
Timestamp:
11/30/05 10:36:39
Author:
brieb
Message:

- Fixed autofill function and conflict with magic quotes.
- Updated styleshet to be more firefox 1.5 friendly.
- Fixed error with inactive text box.
- Added title attributes with keyboard shortcuts to several areas.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/autofill.php

    r51 r68  
    3636*/ 
    3737        require("include/session.php"); 
     38        require("include/common_functions.php"); 
    3839 
    3940        function getAutofillXML($what,$displayfield,$xtrafield,$tabledefid,$thefield,$whereclause){ 
    …… 
    5354                $querystatement.=stripslashes($displayfield)." "; 
    5455                if($thefield) 
    55                                 $querystatement.="=\"".addslashes($what)."\""; 
     56                                $querystatement.="=\"".$what."\""; 
    5657                else  
    57                                 $querystatement.="LIKE \"".addslashes($what)."%\""; 
     58                                $querystatement.="LIKE \"".$what."%\""; 
    5859                $querystatement.="ORDER BY ".stripslashes($displayfield); 
    5960                if($thefield) 
    …… 
    9192 
    9293        if(isset($_GET["l"])){ 
     94                $_GET=addSlashesToArray($_GET); 
    9395                if(!isset($_GET["gf"]))$_GET["gf"]=""; 
    9496                if(!isset($_GET["wc"]))$_GET["wc"]=""; 

  • trunk/changelog.txt

    r67 r68  
    11phpBMS v0.611/ BMS module v0.611 
    22================================== 
     3- Fixed table creation script (install only) 
    34- Fixed tasks display problem. 
    45- Adjusted widths/truncation onf invoice PDF reports for line items. 

  • trunk/common/stylesheet/mozilla/base.css

    r62 r68  
    7070vertical-align:middle; 
    7171cursor: pointer;  
    72 cursor: hand; 
    7372} 
    7473 
    …… 
    157156} 
    158157 
    159 .bodyline{display:inline-block; padding:4px;margin-top:0px;} 
     158.bodyline{ 
     159        display:inline-block; 
     160        padding:4px;margin-top:0px; 
     161} 
    160162 
    161163FIELDSET,.box{ 
    …… 
    287289.qr1,.qr2{background-color:#D9DBE1; 
    288290                        cursor: pointer;  
    289             cursor: hand; 
    290291} 
    291292.qr2{background-color:white;} 
    …… 
    293294.qr1:hover, .qr2:Hover {background-color:#999999;} 
    294295 
    295 .qh1, .qh2{background-color:black; cursor: pointer; cursor: hand;} 
     296.qh1, .qh2{background-color:black; cursor: pointer; } 
    296297.qh1 td, .qh2 td{color:white; border-right-color: white; border-bottom-color: white;} 
    297 .qh1, .qh2{background-color:black; cursor: pointer; cursor: hand;} 
     298.qh1, .qh2{background-color:black; cursor: pointer; } 
    298299.qh1 a, .qh2 a{color:white;} 
    299300 
    …… 
    328329                background-repeat:no-repeat; 
    329330                background-position:right; 
    330                 background-origin: border; 
     331                /* background-origin: border; Commented out as of firefox 1.5*/ 
    331332        } 
    332333        .autofillDropDown{ 
    …… 
    397398        #menuBar { 
    398399                background-image:url(menubar.png); 
    399                 repeat:repeat-x; 
     400                background-repeat:repeat-x; 
    400401                background-color:#697388; 
    401402                border-top:1px solid #8693ae; 

  • trunk/include/common_functions.php

    r62 r68  
    159159 
    160160function showSaveCancel($ids=1){ 
    161         ?><div align="right"><input <?php if($ids==1) {?>accesskey="s"<?php }?> id="saveButton<?php echo $ids?>" name="command" type="submit" value="save" class="Buttons" style="width:68px;margin-right:3px;" /><input id="cancelButton<?php echo $ids?>" name="command" type="submit" value="cancel" class="Buttons" style="width:68px;" onClick="this.form.cancelclick.value=true;" <?php if($ids==1) {?>accesskey="x"<?php }?> /></div><?php 
     161        ?><div align="right"><input <?php if($ids==1) {?>accesskey="s"<?php }?> title="(alt+s)" id="saveButton<?php echo $ids?>" name="command" type="submit" value="save" class="Buttons" style="width:68px;margin-right:3px;" /><input id="cancelButton<?php echo $ids?>" name="command" type="submit" value="cancel" class="Buttons" style="width:68px;" onClick="this.form.cancelclick.value=true;" <?php if($ids==1) {?>accesskey="x" <?php }?> title="(alt+x)" /></div><?php 
    162162} 
    163163 

  • trunk/include/fields.php

    r63 r68  
    267267        if ($attributes) foreach($attributes as $attribute => $tvalue) echo " ".$attribute."=\"".$tvalue."\"";                           
    268268        ?> /><button id="<?php echo $name?>Button" type="button" class="invisibleButtons" onClick="showTP('<?php echo $_SESSION["app_path"]?>','<?php echo $name?>');"><img src="<?php echo $_SESSION["app_path"] ?>common/stylesheet/<?php echo $_SESSION["stylesheet"] ?>/button-time.png" align="absmiddle" alt="pick time" width="16" height="16" border="0" /></button> 
    269         <?php if ($required) {?><script language="JavaScript">requiredArray[requiredArray.length]=new Array('<?php echo $name?>','<?php echo $messsage?>');</script><?php }//end if 
     269        <?php if ($required) {?><script language="JavaScript">requiredArray[requiredArray.length]=new Array('<?php echo $name?>','<?php echo $message?>');</script><?php }//end if 
    270270        ?><script language="JavaScript">timeArray[timeArray.length]=new Array('<?php echo $name?>','<?php echo $message?>');</script><?php  
    271271}//end function 

  • trunk/include/search_class.php

    r62 r68  
    404404        <span id="saveSearchT"><a href="" onClick="switchSearchTabs(this,'<?php echo $_SESSION["app_path"]?>');return false">save search</a></span> 
    405405        <span id="advancedSortT"><a href="" onClick="switchSearchTabs(this,'<?php echo $_SESSION["app_path"]?>');return false">sorting</a></span> 
    406 </div><div class="box" style="margin:0px;margin-bottom:15px;display:inline-block;"><div id="basicSearchTab" style="padding:0px;margin:0px;"> 
     406</div><div class="box" style="margin:0px;margin-bottom:15px;/* display:inline-block; */"><div id="basicSearchTab" style="padding:0px;margin:0px;"> 
    407407        <table cellpadding="0" cellspacing="0" border="0"> 
    408408                <tr> 
    …… 
    461461                                <option value="narrow" <?php if ($this->querytype=="search" and $this->savedselection=="narrow")echo "checked"?>>narrow result</option> 
    462462                        </select></label> 
    463                         <td align="left" valign=top nowrap ><label><input name="command" type="submit" id="reset" class="smallButtons" value="reset" style="width:90px;" accesskey="t" /></label></td> 
     463                        <td align="left" valign=top nowrap ><label><input name="command" type="submit" id="reset" class="smallButtons" value="reset" style="width:90px;" accesskey="t" title="(alt+t)"/></label></td> 
    464464                </tr>                            
    465465        </table> 
    466466</div><?PHP if($_SESSION["userinfo"]["accesslevel"]>=30){?><div id="advancedSearchTab" style="display:none;padding:0px;margin:0px;"></div><?php } //end accesslevel ?> 
    467467<div id="loadSearchTab" style="display:none;padding:0px;margin:0px;"></div> 
    468 <div id="saveSearchTab" style="display:none;margin:padding:0px;margin:0px;"> 
     468<div id="saveSearchTab" style="display:none;margin:0px;padding:0px;margin:0px;"> 
    469469        <div id="saveSearchReults" style="display:none"></div> 
    470470        <table cellpadding="0" cellspacing="0" border="0"> 
    …… 
    552552         
    553553                <div> 
    554                 <?php if ($this->tableoptions["new"]["allowed"] && $_SESSION["userinfo"]["accesslevel"]>=$this->tableoptions["new"]["accesslevel"]) {?><button type="button" accesskey="n" class="invisibleButtons" onClick="addRecord()"><img src="<?php echo $_SESSION["app_path"] ?>common/stylesheet/<?php echo $_SESSION["stylesheet"] ?>/button-new.png" alt="new" width="16" height="16" border="0" /></button><?php }  
     554                <?php if ($this->tableoptions["new"]["allowed"] && $_SESSION["userinfo"]["accesslevel"]>=$this->tableoptions["new"]["accesslevel"]) {?><button type="button" accesskey="n" class="invisibleButtons" onClick="addRecord()" title="new (alt+n)"><img src="<?php echo $_SESSION["app_path"] ?>common/stylesheet/<?php echo $_SESSION["stylesheet"] ?>/button-new.png" alt="new" width="16" height="16" border="0" /></button><?php }  
    555555                if($this->numrows) { 
    556556                        if ($this->tableoptions["edit"]["allowed"] && $_SESSION["userinfo"]["accesslevel"]>=$this->tableoptions["edit"]["accesslevel"]) { 
    557                                 ?><button id="edit" accesskey="e" type="button" disabled="true" class="invisibleButtons" onClick="editThis()"><img src="<?php echo $_SESSION["app_path"] ?>common/stylesheet/<?php echo $_SESSION["stylesheet"] ?>/button-edit-disabled.png" alt="edit" width="16" height="16" border="0" /></button><?php 
     557                                ?><button id="edit" accesskey="e" type="button" disabled="true" class="invisibleButtons" onClick="editThis()" title="edit (alt+e)"><img src="<?php echo $_SESSION["app_path"] ?>common/stylesheet/<?php echo $_SESSION["stylesheet"] ?>/button-edit-disabled.png" alt="edit" width="16" height="16" border="0" /></button><?php 
    558558                        } 
    559559                        if($this->tableoptions["printex"]["allowed"] && $_SESSION["userinfo"]["accesslevel"]>=$this->tableoptions["printex"]["accesslevel"]){ 
    560                                 ?><button id="print" name="doprint" accesskey="p" type="submit" disabled="true" class="invisibleButtons"><img src="<?php echo $_SESSION["app_path"] ?>common/stylesheet/<?php echo $_SESSION["stylesheet"] ?>/button-print-disabled.png"  alt="print" width="16" height="16" border="0" /></button><?php 
     560                                ?><button id="print" name="doprint" accesskey="p" title="print (alt+p)" type="submit" disabled="true" class="invisibleButtons"><img src="<?php echo $_SESSION["app_path"] ?>common/stylesheet/<?php echo $_SESSION["stylesheet"] ?>/button-print-disabled.png"  alt="print" width="16" height="16" border="0" /></button><?php 
    561561                        } 
    562562                        if($this->thetabledef["deletebutton"] == "delete") {                             
    563                                 ?><button id="delete" name="dodelete" accesskey="d" type="button" disabled="true" onClick="confirmDelete('delete')" class="invisibleButtons" style="border-style:solid"><img src="<?php echo $_SESSION["app_path"] ?>common/stylesheet/<?php echo $_SESSION["stylesheet"] ?>/button-delete-disabled.png" alt="print" width="16" height="16" border="0" /></button><?php 
     563                                ?><button id="delete" name="dodelete" accesskey="d" type="button" title="delete (alt+d)" disabled="true" onClick="confirmDelete('delete')" class="invisibleButtons" style="border-style:solid"><img src="<?php echo $_SESSION["app_path"] ?>common/stylesheet/<?php echo $_SESSION["stylesheet"] ?>/button-delete-disabled.png" alt="print" width="16" height="16" border="0" /></button><?php 
    564564                        } 
    565565         
    …… 
    579579                                ?></select><?php 
    580580                } 
    581                 if($this->tableoptions["select"]["allowed"] && $_SESSION["userinfo"]["accesslevel"]>=$this->tableoptions["select"]["accesslevel"]){?><select id="searchSelection" onChange="perfromToSelection(this)"> 
     581                if($this->tableoptions["select"]["allowed"] && $_SESSION["userinfo"]["accesslevel"]>=$this->tableoptions["select"]["accesslevel"]){?> <select id="searchSelection" onChange="perfromToSelection(this)"> 
    582582                                <option class="choiceListBlank" value="">selection...</option> 
    583583                                <option value="">_____________</option> 
    584                                 <option value="selectall">select all</option> 
    585                                 <option value="selectnone">select none</option> 
     584                                <option value="selectall" title="(alt+a)">select all</option> 
     585                                <option value="selectnone" title="(alt+x)">select none</option> 
    586586                                <option value="">_____________</option> 
    587                                 <option value="keepselected">keep selected</option> 
    588                                 <option value="omitselected">omit selected</option> 
     587                                <option value="keepselected" title="(alt+k)">keep selected</option> 
     588                                <option value="omitselected" title="(alt+o)" >omit selected</option> 
    589589                        </select><a href="" onClick="changeSelection('selectall');return false;" accesskey="a" tabindex="-1"></a><a href="" onClick="changeSelection('selectnone');return false;" accesskey="x" tabindex="-1"></a><a href="" onClick="changeSelection('keepselected');return false;" accesskey="k" tabindex="-1"></a><a href="" onClick="changeSelection('omitselected');return false;" accesskey="o" tabindex="-1"></a><?php }  
    590590                 

  • trunk/install/createtables.sql

    r67 r68  
    113113  KEY `tabledef` (`tabledefid`), 
    114114  KEY `displayorder` (`displayorder`) 
    115 ) TYPE=MyISAM; 
     115) TYPE=MyISAM AUTO_INCREMENT=5000; 
    116116 
    117117CREATE TABLE `tabledefs` (   
    …… 
    146146  PRIMARY KEY  (id), 
    147147  KEY tabledef (tabledefid) 
    148 ) TYPE=MyISAM; 
     148) TYPE=MyISAM AUTO_INCREMENT=2000;  
    149149 
    150150CREATE TABLE tableoptions ( 
    …… 
    157157  PRIMARY KEY  (id), 
    158158  KEY tabledef (tabledefid) 
    159 ) TYPE=MyISAM; 
     159) TYPE=MyISAM AUTO_INCREMENT=2000;  
    160160 
    161161CREATE TABLE tablesearchablefields ( 
    …… 
    167167  type varchar(16) NOT NULL default 'field', 
    168168  PRIMARY KEY  (id) 
    169 ) TYPE=MyISAM; 
     169) TYPE=MyISAM AUTO_INCREMENT=2000; 
    170170 
    171171CREATE TABLE users ( 
    …… 
    209209  `value` varchar(255) default '', 
    210210  PRIMARY KEY  (`id`) 
    211 ) TYPE=MyISAM;  
     211) TYPE=MyISAM AUTO_INCREMENT=1000; 
    212212 
    213213CREATE TABLE `files` ( 
    …… 
    223223  `accesslevel` int(11) NOT NULL default '0', 
    224224  PRIMARY KEY  (`id`) 
    225 ) TYPE=MyISAM;  
     225) TYPE=MyISAM AUTO_INCREMENT=100;  
    226226 
    227227CREATE TABLE `attachments` ( 

  • trunk/modules/bms/products_addedit.php

    r64 r68  
    7272                                <?PHP field_checkbox("inactive",$therecord["inactive"],false,array("tabindex"=>"50"))?> inactive 
    7373                        </label> 
    74                         <label for="inactive"></label> 
     74                        <label for="taxable"> 
    7575                                <?PHP field_checkbox("taxable",$therecord["taxable"],false,array("tabindex"=>"60"))?> taxable 
    7676                        </label> 

  • trunk/print.php

    r60 r68  
    220220        <fieldset class="small"> 
    221221                <legend>Notes</legend> 
    222                 <div> 
     222                <div class="notes"> 
    223223                        <strong>Window Pop-ups<br/></strong>Each report will display in its own window. If you have disabled 
    224224                        pop-ups within your browser's options or are running a third-party pop-up blocker, the report will not appear. 
    225225                </div> 
    226                 <div><strong>Need More Reports?</strong><br/> 
     226                <div class="notes"><strong>Need More Reports?</strong><br/> 
    227227                Need more reports, or want to cuztomize an existing report to meet your specific needs?  Contact <a href="http://www.kreotek.com" target="_blank">kreotek</a> for more information. 
    228228                </div> 
Copyright © 2006-2007 Kreotek, LLC. All Rights reserved.