Changeset 693 for trunk/phpbms/include

Timestamp:

12/31/09 13:36:45 (2 years ago)

Author:

brieb

Message:

• Introduced administratively changeable settings to indvidual reports
• Modified all reports to work with new settings system
• Altered invoice and line item total reports to accept parameters from reportsettings: You can now bypass the grouping/column dialog by providing the infrmation administratively
• Altered all sales order PDF reports to accept parameters from reportsettings: You can now administratively change certain aspects of the print outs, including what parts of the top of the report to show, and what to title the report
• Altered label reports to accept parameters from reportsettings: printed data as well

as label measurements and layout are now defined by administratively

• Altered export and tableprint reports to accept parameters from reportsettings: You can specify individual columns and from table instead of just the defaults (all fields, main table only)
• Added var_dump-esque 'debug' function for development purposes to common functions
• Integrated FPDI functionality with sales order PDF reports: It is now possible to use a PDF saved in the files table as a background template for your invoices (e.g. watermarks)

Files:

• trunk/phpbms/include/common_functions.php (modified) (17 diffs)

trunk/phpbms/include/common_functions.php

@@ -549 +549 @@
 /**
   *  function makeDelimeterString
-  *  
+  *
   *  Creates a string with the same length as $string, with a delimeter where
   *  the corresponding part of the string is on or within that delimeter, and
@@ -565 +565 @@
   */
 function makeDelimeterString($string, $delimeters, $escapeCharacter = "\\"){
-        
+
         if(!$escapeCharacter)
                 $escapeCharacter = NULL;
-        
+
         if(strlen($escapeCharacter) > 1)
                 return false;
-        
+
         $returnString = "";
         $stringArray = str_split($string);
@@ -577 +577 @@
         $prevChar = "";
         foreach($stringArray as $char){
-                
+
                 if(!$inside){
                         if(in_array($char, $delimeters) && $prevChar != $escapeCharacter){
@@ -586 +586 @@
                                 $returnString .= "0";
                 }else{
-                        
+
                         if($char == $delimeter && $prevChar != $escapeCharacter){
                                 $inside = false;
@@ -592 +592 @@
                         }else
                                 $returnString .= $delimeter;
-                        
+
                 }//end if
-                
+
                 $prevChar = $char;
-                
+
         }//end foreach
-        
+
         return $returnString;
 
 }//end function
+
 
 /*
@@ -607 +608 @@
  * Returns the part of $querystatement from the general FROM to its ORDER BY or
  * the end of the querystatement if no ORDER BY exists.
- * 
+ *
  * @param $querystatement
  * @return string The part of $querystatement from the general FROM to its
  * ORDER BY.
  */
-
 function getSearchFrom($querystatement) {
-        
+
         $modstatement = $querystatement;
         $insideString = makeDelimeterString($querystatement, array("'", "\"", "`"));
         $insideArray = str_split($insideString);
-        
-        
+
+
         /**
           *  Check for SELECTs that are not inside quotes or tics.
@@ -628 +628 @@
         $offset = 0;
         do{
-                
+
                 $pos = stripos($querystatement, "select", $offset);
-                
+
                 if($pos !== false)
                         if(!$insideArray[$pos])
                                 $selectArray[] = $pos;
                 $offset = $pos+1;
-        
+
         }while($pos !== false);
-        
+
         /**
           *  Check for FROMSs that are not inside quotes or tics.
@@ -646 +646 @@
         $offset = 0;
         do{
-                
+
                 $pos = stripos($querystatement, "from", $offset);
-                
+
                 if($pos !== false)
                         if(!$insideArray[$pos])
                                 $fromArray[] = $pos;
                 $offset = $pos+1;
-        
+
         }while($pos !== false);
-        
+
         /**
           *  Check for ORDER BYs that are not inside quotes or tics.
@@ -664 +664 @@
         $offset = 0;
         do{
-                
+
                 $pos = stripos($querystatement, "order by", $offset);
-                
+
                 if($pos !== false)
                         if(!$insideArray[$pos])
                                 $orderArray[] = $pos;
                 $offset = $pos+1;
-        
+
         }while($pos !== false);
-        
-        
+
+
         /**
-          *  Pair the SELECTs with their appropriate FROMs 
+          *  Pair the SELECTs with their appropriate FROMs
           */
         $godArray = array();
@@ -682 +682 @@
         $j = 0;
         foreach($fromArray as $fromPos){
-                
+
                 $closest = 0;
                 $index = 0;
@@ -690 +690 @@
                                 $index = $i;
                         }//end if
-                        
+
                 unset($tempSelectArray[$index]);
                 $godArray[$j]["select"] = $closest;
                 $godArray[$j]["from"] = $fromPos;
                 $j++;
-                
+
         }//end foreach
-        
-        
+
+
         /**
           *  Pair the ORDER BYs with their approriate FROMs (and thus their
@@ -706 +706 @@
         $j = 0;
         foreach($orderArray as $orderPos){
-                
+
                 $closest = 0;
                 $index = 0;
@@ -714 +714 @@
                                 $index = $i;
                         }//end if
-                        
+
                 unset($tempFromArray[$index]);
                 for($k=0; $k < count($godArray); $k++)
                         if($godArray[$k]["from"] == $closest)
                                 $godArray[$k]["order"] = $orderPos;
-                
+
                 $j++;
-                
+
         }//end foreach
-        
-        
+
+
         /**
           *  The last entry in the $godArray should be the outermost / first
@@ -732 +732 @@
         if(!isset($godArray[$l]["order"]))
                 $godArray[$l]["order"] = strlen($querystatement);
-        
+
         if(!($godArray[$l]["order"]))
                 $godArray[$l]["order"] = strlen($querystatement);
-        
+
         return substr($querystatement, $godArray[$l]["from"], $godArray[$l]["order"] - $godArray[$l]["from"]);
-        
+
 }//end function
 
@@ -1125 +1125 @@
 
 /*
- * function cleanFilename       
+ * function cleanFilename
  * @param $string
  * @return string $string with only alpha-numeric characters, periods (.),
@@ -1132 +1132 @@
 
 function cleanFilename($string) {
-        
+
         $pattern = "/[^\w\d\.\-\_]/";
         $string = preg_replace($pattern, "", $string);
-        
+
         return $string;
-        
+
 }//end function --cleanFilename--
 
@@ -1246 +1246 @@
 
 
+/**
+ * function debug
+ *
+ * essentially provides a formatted var_dump with extra info for development purposes
+ */
+function debug($variable, $exit = false){
+
+        echo "<pre>";
+        var_dump($variable);
+        echo "</pre>";
+
+        $backtrace = debug_backtrace();
+
+        if(count($backtrace) > 1)
+            array_shift($backtrace);
+
+        foreach($backtrace as $trace){
+
+                echo "* ";
+
+                if(isset($trace["class"]))
+                    echo $trace["class"]."-&gt; ";
+
+                if(isset($trace["function"]))
+                    echo $trace["function"]." ";
+
+                echo "in ".$trace["file"]." ";
+                echo "on line ".$trace["line"]."<br />";
+
+        }//endforeach
+
+        if($exit)
+                exit();
+
+}//endif
+
 //for windows servers, we have no define time constants and nl_langinfo function
 //in a limited fashion; some windows servers still show that the function