phpBMS

Changeset 643

Show
Ignore:
Timestamp:
09/02/09 14:00:56 (3 years ago)
Author:
nate
Message:
  • Applied patch found in ticket [352] that fixes a bug in post.php in an incorrect table join ( it now correctly joins on the uuid instead of the id).
  • Applied patch found in ticket [354] ( with a minor tweak ) that fixes many spelling errors.
Location:
trunk/phpbms
Files:
29 modified

Legend:

Unmodified
Added
Removed

  • trunk/phpbms/common/javascript/fields.js

    r510 r643  
    4949 
    5050        //need to itterate though all fields... if you find 
    51         // --not found-- anywhere.... invlaidate the form 
     51        // --not found-- anywhere.... invalidate the form 
    5252        for(i=0;i<theform.length;i++){ 
    5353                if(theform[i].value && theform[i].value=="--not found--"){ 

  • trunk/phpbms/common/javascript/queryfunctions.js

    r559 r643  
    322322} 
    323323 
    324 // Pass the Sort Parameters and subit the form 
     324// Pass the Sort Parameters and submit the form 
    325325function doSort(i){ 
    326326        var theform=document.forms["search"]; 
    … …  
    330330} 
    331331 
    332 // Pass the Sort Parameters and subit the form 
     332// Pass the Sort Parameters and submit the form 
    333333function doDescSort(){ 
    334334        theform=document.forms["search"]; 
    … …  
    364364 
    365365 
    366 function perfromToSelection(option){ 
     366function performToSelection(option){ 
    367367 
    368368        var thereset=getObjectFromID("reset"); 
    … …  
    582582        var searchname=getObjectFromID("LSSelectedSearch"); 
    583583        var sqlbox=getObjectFromID("LSSQL"); 
    584         var reultbox=getObjectFromID("LSResults"); 
     584        var resultbox=getObjectFromID("LSResults"); 
    585585        if (theselect.value=="NA"){ 
    586586                loadbutton.disabled=true; 
    … …  
    589589                sqlbox.value=""; 
    590590        } else { 
    591                 reultbox.innerHTML="<img src=\""+base+"common/image/spinner.gif\" alt=\"0\" width=\"16\" height=\"16\" align=\"absmiddle\"> <strong>Loading...</strong>"; 
     591                resultbox.innerHTML="<img src=\""+base+"common/image/spinner.gif\" alt=\"0\" width=\"16\" height=\"16\" align=\"absmiddle\"> <strong>Loading...</strong>"; 
    592592                var theURL=base+"loadsearch.php?cmd=getsearch&id="+theselect.value; 
    593593                loadXMLDoc(theURL,null,false); 
    … …  
    603603                else 
    604604                        deletebutton.disabled=true; 
    605                 reultbox.innerHTML=""; 
     605                resultbox.innerHTML=""; 
    606606        } 
    607607} 
    … …  
    615615function LSDeleteSearch(base){ 
    616616        var theselect=getObjectFromID("LSList"); 
    617         var reultbox=getObjectFromID("LSResults"); 
    618  
    619         reultbox.innerHTML="<img src=\""+base+"common/image/spinner.gif\" alt=\"0\" width=\"16\" height=\"16\" align=\"absmiddle\"> <strong>Loading...</strong>"; 
     617        var resultbox=getObjectFromID("LSResults"); 
     618 
     619        resultbox.innerHTML="<img src=\""+base+"common/image/spinner.gif\" alt=\"0\" width=\"16\" height=\"16\" align=\"absmiddle\"> <strong>Loading...</strong>"; 
    620620        var theURL=base+"loadsearch.php?cmd=deletesearch&id="+theselect.value; 
    621621        loadXMLDoc(theURL,null,false); 
    622622        if(req.responseText=="success"){ 
    623                 reultbox.innerHTML=""; 
     623                resultbox.innerHTML=""; 
    624624                theselect.options[theselect.selectedIndex]=null; 
    625625                if(theselect.options.length==1){ 

  • trunk/phpbms/common/javascript/smartsearch.js

    r493 r643  
    6868 
    6969                } else { 
    70                         //it's possible they hit the down, up arrow, or the return button 
     70                        //it is possible they hit the down, up arrow, or the return button 
    7171 
    7272                        var key = e.event().keyCode; 

  • trunk/phpbms/dbgraphic.php

    r285 r643  
    1 <?php  
     1<?php 
    22/* 
    33 $Rev$ | $LastChangedBy$ 
    … …  
    3939        session_cache_limiter('private'); 
    4040        require_once("include/session.php"); 
    41          
    42         if(!isset($_GET["t"]) or !isset($_GET["r"]) or !isset($_GET["f"]) or !isset($_GET["mf"])) die("Invlaid Paramateers Set"); 
    43          
     41 
     42        if(!isset($_GET["t"]) or !isset($_GET["r"]) or !isset($_GET["f"]) or !isset($_GET["mf"])) die("Invalid Parameters Set"); 
     43 
    4444        $querystatement="SELECT ".$_GET["f"].",".$_GET["mf"]." FROM ".$_GET["t"]." WHERE id=".$_GET["r"]; 
    4545        $queryresult=$db->query($querystatement); 
    … …  
    4848                $therecord=$db->fetchArray($queryresult); 
    4949                header('Content-type: '.$therecord[$_GET["mf"]]); 
    50          
     50 
    5151                echo $therecord[$_GET["f"]]; 
    5252        } 

  • trunk/phpbms/include/fields.php

    r622 r643  
    171171                    $this->fields[$fieldname]->display(); 
    172172                else 
    173                     echo "Error in form contruction (wrong object): ".$fieldname; 
     173                    echo "Error in form construction (wrong object): ".$fieldname; 
    174174 
    175175            } else 
    176                 echo "Error in form contruction: ".$fieldname; 
     176                echo "Error in form construction: ".$fieldname; 
    177177 
    178178        }else 

  • trunk/phpbms/include/print_class.php

    r575 r643  
    6363                                "; 
    6464                        $queryresult = $this->db->query($querystatement); 
    65                         if(!$queryresult) $error = new appError(500,"Error retreving table info."); 
     65                        if(!$queryresult) $error = new appError(500,"Error retrieving table info."); 
    6666                        $therecord = $this->db->fetchArray($queryresult); 
    6767                        $this->maintable = $therecord["maintable"]; 
    … …  
    9999 
    100100                        $queryresult = $this->db->query($querystatement); 
    101                         if(!$queryresult) $error = new appError(500,"Error retreving reports."); 
     101                        if(!$queryresult) $error = new appError(500,"Error retrieving reports."); 
    102102                        $this->reports = $queryresult; 
    103103 

  • trunk/phpbms/include/search_class.php

    r621 r643  
    882882                                                        <div id="searchSelectionDropDown" class="toolbarDropDowns" style="display:none"> 
    883883                                                        <ul> 
    884                                                                 <li><a href="#" onclick="perfromToSelection('selectall');return false;" accesskey="a" title="select all (alt + a)">select all</a></li> 
    885                                                                 <li><a href="#" onclick="perfromToSelection('selectnone');return false;" accesskey="x" title="select none (alt + x)">select none</a></li> 
    886                                                                 <li class="menuSep"><a href="#" onclick="perfromToSelection('keepselected');return false;" accesskey="k" title="keep selected (alt + k)">show only selected records</a></li> 
    887                                                                 <li><a href="#" onclick="perfromToSelection('omitselected');return false;" accesskey="o" title="omit selected (alt + o)">remove selected records from view</a></li> 
     884                                                                <li><a href="#" onclick="performToSelection('selectall');return false;" accesskey="a" title="select all (alt + a)">select all</a></li> 
     885                                                                <li><a href="#" onclick="performToSelection('selectnone');return false;" accesskey="x" title="select none (alt + x)">select none</a></li> 
     886                                                                <li class="menuSep"><a href="#" onclick="performToSelection('keepselected');return false;" accesskey="k" title="keep selected (alt + k)">show only selected records</a></li> 
     887                                                                <li><a href="#" onclick="performToSelection('omitselected');return false;" accesskey="o" title="omit selected (alt + o)">remove selected records from view</a></li> 
    888888                                                        </ul> 
    889889                                                        </div> 
    … …  
    10991099                function resetQuery(){ 
    11001100                        // reset query... this requires a call to the function that should be 
    1101                         // defined in the same place the table paramaters are. 
     1101                        // defined in the same place the table parameters are. 
    11021102                        //===================================================================================================== 
    11031103                        $this->querytype="search"; 
    … …  
    12371237                                        $endmessage=" deleted"; 
    12381238                        } 
    1239                          
     1239 
    12401240                        $queryresult = $this->db->query($querystatement); 
    12411241                        $message = $this->buildStatusMessage().$endmessage; 

  • trunk/phpbms/include/tables.php

    r639 r643  
    526526            if(isset($variables["id"])) 
    527527                if(!is_numeric($variables["id"]) && $variables["id"]) 
    528                     $this->verifyErrors[] = "The `id` field must be numeric or equivalent to zero (although positive is reccomended)."; 
     528                    $this->verifyErrors[] = "The `id` field must be numeric or equivalent to zero (although positive is recommended)."; 
    529529 
    530530            if(isset($variables["uuid"])) 

  • trunk/phpbms/install/choices.sql

    r215 r643  
    33INSERT INTO choices VALUES (3,'department',''); 
    44INSERT INTO choices VALUES (4,'notestatus','cancelled'); 
    5 INSERT INTO choices VALUES (5,'notestatus','tenative'); 
     5INSERT INTO choices VALUES (5,'notestatus','tentative'); 
    66INSERT INTO choices VALUES (6,'notestatus','confirmed'); 
    77INSERT INTO choices VALUES (7,'notestatus',''); 

  • trunk/phpbms/install/reports.sql

    r613 r643  
    1 INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:37cee478-b57e-2d53-d951-baf3937ba9e0', 'Raw Table Print', 'report', '', '0', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', 'report/general_tableprint.php', 'This report will prints out of every field for the table for the given records.  The report is displayed HTML format.', 1, NOW(), 1, NOW()); 
     1INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:37cee478-b57e-2d53-d951-baf3937ba9e0', 'Raw Table Print', 'report', '', '0', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', 'report/general_tableprint.php', 'This report will print out of every field for the table for the given records.  The report is displayed in HTML format.', 1, NOW(), 1, NOW()); 
    22INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:dac75fb9-91d2-cb1e-9213-9fab6d32f4c8', 'Raw Table Export', 'export', '', '0', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', 'report/general_export.php', 'This report will generate a comma-delimited text file. Values are encapsulated in quotes, and the first line lists the field names.', 1, NOW(), 1, NOW()); 
    3 INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:a6999cc3-59bb-6af3-460e-d5d791afb842', 'Note Summary', 'PDF Report', 'tbld:a4cdd991-cf0a-916f-1240-49428ea1bdd1', '50', '', 'modules/base/report/notes_summary.php', 'PDF report giving basic note information (subject,dates,content) .  By deault, the notes are shown in chronological order.', 1, NOW(), 1, NOW()); 
     3INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:a6999cc3-59bb-6af3-460e-d5d791afb842', 'Note Summary', 'PDF Report', 'tbld:a4cdd991-cf0a-916f-1240-49428ea1bdd1', '50', '', 'modules/base/report/notes_summary.php', 'PDF report giving basic note information (subject,dates,content) .  By default, the notes are shown in chronological order.', 1, NOW(), 1, NOW()); 
    44INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:2944b204-5967-348a-8679-6835f45f0d79', 'SQL Export', 'export', '', '0', 'Admin', 'report/general_sql.php', 'Generate SQL INSERT statements for records.', 1, NOW(), 1, NOW()); 
    55INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:37a299d1-d795-ad83-4b47-0778c16a381c', 'Support Tables SQL Export', 'export', 'tbld:5c9d645f-26ab-5003-b98e-89e9049f8ac3', '0', '', 'modules/base/report/tabledefs_sqlexport.php', 'Insert statements for all support table records for table definition records.', 1, NOW(), 1, NOW()); 

  • trunk/phpbms/modules/base/adminsettings.php

    r631 r643  
    197197 
    198198                    <p class="notes"> 
    199                         <strong>Example:</strong> Replace this with your comapny name + BMS (e.g. "Kreotek BMS").  Replacing 
     199                        <strong>Example:</strong> Replace this with your company name + BMS (e.g. "Kreotek BMS").  Replacing 
    200200                        the application name will reset the session cookie, and require you to log in again. 
    201201                    </p> 

  • trunk/phpbms/modules/base/javascript/notes.js

    r495 r643  
    270270                var i; 
    271271 
    272                 //first let's set the eachlist if necassary 
     272                //first let us set the eachlist if necessary 
    273273                switch(typeSelect.value){ 
    274274                        case "Weekly": 
    … …  
    322322                content +='<p align="right"><input type="button" class="Buttons" value="continue save" onclick="continueSubmit()" > <input type="button" class="Buttons" value="cancel" onclick="closeModal()" style="width:70px"></p>'; 
    323323 
    324                 showModal(content,"Confrim Change of Repeatable Task",400); 
     324                showModal(content,"Confirm Change of Repeatable Task",400); 
    325325                return false; 
    326326        }else 

  • trunk/phpbms/modules/base/javascript/snapshot.js

    r495 r643  
    8989        var widget = getObjectFromID(uuid); 
    9090 
    91         //need to get widget's name 
     91        //need to get the name of the widget 
    9292        var widgetTitle = ""; 
    9393 

  • trunk/phpbms/modules/base/report/notes_summary.php

    r285 r643  
    4141        //turn debug borders on to troubleshoot PDF creation (1 or 0) 
    4242        $border_debug=0; 
    43          
     43 
    4444        require("../../../fpdf/fpdf.php"); 
    45          
     45 
    4646        if($_SESSION["printing"]["sortorder"]) 
    4747                $sortorder=$_SESSION["printing"]["sortorder"]; 
    … …  
    5151        //Generate the notes Query 
    5252        $querystatement="SELECT users.firstname, users.lastname, notes.id, notes.creationdate, 
    53                                                 notes.subject,notes.content  
     53                                                notes.subject,notes.content 
    5454                                                FROM notes INNER JOIN users on notes.createdby=users.id ".$_SESSION["printing"]["whereclause"].$sortorder; 
    5555        $thequery=$db->query($querystatement); 
    56         if(!$thequery) die("No records, or invlaid SQL statement:<br />".$querystatement); 
     56        if(!$thequery) die("No records, or invalid SQL statement:<br />".$querystatement); 
    5757        //=================================================================================================== 
    5858        // Generating PDF File. 
    5959        //=================================================================================================== 
    60          
     60 
    6161        $leftmargin=.5; 
    6262        $rightmargin=.5; 
    … …  
    6464        $paperwidth=8.5; 
    6565        $paperlength=11; 
    66          
     66 
    6767        //define the documents and margins 
    6868        $pdf=new FPDF("P","in","Letter"); 
    6969        $pdf->SetMargins($leftmargin,$topmargin,$rightmargin); 
    7070        $pdf->Open(); 
    71          
     71 
    7272        $pdf->AddPage(); 
    73          
     73 
    7474        $tempwidth=$paperwidth-$leftmargin-$rightmargin; 
    7575        $tempheight=.25; 
    7676        $pdf->SetXY($leftmargin,$topmargin); 
    77          
     77 
    7878        //Report Title 
    7979        $pdf->SetFont("Arial","B",16); 
    … …  
    8383        $pdf->SetLineWidth(.04); 
    8484        $pdf->Line($leftmargin,$pdf->GetY(),$paperwidth-$rightmargin,$pdf->GetY()); 
    85          
     85 
    8686        $pdf->SetY($topmargin+.43+.1); 
    8787        $pdf->SetLineWidth(.01); 

  • trunk/phpbms/modules/base/smartsearches_addedit.php

    r574 r643  
    110110        <div id="rightSideDiv"> 
    111111                <fieldset> 
    112                         <legend>attribues</legend> 
     112                        <legend>attributes</legend> 
    113113                        <p><?php $theform->showField("moduleid");?></p> 
    114114                        <p><?php $theform->showField("tabledefid");?></p> 

  • trunk/phpbms/modules/bms/aritems_view.php

    r609 r643  
    117117        <div id="rightSideDiv"> 
    118118                <fieldset id="fsAttributes"> 
    119                         <legend>attribues</legend> 
     119                        <legend>attributes</legend> 
    120120 
    121121                        <p><?php $theform->showField("theid")?></p> 

  • trunk/phpbms/modules/bms/include/post.php

    r501 r643  
    102102                    tabledefs.maintable 
    103103                FROM 
    104                     tabledefs INNER JOIN modules ON tabledefs.moduleid = modules.id 
     104                    tabledefs INNER JOIN modules ON tabledefs.moduleid = modules.uuid 
    105105                WHERE 
    106106                    tabledefs.canpost = 1"; 

  • trunk/phpbms/modules/bms/install/modules.sql

    r613 r643  
    1 INSERT INTO modules (`uuid`, `displayname`, `name`, `description`, `version`) VALUES ('mod:0aa9cca0-7388-0eae-81b9-9935f9d127cc', 'BMS Module','bms','The Business Magagement functionality of phpBMS.  This module includes clients/propsetcs, quote/order/invoice, and products sections.','0.98'); 
     1INSERT INTO modules (`uuid`, `displayname`, `name`, `description`, `version`) VALUES ('mod:0aa9cca0-7388-0eae-81b9-9935f9d127cc', 'BMS Module','bms','The Business Management functionality of phpBMS.  This module includes clients/prospetcs, quote/order/invoice, and products sections.','0.98'); 

  • trunk/phpbms/modules/bms/install/reports.sql

    r615 r643  
    1 INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:bac1d6eb-b2bb-9aa0-77c0-ff7f9046ca75', 'Invoice', 'PDF Report', 'tbld:62fe599d-c18f-3674-9e54-b62c2d6b1883', '100', '', 'modules/bms/report/invoices_pdfinvoice.php', 'This report will gerneate and display an invoice in PDF format (which can be printed or saved).  The PDF file will contain one page per invoice.', 1, NOW(), 1, NOW()); 
    2 INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:a34dd4b5-6942-2b14-4a58-74345dce48de', 'Work Order', 'PDF Report', 'tbld:62fe599d-c18f-3674-9e54-b62c2d6b1883', '100', 'role:de7e6679-8bb2-29ee-4883-2fcd756fb120', 'modules/bms/report/invoices_pdfworkorder.php', 'This report will gerneate and display a work order in PDF format (which can be printed or saved).  The PDF file will contain one page per work order.', 1, NOW(), 1, NOW()); 
    3 INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:34a69580-6fbc-d04c-ed3e-f0e497a9a9b2', 'Packing List', 'PDF Report', 'tbld:62fe599d-c18f-3674-9e54-b62c2d6b1883', '100', '', 'modules/bms/report/invoices_pdfpackinglist.php', 'This report will gerneate and display an invoice packing list in PDF format (which can be printed or saved).  The PDF file will contain one page per invoice packing list.', 1, NOW(), 1, NOW()); 
     1INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:bac1d6eb-b2bb-9aa0-77c0-ff7f9046ca75', 'Invoice', 'PDF Report', 'tbld:62fe599d-c18f-3674-9e54-b62c2d6b1883', '100', '', 'modules/bms/report/invoices_pdfinvoice.php', 'This report will generate and display an invoice in PDF format (which can be printed or saved).  The PDF file will contain one page per invoice.', 1, NOW(), 1, NOW()); 
     2INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:a34dd4b5-6942-2b14-4a58-74345dce48de', 'Work Order', 'PDF Report', 'tbld:62fe599d-c18f-3674-9e54-b62c2d6b1883', '100', 'role:de7e6679-8bb2-29ee-4883-2fcd756fb120', 'modules/bms/report/invoices_pdfworkorder.php', 'This report will generate and display a work order in PDF format (which can be printed or saved).  The PDF file will contain one page per work order.', 1, NOW(), 1, NOW()); 
     3INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:34a69580-6fbc-d04c-ed3e-f0e497a9a9b2', 'Packing List', 'PDF Report', 'tbld:62fe599d-c18f-3674-9e54-b62c2d6b1883', '100', '', 'modules/bms/report/invoices_pdfpackinglist.php', 'This report will generate and display an invoice packing list in PDF format (which can be printed or saved).  The PDF file will contain one page per invoice packing list.', 1, NOW(), 1, NOW()); 
    44INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:07f58303-d6e9-a032-01ad-0097d59b3c04', 'Labels - Folder', 'PDF Report', 'tbld:6d290174-8b73-e199-fe6c-bcf3d4b61083', '50', '', 'modules/bms/report/clients_folderlabels.php', 'Avery 5160 or compatible (3x10) Instructor Folder labels. \r\n\r\n **MAKE SURE when printing the pdf file, to TURN OFF the option \"shrink oversized pages to paper size\".**', 1, NOW(), 1, NOW()); 
    55INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:030e7d95-4542-b37c-3cac-a18ff5f4b8ff', 'Labels - Mailing', 'PDF Report', 'tbld:6d290174-8b73-e199-fe6c-bcf3d4b61083', '50', '', 'modules/bms/report/clients_mailinglabels.php', 'Avery 5160 or compatible (3x10) Instructor Folder labels. \r\n\r\n **MAKE SURE when printing the pdf file, to TURN OFF the option \"shrink oversized pages to paper size\".**', 1, NOW(), 1, NOW()); 
    … …  
    1616INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:a278af28-9c34-da2e-d81b-4caa36dfa29f', 'Sales History', 'report', 'tbld:7a9e87ed-d165-c4a4-d9b9-0a4adc3c5a34', '100', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', 'modules/bms/report/products_saleshistory.php', 'Sales History for product including costs, average price and quantities.', 1, NOW(), 1, NOW()); 
    1717INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:1908b03c-cacc-f03a-6d22-21fdef123f65', 'Purchase History', 'report', 'tbld:6d290174-8b73-e199-fe6c-bcf3d4b61083', '10', '', 'modules/bms/report/clients_purchasehistory.php', 'Client purchase history', 1, NOW(), 1, NOW()); 
    18 INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:858702da-1b85-3a62-c20f-6b1593140a64', 'Totals - Custom', 'report', 'tbld:31423480-a9b0-f0ff-749e-b3b5e18ca93c', '50', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', 'modules/bms/report/lineitems_totals.php', 'Creat your own custom line item  totaling report, specify groupings, totals, averages and whether to display summary, invoice, and invoice detail information.', 1, NOW(), 1, NOW()); 
     18INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:858702da-1b85-3a62-c20f-6b1593140a64', 'Totals - Custom', 'report', 'tbld:31423480-a9b0-f0ff-749e-b3b5e18ca93c', '50', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', 'modules/bms/report/lineitems_totals.php', 'Create your own custom line item  totaling report, specify groupings, totals, averages and whether to display summary, invoice, and invoice detail information.', 1, NOW(), 1, NOW()); 
    1919INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:28cf69cb-60de-bbed-df15-ea98842b6924', 'Totals - Product Categories', 'report', 'tbld:31423480-a9b0-f0ff-749e-b3b5e18ca93c', '50', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', 'modules/bms/report/lineitems_totals_productcategories.php', 'Totals report grouped first by product category and then by product.', 1, NOW(), 1, NOW()); 
    2020INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:274d3dfa-ec52-74d2-630f-0c432a6e1ea5', 'Totals - Product', 'report', 'tbld:31423480-a9b0-f0ff-749e-b3b5e18ca93c', '50', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', 'modules/bms/report/lineitems_totals_products.php', 'Totals report grouped by product displaying line items', 1, NOW(), 1, NOW()); 
    2121INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:68b6258a-6902-f705-19f5-d2707bd78b35', 'Totals - Lead Source', 'report', 'tbld:31423480-a9b0-f0ff-749e-b3b5e18ca93c', '50', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', 'modules/bms/report/lineitems_totals_leadsource.php', 'Totals grouped by invoice lead source and product', 1, NOW(), 1, NOW()); 
    22 INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:b552c34f-64b9-5a89-15b3-c5d717644b81', 'Client Notes Summary', 'PDF Report', 'tbld:6d290174-8b73-e199-fe6c-bcf3d4b61083', '10', '', 'modules/bms/report/clients_notesummary.php', 'Print all notes associated with he client and any notes associated with client invoices.', 1, NOW(), 1, NOW()); 
     22INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:b552c34f-64b9-5a89-15b3-c5d717644b81', 'Client Notes Summary', 'PDF Report', 'tbld:6d290174-8b73-e199-fe6c-bcf3d4b61083', '10', '', 'modules/bms/report/clients_notesummary.php', 'Print all notes associated with the client and any notes associated with client invoices.', 1, NOW(), 1, NOW()); 
    2323INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:aca42dbe-68c9-e966-c174-ed938e9b880a', 'Totals - Tax', 'report', 'tbld:62fe599d-c18f-3674-9e54-b62c2d6b1883', '50', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', 'modules/bms/report/invoices_totals_tax.php', 'Tax Totals', 1, NOW(), 1, NOW()); 
    2424INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:e54cee32-b3c9-82cc-50c8-14848ece8e90', 'Receipt', 'PDF Report', 'tbld:43678406-be25-909b-c715-7e2afc7db601', '10', 'role:c9439c3c-499b-7bcc-ee14-fec5bfcf5fc2', 'modules/bms/report/receipts_pdf.php', 'PDF print out of receipt for processing or client records', 1, NOW(), 1, NOW()); 

  • trunk/phpbms/modules/bms/invoicestatuses_addedit.php

    r621 r643  
    8888 
    8989        <fieldset id="fsAttributes"> 
    90                 <legend>attribues</legend> 
     90                <legend>attributes</legend> 
    9191 
    9292                <p><br /><?php $theform->showField("inactive")?></p> 

  • trunk/phpbms/modules/bms/invoices_discount_ajax.php

    r592 r643  
    4040        require("../../include/session.php"); 
    4141 
    42         if(!isset($_GET["id"])) $error = new appError(300,"Passed veriable not set (id)"); 
     42        if(!isset($_GET["id"])) $error = new appError(300,"Passed variable not set (id)"); 
    4343 
    4444        $querystatement = " 

  • trunk/phpbms/modules/bms/javascript/invoice.js

    r638 r643  
    14341434 
    14351435                case "receivable": 
    1436                         //first let's check to make sure they can charge to AR 
     1436                        //first let us check to make sure they can charge to AR 
    14371437                        var hascredit = getObjectFromID("hascredit"); 
    14381438                        var creditleft = getObjectFromID("creditleft"); 
    … …  
    14461446 
    14471447                        if(hascredit.value == 0 && error == "" && type.value != "Invoice" && type.value != "VOID") 
    1448                                 error = "This client is not currenlty set up with a line of credit."; 
     1448                                error = "This client is not currently set up with a line of credit."; 
    14491449 
    14501450                        if(currencyToNumber(creditleft.value) < currencyToNumber(totalti.value) && error == "" && type.value != "Invoice" && type.value != "VOID") 

  • trunk/phpbms/modules/bms/paymentmethods_addedit.php

    r575 r643  
    8282 
    8383        <fieldset id="fsAttributes"> 
    84                 <legend>attribues</legend> 
     84                <legend>attributes</legend> 
    8585 
    8686                <p><br /><?php $theform->showField("inactive")?></p> 

  • trunk/phpbms/modules/bms/tax_addedit.php

    r575 r643  
    7878 
    7979        <fieldset id="fsAttributes"> 
    80                 <legend>attribues</legend> 
     80                <legend>attributes</legend> 
    8181                <p><br /><?php $theform->showField("inactive");?></p> 
    8282        </fieldset> 

  • trunk/phpbms/modules/recurringinvoices/javascript/recurringinvoices.js

    r627 r643  
    207207        var i; 
    208208 
    209         //first let's set the eachlist if necassary 
     209        //first let us set the eachlist if necessary 
    210210        switch(typeSelect.value){ 
    211211                case "Weekly": 

  • trunk/phpbms/modules/sample/sampletable_addedit.php

    r541 r643  
    153153 
    154154        <fieldset id="fsAttributes"> 
    155                 <legend>attribues</legend> 
     155                <legend>attributes</legend> 
    156156                <p> 
    157157                        <label for="id">id</label><br /> 

  • trunk/phpbms/phpbmsversion.php

    r485 r643  
    22 
    33        $modules["base"]["name"] = "phpBMS base"; 
    4          
     4 
    55        $modules["base"]["version"] = 0.98; 
    6          
    7         $modules["base"]["description"] =  
    8         "The basic phpBMS framkework.  This is the minimum module required in order for the web applicatoin to work."; 
    9          
     6 
     7        $modules["base"]["description"] = 
     8        "The basic phpBMS framework.  This is the minimum module required in order for the web application to work."; 
     9 
    1010        $modules["base"]["requirements"] = ""; 
    1111 

  • trunk/phpbms/print.php

    r607 r643  
    105105                                                $querystatement="SELECT reportfile,type from reports where id=".$_POST["choosereport"][$i].";"; 
    106106                                                $queryresult=$db->query($querystatement); 
    107                                                 if(!$queryresult) $error = new appError(100,"Could not Retreive Report Information"); 
     107                                                if(!$queryresult) $error = new appError(100,"Could not Retrieve Report Information"); 
    108108                                                $reportrecord=$db->fetchArray($queryresult); 
    109109                                                $fakeExtForIE=""; 
    … …  
    227227                </fieldset> 
    228228                <fieldset> 
    229                         <legend>customizng reports</legend> 
     229                        <legend>customizing reports</legend> 
    230230                        <p class="notes"> 
    231                         Many reports feature a logo and your company infromation.  This information can be set administratively in the configuration area 
     231                        Many reports feature a logo and your company information.  This information can be set administratively in the configuration area 
    232232                        </p> 
    233233                        <p class="notes"> 
    234                         Need more reports, or want to cuztomize an existing report to meet your specific needs? <br /> 
     234                        Need more reports, or want to customize an existing report to meet your specific needs? <br /> 
    235235                        if you are unfamiliar with PHP, or programming phpBMS, you can try visiting the 
    236236                        <a href="http://www.phpbms.org">phpBMS project site</a>, or visit <a href="http://kreotek.com">Kreotek's website</a> for more information. 

  • trunk/phpbms/report/general_labels.php

    r605 r643  
    6666                $reportquerystatement.=$_SESSION["printing"]["whereclause"].$sortorder; 
    6767                $thequery=$db->query($reportquerystatement); 
    68                 if(!$thequery) die("No records, or invlaid SQL statement:<br />".$reportquerystatement); 
     68                if(!$thequery) die("No records, or invalid SQL statement:<br />".$reportquerystatement); 
    6969                //=================================================================================================== 
    7070                // Generating PDF File. 
phpBMS vulnerability assesment provided by Orvant Inc. Copyright © 2010 Kreotek, LLC. All Rights reserved.