PageRenderTime 81ms CodeModel.GetById 25ms RepoModel.GetById 0ms app.codeStats 1ms

/TEMPLATE/Reports/class/PHPJasperXML.inc.php

https://bitbucket.org/Lahiru_LCB/sep_wd_07
PHP | 3829 lines | 2955 code | 399 blank | 475 comment | 198 complexity | 3e2ded497e7c7e38aac9c7aac9fce426 MD5 | raw file
Possible License(s): LGPL-3.0, GPL-3.0, LGPL-2.1 
    

  1. <?php
    2. 

  2. 

  3. //version 0.8c
    4. 

  4. class PHPJasperXML {
    5. 

  5.     private $adjust=1.2;
    6. 

  6.     public $version=0.8;
    7. 

  7.     private $pdflib;
    8. 

  8.     private $lang;
    9. 

  9.     private $previousarraydata;
    10. 

  10.     public $debugsql=false;
    11. 

  11.     private $myconn;
    12. 

  12.     private $con;
    13. 

  13.     public $group_name;
    14. 

  14.     public $newPageGroup = false;
    15. 

  15.     private $curgroup=0;
    16. 

  16.     private $groupno=0;
    17. 

  17.     private $footershowed=true;
    18. 

  18.     private $titleheight=0;
    19. 

  19. 	private $report_count=1;		//### New declaration (variable exists in original too)
    20. 

  20. 	private $group_count = array(); //### New declaration
    21. 

  21.     public function PHPJasperXML($lang="en",$pdflib="TCPDF") {
    22. 

  22.         $this->lang=$lang;
    23. 

  23.       error_reporting(0);
    24. 

  24.         $this->pdflib=$pdflib;
    25. 

  25.     }
    26. 

  26. 

  27.     public function connect($db_host,$db_user,$db_pass,$db_or_dsn_name,$cndriver="mysql") {
    28. 

  28.     $this->db_host=$db_host;
    29. 

  29.             $this->db_user=$db_user;
    30. 

  30.        $this->db_pass=$db_pass;
    31. 

  31.     $this->db_or_dsn_name=$db_or_dsn_name;
    32. 

  32.     $this->cndriver=$cndriver;
    33. 

  33.         if($cndriver=="mysql") {
    34. 

  34. 

  35.             if(!$this->con) {
    36. 

  36.                 $this->myconn = @mysql_connect($db_host,$db_user,$db_pass);
    37. 

  37.                 if($this->myconn) {
    38. 

  38.                     $seldb = @mysql_select_db($db_or_dsn_name,$this->myconn);
    39. 

  39.                     if($seldb) {
    40. 

  40.                         $this->con = true;
    41. 

  41.                         return true;
    42. 

  42.                     }
    43. 

  43.                     else {
    44. 

  44.                         return false;
    45. 

  45.                     }
    46. 

  46.                 } else {
    47. 

  47.                     return false;
    48. 

  48.                 }
    49. 

  49.             } else {
    50. 

  50.                 return true;
    51. 

  51.             }
    52. 

  52.             return true;
    53. 

  53.         }elseif($cndriver=="psql") {
    54. 

  54.             global $pgport;
    55. 

  55.             if($pgport=="" || $pgport==0)
    56. 

  56.                 $pgport=5432;
    57. 

  57. 

  58.             $conn_string = "host=$db_host port=$pgport dbname=$db_or_dsn_name user=$db_user password=$db_pass";
    59. 

  59.             $this->myconn = pg_connect($conn_string);
    60. 

  60. 

  61. 

  62.             if($this->myconn) {
    63. 

  63.                 $this->con = true;
    64. 

  64. 

  65.                 return true;
    66. 

  66.             }else
    67. 

  67.                 return false;
    68. 

  68.         }
    69. 

  69.         else {
    70. 

  70. 

  71.             if(!$this->con) {
    72. 

  72.                 $this->myconn = odbc_connect($db_or_dsn_name,$db_user,$db_pass);
    73. 

  73. 

  74.                 if( $this->myconn) {
    75. 

  75.                     $this->con = true;
    76. 

  76.                     return true;
    77. 

  77.                 } else {
    78. 

  78.                     return false;
    79. 

  79.                 }
    80. 

  80.             } else {
    81. 

  81.                 return true;
    82. 

  82.             }
    83. 

  83.         }
    84. 

  84.     }
    85. 

  85. 

  86.     public function disconnect($cndriver="mysql") {
    87. 

  87.         if($cndriver=="mysql") {
    88. 

  88.             if($this->con) {
    89. 

  89.                 if(@mysql_close()) {
    90. 

  90.                     $this->con = false;
    91. 

  91.                     return true;
    92. 

  92.                 }
    93. 

  93.                 else {
    94. 

  94.                     return false;
    95. 

  95.                 }
    96. 

  96.             }
    97. 

  97.         }elseif($cndriver=="psql") {
    98. 

  98.             $this->con = false;
    99. 

  99.             pg_close($this->myconn);
    100. 

  100.         }
    101. 

  101.         else {
    102. 

  102. 

  103.             $this->con = false;
    104. 

  104.             odbc_close( $this->myconn);
    105. 

  105.         }
    106. 

  106.     }
    107. 

  107. 

  108.     public function xml_dismantle($xml) {	
    109. 

  109.         $this->page_setting($xml);
    110. 

  110.         foreach ($xml as $k=>$out) {
    111. 

  111.             switch($k) {
    112. 

  112.                 case "parameter":
    113. 

  113.                     $this->parameter_handler($out);
    114. 

  114.                     break;
    115. 

  115.                 case "queryString":
    116. 

  116.                     $this->queryString_handler($out);
    117. 

  117.                     break;
    118. 

  118.                 case "field":
    119. 

  119.                     $this->field_handler($out);
    120. 

  120.                     break;
    121. 

  121.                 case "variable":
    122. 

  122.                     $this->variable_handler($out);
    123. 

  123.                     break;
    124. 

  124.                 case "group":
    125. 

  125.                     $this->group_handler($out);
    126. 

  126.                     break;
    127. 

  127.                 case "subDataset":
    128. 

  128.                        $this->subDataset_handler($out);
    129. 

  129.                     break;
    130. 

  130.                 case "background":
    131. 

  131.                     $this->pointer=&$this->arraybackground;
    132. 

  132.                     $this->pointer[]=array("height"=>$out->band["height"],"splitType"=>$out->band["splitType"]);
    133. 

  133.                     foreach ($out as $bg) {
    134. 

  134.                         $this->default_handler($bg);
    135. 

  135. 

  136.                     }
    137. 

  137.                     break;
    138. 

  138.                 default:
    139. 

  139.                     foreach ($out as $object) {
    140. 

  140. 

  141.                         eval("\$this->pointer=&"."\$this->array$k".";");
    142. 

  142.                         $this->arrayband[]=array("name"=>$k);
    143. 

  143.                         if($k=='detail')
    144. 

  144.                         $this->detailbandheight=$object["height"]+0;
    145. 

  145.                         elseif($k=='pageHeader')
    146. 

  146.                         $this->headerbandheight=$object["height"]+0;
    147. 

  147.                         elseif($k=='pageFooter')
    148. 

  148.                         $this->footerbandheight=$object["height"]+0;
    149. 

  149.                         elseif($k=='lastPageFooter')
    150. 

  150.                         $this->lastfooterbandheight=$object["height"]+0;
    151. 

  151.                         elseif($k=='summary')
    152. 

  152.                         $this->summarybandheight=$object["height"]+0;
    153. 

  153.                         
    154. 

  154.                         $this->pointer[]=array("type"=>"band","height"=>$object["height"],"splitType"=>$object["splitType"],"y_axis"=>$this->y_axis);
    155. 

  155.                         $this->default_handler($object);
    156. 

  156.                     }
    157. 

  157.                     $this->y_axis=$this->y_axis+$out->band["height"];	//after handle , then adjust y axis
    158. 

  158. 

  159.                     break;
    160. 

  160. 

  161.             }
    162. 

  162. 

  163.         }
    164. 

  164.     }
    165. 

  165. 

  166.     public function subDataset_handler($data){
    167. 

  167.     $this->subdataset[$data['name'].'']= $data->queryString;
    168. 

  168. 

  169.     }
    170. 

  170. //read level 0,Jasperreport page setting
    171. 

  171.     public function page_setting($xml_path) {
    172. 

  172.         $this->arrayPageSetting["orientation"]="P";
    173. 

  173.         $this->arrayPageSetting["name"]=$xml_path["name"];
    174. 

  174.         $this->arrayPageSetting["language"]=$xml_path["language"];
    175. 

  175.         $this->arrayPageSetting["pageWidth"]=$xml_path["pageWidth"];
    176. 

  176.         $this->arrayPageSetting["pageHeight"]=$xml_path["pageHeight"];
    177. 

  177.         if(isset($xml_path["orientation"])) {
    178. 

  178.             $this->arrayPageSetting["orientation"]=substr($xml_path["orientation"],0,1);
    179. 

  179.         }
    180. 

  180.         $this->arrayPageSetting["columnWidth"]=$xml_path["columnWidth"];
    181. 

  181.         $this->arrayPageSetting["leftMargin"]=$xml_path["leftMargin"];
    182. 

  182.         $this->arrayPageSetting["rightMargin"]=$xml_path["rightMargin"];
    183. 

  183.         $this->arrayPageSetting["topMargin"]=$xml_path["topMargin"];
    184. 

  184.         $this->y_axis=$xml_path["topMargin"];
    185. 

  185.         $this->arrayPageSetting["bottomMargin"]=$xml_path["bottomMargin"];
    186. 

  186.     }
    187. 

  187. 

  188.     public function parameter_handler($xml_path) {
    189. 

  189.         //    $defaultValueExpression=str_replace('"','',$xml_path->defaultValueExpression);
    190. 

  190.       // if($defaultValueExpression!='')
    191. 

  191.       //  $this->arrayParameter[$xml_path["name"].'']=$defaultValueExpression;
    192. 

  192.       // else
    193. 

  193.         $this->arrayParameter[$xml_path["name"].''];        
    194. 

  194. 

  195.     }
    196. 

  196. 

  197.     public function queryString_handler($xml_path) {
    198. 

  198.         $this->sql =$xml_path;
    199. 

  199.         if(isset($this->arrayParameter)) {
    200. 

  200.             foreach($this->arrayParameter as  $v => $a) {
    201. 

  201.                 $this->sql = str_replace('$P{'.$v.'}', $a, $this->sql);
    202. 

  202.             }
    203. 

  203.         }
    204. 

  204.     }
    205. 

  205. 

  206.     public function field_handler($xml_path) {
    207. 

  207.         $this->arrayfield[]=$xml_path["name"];
    208. 

  208.     }
    209. 

  209. 

  210.     public function variable_handler($xml_path) {
    211. 

  211. 

  212.         $this->arrayVariable["$xml_path[name]"]=array("calculation"=>$xml_path["calculation"],"target"=>substr($xml_path->variableExpression,3,-1),"class"=>$xml_path["class"] , "resetType"=>$xml_path["resetType"]);
    213. 

  213. 

  214.     }
    215. 

  215. 

  216.     public function group_handler($xml_path) {
    217. 

  217. 

  218. //        $this->arraygroup=$xml_path;
    219. 

  219. 

  220. 

  221.         if($xml_path["isStartNewPage"]=="true")
    222. 

  222.             $this->newPageGroup=true;
    223. 

  223.         else
    224. 

  224.             $this->newPageGroup="";
    225. 

  225. 

  226.         foreach($xml_path as $tag=>$out) {
    227. 

  227.             switch ($tag) {
    228. 

  228.                 case "groupHeader":
    229. 

  229.                     $this->pointer=&$this->arraygroup[$xml_path["name"]]["groupHeader"];
    230. 

  230.                     $this->pointer=&$this->arraygrouphead;
    231. 

  231.                     $this->arraygroupheadheight=$out->band["height"];
    232. 

  232.                     $this->arrayband[]=array("name"=>"group", "gname"=>$xml_path["name"],"isStartNewPage"=>$xml_path["isStartNewPage"],"groupExpression"=>substr($xml_path->groupExpression,3,-1));
    233. 

  233.                     $this->pointer[]=array("type"=>"band","height"=>$out->band["height"]+0,"y_axis"=>"","groupExpression"=>substr($xml_path->groupExpression,3,-1));
    234. 

  234. //### Modification for group count
    235. 

  235. 					$gnam=$xml_path["name"];				
    236. 

  236. 					$this->gnam=$xml_path["name"];
    237. 

  237. 					$this->group_count["$gnam"]=1; // Count rows of groups, we're on the first row of the group.
    238. 

  238. //### End of modification
    239. 

  239.                     foreach($out as $band) {
    240. 

  240.                         $this->default_handler($band);
    241. 

  241. 

  242.                     }
    243. 

  243. 

  244.                     $this->y_axis=$this->y_axis+$out->band["height"];		//after handle , then adjust y axis
    245. 

  245.                     break;
    246. 

  246.                 case "groupFooter":
    247. 

  247. 

  248.                     $this->pointer=&$this->arraygroup[$xml_path["name"]]["groupFooter"];
    249. 

  249.                     $this->pointer=&$this->arraygroupfoot;
    250. 

  250.                     $this->arraygroupfootheight=$out->band["height"];
    251. 

  251.                     $this->pointer[]=array("type"=>"band","height"=>$out->band["height"]+0,"y_axis"=>"","groupExpression"=>substr($xml_path->groupExpression,3,-1));
    252. 

  252.                     foreach($out as $b=>$band) {
    253. 

  253.                         $this->default_handler($band);
    254. 

  254. 

  255.                     }
    256. 

  256.                     break;
    257. 

  257.                 default:
    258. 

  258. 

  259.                     break;
    260. 

  260.             }
    261. 

  261. 

  262.         }
    263. 

  263.     }
    264. 

  264. 

  265.   public function default_handler($xml_path) {
    266. 

  266.         foreach($xml_path as $k=>$out) {
    267. 

  267. 

  268.             switch($k) {
    269. 

  269.                 case "staticText":
    270. 

  270.                     $this->element_staticText($out);
    271. 

  271.                     break;
    272. 

  272.                 case "image":
    273. 

  273.                     $this->element_image($out);
    274. 

  274.                     break;
    275. 

  275.                 case "line":
    276. 

  276.                     $this->element_line($out);
    277. 

  277.                     break;
    278. 

  278.                 case "rectangle":
    279. 

  279.                     $this->element_rectangle($out);
    280. 

  280.                     break;
    281. 

  281.             case "ellipse":
    282. 

  282.                     $this->element_ellipse($out);
    283. 

  283.                     break;
    284. 

  284. 	                case "textField":
    285. 

  285.                     $this->element_textField($out);
    286. 

  286.                     break;
    287. 

  287. //                case "stackedBarChart":
    288. 

  288. //                    $this->element_barChart($out,'StackedBarChart');
    289. 

  289. //                    break;
    290. 

  290. //                case "barChart":
    291. 

  291. //                    $this->element_barChart($out,'BarChart');
    292. 

  292. //                    break;
    293. 

  293. //                case "pieChart":
    294. 

  294. //                    $this->element_pieChart($out);
    295. 

  295. //                    break;
    296. 

  296. //                case "pie3DChart":
    297. 

  297. //                    $this->element_pie3DChart($out);
    298. 

  298. //                    break;
    299. 

  299. //                case "lineChart":
    300. 

  300. //                    $this->element_lineChart($out);
    301. 

  301. //                    break;
    302. 

  302. //                case "stackedAreaChart":
    303. 

  303. //                    $this->element_areaChart($out,'stackedAreaChart');
    304. 

  304. //                    break;
    305. 

  305.                     case "stackedBarChart":
    306. 

  306.                     $this->element_Chart($out,'stackedBarChart');
    307. 

  307.                     break;
    308. 

  308.                 case "barChart":
    309. 

  309.                     $this->element_Chart($out,'barChart');
    310. 

  310.                     break;
    311. 

  311.                 case "pieChart":
    312. 

  312.                     $this->element_Chart($out,'pieChart');
    313. 

  313.                     break;
    314. 

  314.                 case "pie3DChart":
    315. 

  315.                     $this->element_pie3DChart($out,'pie3DChart');
    316. 

  316.                     break;
    317. 

  317.                 case "lineChart":
    318. 

  318.                     $this->element_Chart($out,'lineChart');
    319. 

  319.                     break;
    320. 

  320.                 case "stackedAreaChart":
    321. 

  321.                     $this->element_Chart($out,'stackedAreaChart');
    322. 

  322.                     break;
    323. 

  323.                 case "subreport":
    324. 

  324.                     $this->element_subReport($out);
    325. 

  325.                     break;
    326. 

  326.                 default:
    327. 

  327.                     break;
    328. 

  328.             }
    329. 

  329.         };		
    330. 

  330.     }
    331. 

  331. 

  332.     public function element_staticText($data) {
    333. 

  333.         $align="L";
    334. 

  334.         $fill=0;
    335. 

  335.         $border=0;
    336. 

  336.         $fontsize=10;
    337. 

  337.         $font="helvetica";
    338. 

  338.         $fontstyle="";
    339. 

  339.         $textcolor = array("r"=>0,"g"=>0,"b"=>0);
    340. 

  340.         $fillcolor = array("r"=>255,"g"=>255,"b"=>255);
    341. 

  341.         $txt="";
    342. 

  342.         $rotation="";
    343. 

  343.         $drawcolor=array("r"=>0,"g"=>0,"b"=>0);
    344. 

  344.         $height=$data->reportElement["height"];
    345. 

  345.         $stretchoverflow="true";
    346. 

  346.         $printoverflow="false";
    347. 

  347.         if(isset($data->reportElement["forecolor"])) {
    348. 

  348.             
    349. 

  349.             $textcolor = array('forecolor'=>$data->reportElement["forecolor"],"r"=>hexdec(substr($data->reportElement["forecolor"],1,2)),"g"=>hexdec(substr($data->reportElement["forecolor"],3,2)),"b"=>hexdec(substr($data->reportElement["forecolor"],5,2)));
    350. 

  350.         }
    351. 

  351.         if(isset($data->reportElement["backcolor"])) {
    352. 

  352.             $fillcolor = array('backcolor'=>$data->reportElement["backcolor"],"r"=>hexdec(substr($data->reportElement["backcolor"],1,2)),"g"=>hexdec(substr($data->reportElement["backcolor"],3,2)),"b"=>hexdec(substr($data->reportElement["backcolor"],5,2)));
    353. 

  353.         }
    354. 

  354.         if($data->reportElement["mode"]=="Opaque") {
    355. 

  355.             $fill=1;
    356. 

  356.         }
    357. 

  357.         if(isset($data["isStretchWithOverflow"])&&$data["isStretchWithOverflow"]=="true") {
    358. 

  358.             $stretchoverflow="true";
    359. 

  359.         }
    360. 

  360.         if(isset($data->reportElement["isPrintWhenDetailOverflows"])&&$data->reportElement["isPrintWhenDetailOverflows"]=="true") {
    361. 

  361.             $printoverflow="true";
    362. 

  362.             $stretchoverflow="false";
    363. 

  363.         }
    364. 

  364.         if((isset($data->box))&&($data->box->pen["lineWidth"]>0)) {
    365. 

  365.             $border=1;
    366. 

  366.             if(isset($data->box->pen["lineColor"])) {
    367. 

  367.                 $drawcolor=array("r"=>hexdec(substr($data->box->pen["lineColor"],1,2)),"g"=>hexdec(substr($data->box->pen["lineColor"],3,2)),"b"=>hexdec(substr($data->box->pen["lineColor"],5,2)));
    368. 

  368.             }
    369. 

  369.         }
    370. 

  370.         if(isset($data->textElement["textAlignment"])) {
    371. 

  371.             $align=$this->get_first_value($data->textElement["textAlignment"]);
    372. 

  372.         }
    373. 

  373.         if(isset($data->textElement["rotation"])) {
    374. 

  374.             $rotation=$data->textElement["rotation"];
    375. 

  375.         }
    376. 

  376.         if(isset($data->textElement->font["pdfFontName"])) {
    377. 

  377.             $font=$data->textElement->font["pdfFontName"];
    378. 

  378.         }
    379. 

  379.         if(isset($data->textElement->font["size"])) {
    380. 

  380.             $fontsize=$data->textElement->font["size"];
    381. 

  381.         }
    382. 

  382.         if(isset($data->textElement->font["isBold"])&&$data->textElement->font["isBold"]=="true") {
    383. 

  383.             $fontstyle=$fontstyle."B";
    384. 

  384.         }
    385. 

  385.         if(isset($data->textElement->font["isItalic"])&&$data->textElement->font["isItalic"]=="true") {
    386. 

  386.             $fontstyle=$fontstyle."I";
    387. 

  387.         }
    388. 

  388.         if(isset($data->textElement->font["isUnderline"])&&$data->textElement->font["isUnderline"]=="true") {
    389. 

  389.             $fontstyle=$fontstyle."U";
    390. 

  390.         }
    391. 

  391.         if(isset($data->reportElement["key"])) {
    392. 

  392.             $height=$fontsize*$this->adjust;
    393. 

  393.         }
    394. 

  394.         $this->pointer[]=array("type"=>"SetXY","x"=>$data->reportElement["x"],"y"=>$data->reportElement["y"],"hidden_type"=>"SetXY");
    395. 

  395.         $this->pointer[]=array("type"=>"SetTextColor",'forecolor'=>$data->reportElement["forecolor"].'',"r"=>$textcolor["r"],"g"=>$textcolor["g"],"b"=>$textcolor["b"],"hidden_type"=>"textcolor");
    396. 

  396.         $this->pointer[]=array("type"=>"SetDrawColor","r"=>$drawcolor["r"],"g"=>$drawcolor["g"],"b"=>$drawcolor["b"],"hidden_type"=>"drawcolor");
    397. 

  397.         $this->pointer[]=array("type"=>"SetFillColor",'backcolor'=>$data->reportElement["backcolor"].'',"r"=>$fillcolor["r"],"g"=>$fillcolor["g"],"b"=>$fillcolor["b"],"hidden_type"=>"fillcolor");
    398. 

  398.         $this->pointer[]=array("type"=>"SetFont","font"=>$font,"fontstyle"=>$fontstyle,"fontsize"=>$fontsize,"hidden_type"=>"font");
    399. 

  399.         //"height"=>$data->reportElement["height"]
    400. 

  400. //### UTF-8 characters, a must for me.	
    401. 

  401. 		$txtEnc=utf8_decode($data->text); 
    402. 

  402. 		$this->pointer[]=array("type"=>"MultiCell","width"=>$data->reportElement["width"],"height"=>$height,"txt"=>$txtEnc,"border"=>$border,"align"=>$align,"fill"=>$fill,"hidden_type"=>"statictext","soverflow"=>$stretchoverflow,"poverflow"=>$printoverflow,"rotation"=>$rotation);
    403. 

  403. //### End of modification, below is the original line		
    404. 

  404. //        $this->pointer[]=array("type"=>"MultiCell","width"=>$data->reportElement["width"],"height"=>$height,"txt"=>$data->text,"border"=>$border,"align"=>$align,"fill"=>$fill,"hidden_type"=>"statictext","soverflow"=>$stretchoverflow,"poverflow"=>$printoverflow,"rotation"=>$rotation);
    405. 

  405. 

  406.     }
    407. 

  407. 

  408.     public function element_image($data) {
    409. 

  409.         $imagepath=$data->imageExpression;
    410. 

  410.         //$imagepath= substr($data->imageExpression, 1, -1);
    411. 

  411.         //$imagetype= substr($imagepath,-3);
    412. 

  412. 

  413.         switch($data[scaleImage]) {
    414. 

  414.             case "FillFrame":
    415. 

  415.                 $this->pointer[]=array("type"=>"Image","path"=>$imagepath,"x"=>$data->reportElement["x"]+0,"y"=>$data->reportElement["y"]+0,"width"=>$data->reportElement["width"]+0,"height"=>$data->reportElement["height"]+0,"imgtype"=>$imagetype,"link"=>substr($data->hyperlinkReferenceExpression,1,-1),"hidden_type"=>"image");
    416. 

  416.                 break;
    417. 

  417.             default:
    418. 

  418.                 $this->pointer[]=array("type"=>"Image","path"=>$imagepath,"x"=>$data->reportElement["x"]+0,"y"=>$data->reportElement["y"]+0,"width"=>$data->reportElement["width"]+0,"height"=>$data->reportElement["height"]+0,"imgtype"=>$imagetype,"link"=>substr($data->hyperlinkReferenceExpression,1,-1),"hidden_type"=>"image");
    419. 

  419.                 break;
    420. 

  420.         }
    421. 

  421.     }
    422. 

  422. 

  423.     public function element_line($data) {	//default line width=0.567(no detect line width)
    424. 

  424.         $drawcolor=array("r"=>0,"g"=>0,"b"=>0);
    425. 

  425.         $hidden_type="line";
    426. 

  426.         if(isset($data->reportElement["forecolor"])) {
    427. 

  427.             $drawcolor=array("r"=>hexdec(substr($data->reportElement["forecolor"],1,2)),"g"=>hexdec(substr($data->reportElement["forecolor"],3,2)),"b"=>hexdec(substr($data->reportElement["forecolor"],5,2)));
    428. 

  428.         }
    429. 

  429.         $this->pointer[]=array("type"=>"SetDrawColor","r"=>$drawcolor["r"],"g"=>$drawcolor["g"],"b"=>$drawcolor["b"],"hidden_type"=>"drawcolor");
    430. 

  430.         if(isset($data->reportElement[positionType])&&$data->reportElement[positionType]=="FixRelativeToBottom") {
    431. 

  431.             $hidden_type="relativebottomline";
    432. 

  432.         }
    433. 

  433.         if($data->reportElement["width"][0]+0 > $data->reportElement["height"][0]+0)	//width > height means horizontal line
    434. 

  434.         {
    435. 

  435.             $this->pointer[]=array("type"=>"Line", "x1"=>$data->reportElement["x"],"y1"=>$data->reportElement["y"],"x2"=>$data->reportElement["x"]+$data->reportElement["width"],"y2"=>$data->reportElement["y"]+$data->reportElement["height"]-1,"hidden_type"=>$hidden_type);
    436. 

  436.         }
    437. 

  437.         elseif($data->reportElement["height"][0]+0>$data->reportElement["width"][0]+0)		//vertical line
    438. 

  438.         {
    439. 

  439.             $this->pointer[]=array("type"=>"Line", "x1"=>$data->reportElement["x"],"y1"=>$data->reportElement["y"],"x2"=>$data->reportElement["x"]+$data->reportElement["width"]-1,"y2"=>$data->reportElement["y"]+$data->reportElement["height"],"hidden_type"=>$hidden_type);
    440. 

  440.         }
    441. 

  441.         $this->pointer[]=array("type"=>"SetDrawColor","r"=>0,"g"=>0,"b"=>0,"hidden_type"=>"drawcolor");
    442. 

  442.         $this->pointer[]=array("type"=>"SetFillColor","r"=>255,"g"=>255,"b"=>255,"hidden_type"=>"fillcolor");
    443. 

  443.     }
    444. 

  444. 

  445.     public function element_rectangle($data) {
    446. 

  446. 		
    447. 

  447. 		$radius=$data['radius'];
    448. 

  448.         $drawcolor=array("r"=>0,"g"=>0,"b"=>0);
    449. 

  449.         
    450. 

  450.         $fillcolor=array("r"=>255,"g"=>255,"b"=>255);
    451. 

  451. 

  452.         
    453. 

  453.         if(isset($data->reportElement["forecolor"])) {
    454. 

  454.             $drawcolor=array("r"=>hexdec(substr($data->reportElement["forecolor"],1,2)),"g"=>hexdec(substr($data->reportElement["forecolor"],3,2)),"b"=>hexdec(substr($data->reportElement["forecolor"],5,2)));			
    455. 

  455.         }
    456. 

  456.         
    457. 

  457.         if(isset($data->reportElement["backcolor"]) ) {
    458. 

  458.             $fillcolor=array("r"=>hexdec(substr($data->reportElement["backcolor"],1,2)),"g"=>hexdec(substr($data->reportElement["backcolor"],3,2)),"b"=>hexdec(substr($data->reportElement["backcolor"],5,2)));			
    459. 

  459.         }
    460. 

  460. 

  461. 

  462.         $this->pointer[]=array("type"=>"SetDrawColor","r"=>$drawcolor["r"],"g"=>$drawcolor["g"],"b"=>$drawcolor["b"],"hidden_type"=>"drawcolor");
    463. 

  463.         $this->pointer[]=array("type"=>"SetFillColor","r"=>$fillcolor["r"],"g"=>$fillcolor["g"],"b"=>$fillcolor["b"],"hidden_type"=>"fillcolor");
    464. 

  464. 		
    465. 

  465.         if($radius=='')
    466. 

  466.         $this->pointer[]=array("type"=>"Rect","x"=>$data->reportElement["x"],"y"=>$data->reportElement["y"],"width"=>$data->reportElement["width"],"height"=>$data->reportElement["height"],"hidden_type"=>"rect","drawcolor"=>$drawcolor,"fillcolor"=>$fillcolor,"mode"=>$data->reportElement["mode"]);
    467. 

  467.         else
    468. 

  468.         $this->pointer[]=array("type"=>"RoundedRect","x"=>$data->reportElement["x"],"y"=>$data->reportElement["y"],"width"=>$data->reportElement["width"],"height"=>$data->reportElement["height"],"hidden_type"=>"roundedrect","radius"=>$radius,"drawcolor"=>$drawcolor,"fillcolor"=>$fillcolor,"mode"=>$data->reportElement["mode"]);
    469. 

  469.         $this->pointer[]=array("type"=>"SetDrawColor","r"=>0,"g"=>0,"b"=>0,"hidden_type"=>"drawcolor");
    470. 

  470.         $this->pointer[]=array("type"=>"SetFillColor","r"=>255,"g"=>255,"b"=>255,"hidden_type"=>"fillcolor");
    471. 

  471.     }
    472. 

  472. 

  473.   public function element_ellipse($data) {
    474. 

  474.         $drawcolor=array("r"=>0,"g"=>0,"b"=>0);
    475. 

  475.         $fillcolor=array("r"=>255,"g"=>255,"b"=>255);
    476. 

  476.         if(isset($data->reportElement["forecolor"])) {
    477. 

  477.             $drawcolor=array("r"=>hexdec(substr($data->reportElement["forecolor"],1,2)),"g"=>hexdec(substr($data->reportElement["forecolor"],3,2)),"b"=>hexdec(substr($data->reportElement["forecolor"],5,2)));			
    478. 

  478.         }
    479. 

  479.         if(isset($data->reportElement["backcolor"])) {
    480. 

  480.             $fillcolor=array("r"=>hexdec(substr($data->reportElement["backcolor"],1,2)),"g"=>hexdec(substr($data->reportElement["backcolor"],3,2)),"b"=>hexdec(substr($data->reportElement["backcolor"],5,2)));			
    481. 

  481.         }
    482. 

  482.         
    483. 

  483. 		//$color=array("r"=>$drawcolor["r"],"g"=>$drawcolor["g"],"b"=>$drawcolor["b"]);
    484. 

  484.         $this->pointer[]=array("type"=>"SetFillColor","r"=>$fillcolor["r"],"g"=>$fillcolor["g"],"b"=>$fillcolor["b"],"hidden_type"=>"fillcolor");
    485. 

  485.         $this->pointer[]=array("type"=>"SetDrawColor","r"=>$drawcolor["r"],"g"=>$drawcolor["g"],"b"=>$drawcolor["b"],"hidden_type"=>"drawcolor");
    486. 

  486.         $this->pointer[]=array("type"=>"Ellipse","x"=>$data->reportElement["x"],"y"=>$data->reportElement["y"],"width"=>$data->reportElement["width"],"height"=>$data->reportElement["height"],"hidden_type"=>"ellipse","drawcolor"=>$drawcolor,"fillcolor"=>$fillcolor);
    487. 

  487.         $this->pointer[]=array("type"=>"SetDrawColor","r"=>0,"g"=>0,"b"=>0,"hidden_type"=>"drawcolor");
    488. 

  488.         $this->pointer[]=array("type"=>"SetFillColor","r"=>255,"g"=>255,"b"=>255,"hidden_type"=>"fillcolor");
    489. 

  489.     }
    490. 

  490.     
    491. 

  491.     public function element_textField($data) {
    492. 

  492.         $align="L";
    493. 

  493.         $fill=0;
    494. 

  494.         $border=0;
    495. 

  495.         $fontsize=10;
    496. 

  496.         $font="helvetica";
    497. 

  497.         $rotation="";
    498. 

  498.         $fontstyle="";
    499. 

  499.         $textcolor = array("r"=>0,"g"=>0,"b"=>0);
    500. 

  500.         $fillcolor = array("r"=>255,"g"=>255,"b"=>255);
    501. 

  501.         $stretchoverflow="false";
    502. 

  502.         $printoverflow="false";
    503. 

  503.         $height=$data->reportElement["height"];
    504. 

  504.         $drawcolor=array("r"=>0,"g"=>0,"b"=>0);
    505. 

  505.         if(isset($data->reportElement["forecolor"])) {
    506. 

  506.             $textcolor = array("r"=>hexdec(substr($data->reportElement["forecolor"],1,2)),"g"=>hexdec(substr($data->reportElement["forecolor"],3,2)),"b"=>hexdec(substr($data->reportElement["forecolor"],5,2)));
    507. 

  507.         }
    508. 

  508.         if(isset($data->reportElement["backcolor"])) {
    509. 

  509.             $fillcolor = array("r"=>hexdec(substr($data->reportElement["backcolor"],1,2)),"g"=>hexdec(substr($data->reportElement["backcolor"],3,2)),"b"=>hexdec(substr($data->reportElement["backcolor"],5,2)));
    510. 

  510.         }
    511. 

  511.         if($data->reportElement["mode"]=="Opaque") {
    512. 

  512.             $fill=1;
    513. 

  513.         }
    514. 

  514.         if(isset($data["isStretchWithOverflow"])&&$data["isStretchWithOverflow"]=="true") {
    515. 

  515.             $stretchoverflow="true";
    516. 

  516.         }
    517. 

  517.         if(isset($data->reportElement["isPrintWhenDetailOverflows"])&&$data->reportElement["isPrintWhenDetailOverflows"]=="true") {
    518. 

  518.             $printoverflow="true";
    519. 

  519.         }
    520. 

  520.         if(isset($data->box)&&$data->box->pen["lineWidth"]>0) {
    521. 

  521.             $border=1;
    522. 

  522.             if(isset($data->box->pen["lineColor"])) {
    523. 

  523.                 $drawcolor=array("r"=>hexdec(substr($data->box->pen["lineColor"],1,2)),"g"=>hexdec(substr($data->box->pen["lineColor"],3,2)),"b"=>hexdec(substr($data->box->pen["lineColor"],5,2)));
    524. 

  524.             }
    525. 

  525.         }
    526. 

  526.         if(isset($data->reportElement["key"])) {
    527. 

  527.             $height=$fontsize*$this->adjust;
    528. 

  528.         }
    529. 

  529.         if(isset($data->textElement["textAlignment"])) {
    530. 

  530.             $align=$this->get_first_value($data->textElement["textAlignment"]);
    531. 

  531.         }
    532. 

  532.         if(isset($data->textElement["rotation"])) {
    533. 

  533.             $rotation=$data->textElement["rotation"];
    534. 

  534.         }
    535. 

  535.         if(isset($data->textElement->font["pdfFontName"])) {
    536. 

  536.             $font=$data->textElement->font["pdfFontName"];
    537. 

  537.         }
    538. 

  538.         if(isset($data->textElement->font["size"])) {
    539. 

  539.             $fontsize=$data->textElement->font["size"];
    540. 

  540.         }
    541. 

  541.         if(isset($data->textElement->font["isBold"])&&$data->textElement->font["isBold"]=="true") {
    542. 

  542.             $fontstyle=$fontstyle."B";
    543. 

  543.         }
    544. 

  544.         if(isset($data->textElement->font["isItalic"])&&$data->textElement->font["isItalic"]=="true") {
    545. 

  545.             $fontstyle=$fontstyle."I";
    546. 

  546.         }
    547. 

  547.         if(isset($data->textElement->font["isUnderline"])&&$data->textElement->font["isUnderline"]=="true") {
    548. 

  548.             $fontstyle=$fontstyle."U";
    549. 

  549.         }
    550. 

  550.         $this->pointer[]=array("type"=>"SetXY","x"=>$data->reportElement["x"],"y"=>$data->reportElement["y"],"hidden_type"=>"SetXY");
    551. 

  551.         $this->pointer[]=array("type"=>"SetTextColor","forecolor"=>$data->reportElement["forecolor"],"r"=>$textcolor["r"],"g"=>$textcolor["g"],"b"=>$textcolor["b"],"hidden_type"=>"textcolor");
    552. 

  552.         $this->pointer[]=array("type"=>"SetDrawColor","r"=>$drawcolor["r"],"g"=>$drawcolor["g"],"b"=>$drawcolor["b"],"hidden_type"=>"drawcolor");
    553. 

  553.         $this->pointer[]=array("type"=>"SetFillColor","backcolor"=>$data->reportElement["backcolor"],"r"=>$fillcolor["r"],"g"=>$fillcolor["g"],"b"=>$fillcolor["b"],"hidden_type"=>"fillcolor");
    554. 

  554.         $this->pointer[]=array("type"=>"SetFont","font"=>$font,"fontstyle"=>$fontstyle,"fontsize"=>$fontsize,"hidden_type"=>"font");
    555. 

  555.          //$data->hyperlinkReferenceExpression=$this->analyse_expression($data->hyperlinkReferenceExpression);
    556. 

  556.         //if( $data->hyperlinkReferenceExpression!=''){echo "$data->hyperlinkReferenceExpression";die;}
    557. 

  557. 

  558. 

  559.         switch ($data->textFieldExpression) {
    560. 

  560.             case 'new java.util.Date()':
    561. 

  561. //### New: =>date("Y.m.d.",....
    562. 

  562.                 $this->pointer[]=array ("type"=>"MultiCell","width"=>$data->reportElement["width"],"height"=>$height,"txt"=>date("Y-m-d H:i:s"),"border"=>$border,"align"=>$align,"fill"=>$fill,"hidden_type"=>"date","soverflow"=>$stretchoverflow,"poverflow"=>$printoverflow,"link"=>substr($data->hyperlinkReferenceExpression,1,-1));
    563. 

  563. //### End of modification				
    564. 

  564.                 break;
    565. 

  565.             case '"Page "+$V{PAGE_NUMBER}+" of"':
    566. 

  566.                 $this->pointer[]=array("type"=>"MultiCell","width"=>$data->reportElement["width"],"height"=>$height,"txt"=>'Page $this->PageNo() of',"border"=>$border,"align"=>$align,"fill"=>$fill,"hidden_type"=>"pageno","soverflow"=>$stretchoverflow,"poverflow"=>$printoverflow,"link"=>substr($data->hyperlinkReferenceExpression,1,-1),"pattern"=>$data["pattern"]);
    567. 

  567.                 break;
    568. 

  568.             case '$V{PAGE_NUMBER}':
    569. 

  569.                 if(isset($data["evaluationTime"])&&$data["evaluationTime"]=="Report") {
    570. 

  570.                     $this->pointer[]=array("type"=>"MultiCell","width"=>$data->reportElement["width"],"height"=>$height,"txt"=>'{nb}',"border"=>$border,"align"=>$align,"fill"=>$fill,"hidden_type"=>"pageno","soverflow"=>$stretchoverflow,"poverflow"=>$printoverflow,"link"=>substr($data->hyperlinkReferenceExpression,1,-1),"pattern"=>$data["pattern"]);
    571. 

  571.                 }
    572. 

  572.                 else {
    573. 

  573.                     $this->pointer[]=array("type"=>"MultiCell","width"=>$data->reportElement["width"],"height"=>$height,"txt"=>'$this->PageNo()',"border"=>$border,"align"=>$align,"fill"=>$fill,"hidden_type"=>"pageno","soverflow"=>$stretchoverflow,"poverflow"=>$printoverflow,"link"=>substr($data->hyperlinkReferenceExpression,1,-1),"pattern"=>$data["pattern"]);
    574. 

  574.                 }
    575. 

  575.                 break;
    576. 

  576.             case '" " + $V{PAGE_NUMBER}':
    577. 

  577.                 $this->pointer[]=array("type"=>"MultiCell","width"=>$data->reportElement["width"],"height"=>$height,"txt"=>' {nb}',"border"=>$border,"align"=>$align,"fill"=>$fill,"hidden_type"=>"nb","soverflow"=>$stretchoverflow,"poverflow"=>$printoverflow,"link"=>substr($data->hyperlinkReferenceExpression,1,-1),"pattern"=>$data["pattern"]);
    578. 

  578.                 break;
    579. 

  579.             case '$V{REPORT_COUNT}':
    580. 

  580. //###                $this->report_count=0;	
    581. 

  581.                 $this->pointer[]=array("type"=>"MultiCell","width"=>$data->reportElement["width"],"height"=>$height,"txt"=>&$this->report_count,"border"=>$border,"align"=>$align,"fill"=>$fill,"hidden_type"=>"report_count","soverflow"=>$stretchoverflow,"poverflow"=>$printoverflow,"link"=>substr($data->hyperlinkReferenceExpression,1,-1),"pattern"=>$data["pattern"]);
    582. 

  582.                 break;
    583. 

  583.             case '$V{'.$this->gnam.'_COUNT}':
    584. 

  584. //            case '$V{'.$this->arrayband[0]["gname"].'_COUNT}':
    585. 

  585. //###                $this->group_count=0;
    586. 

  586. 				$gnam=$this->arrayband[0]["gname"];																
    587. 

  587.                 $this->pointer[]=array("type"=>"MultiCell","width"=>$data->reportElement["width"],"height"=>$height,"txt"=>&$this->group_count["$this->gnam"],"border"=>$border,"align"=>$align,"fill"=>$fill,"hidden_type"=>"group_count","soverflow"=>$stretchoverflow,"poverflow"=>$printoverflow,"link"=>substr($data->hyperlinkReferenceExpression,1,-1),"pattern"=>$data["pattern"]);
    588. 

  588.                 break;
    589. 

  589.             default:
    590. 

  590.                 $writeHTML=false;
    591. 

  591.                 if($data->reportElement->property["name"]=="writeHTML")
    592. 

  592.                     $writeHTML=$data->reportElement->property["value"];
    593. 

  593.                 if(isset($data->reportElement["isPrintRepeatedValues"]))
    594. 

  594.                     $isPrintRepeatedValues=$data->reportElement["isPrintRepeatedValues"];
    595. 

  595. 

  596. 

  597.                 $this->pointer[]=array("type"=>"MultiCell","width"=>$data->reportElement["width"],"height"=>$height,"txt"=>$data->textFieldExpression,
    598. 

  598.                         "border"=>$border,"align"=>$align,"fill"=>$fill,
    599. 

  599.                         "hidden_type"=>"field","soverflow"=>$stretchoverflow,"poverflow"=>$printoverflow,
    600. 

  600.                         "printWhenExpression"=>$data->reportElement->printWhenExpression,
    601. 

  601.                         "link"=>substr($data->hyperlinkReferenceExpression,1,-1),"pattern"=>$data["pattern"],
    602. 

  602.                         "writeHTML"=>$writeHTML,"isPrintRepeatedValues"=>$isPrintRepeatedValues,"rotation"=>$rotation);
    603. 

  603.                 break;
    604. 

  604.         }
    605. 

  605.     }
    606. 

  606. 

  607.     public function element_subReport($data) {
    608. 

  608. //        $b=$data->subreportParameter;
    609. 

  609.                 $srsearcharr=array('.jasper','"',"'",' ','$P{SUBREPORT_DIR}+');
    610. 

  610.                 $srrepalcearr=array('.jrxml',"","",'',$this->arrayParameter['SUBREPORT_DIR']);
    611. 

  611. 

  612.                 if (strpos($data->subreportExpression,'$P{SUBREPORT_DIR}') === false){
    613. 

  613.                     $subreportExpression=str_replace($srsearcharr,$srrepalcearr,$data->subreportExpression);
    614. 

  614.                 }
    615. 

  615.                 else{
    616. 

  616.                     $subreportExpression=str_replace($srsearcharr,$srrepalcearr,$data->subreportExpression);
    617. 

  617.                 }
    618. 

  618.                 $b=array(); 
    619. 

  619.                 foreach($data as $name=>$out){
    620. 

  620.                         if($name=='subreportParameter'){
    621. 

  621.                             $b[$out['name'].'']=$out->subreportParameterExpression;
    622. 

  622.                         }
    623. 

  623.                 }//loop to let multiple parameter pass to subreport pass to subreport
    624. 

  624.                 $this->pointer[]=array("type"=>"subreport", "x"=>$data->reportElement["x"], "y"=>$data->reportElement["y"],
    625. 

  625.                         "width"=>$data->reportElement["width"], "height"=>$data->reportElement["height"],
    626. 

  626.                         "subreportparameterarray"=>$b,"connectionExpression"=>$data->connectionExpression,
    627. 

  627.                         "subreportExpression"=>$subreportExpression,"hidden_type"=>"subreport");
    628. 

  628.     }
    629. 

  629. 

  630.     public function transferDBtoArray($host,$user,$password,$db_or_dsn_name,$cndriver="mysql") {
    631. 

  631.         $this->m=0;
    632. 

  632. 

  633.         if(!$this->connect($host,$user,$password,$db_or_dsn_name,$cndriver))	//connect database
    634. 

  634.         {
    635. 

  635.             echo "Fail to connect database";
    636. 

  636.             exit(0);
    637. 

  637.         }
    638. 

  638.         if($this->debugsql==true) {
    639. 

  639.             echo $this->sql;
    640. 

  640.             die;
    641. 

  641.         }
    642. 

  642. 

  643.         if($cndriver=="odbc") {
    644. 

  644. 

  645.             $result=odbc_exec( $this->myconn,$this->sql);
    646. 

  646.             while ($row = odbc_fetch_array($result)) {
    647. 

  647.                 foreach($this->arrayfield as $out) {
    648. 

  648.                     $this->arraysqltable[$this->m]["$out"]=$row["$out"];
    649. 

  649.                 }
    650. 

  650.                 $this->m++;
    651. 

  651.             }
    652. 

  652.         }elseif($cndriver=="psql") {
    653. 

  653. 

  654. 

  655.             pg_send_query($this->myconn,$this->sql);
    656. 

  656.             $result = pg_get_result($this->myconn);
    657. 

  657.             while ($row = pg_fetch_array($result, NULL, PGSQL_ASSOC)) {
    658. 

  658.                 foreach($this->arrayfield as $out) {
    659. 

  659.                     $this->arraysqltable[$this->m]["$out"]=$row["$out"];
    660. 

  660.                 }
    661. 

  661.                 $this->m++;
    662. 

  662.             }
    663. 

  663.         }
    664. 

  664.         else {
    665. 

  665.             $result = @mysql_query($this->sql); //query from db
    666. 

  666. 

  667.             while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    668. 

  668.                 foreach($this->arrayfield as $out) {
    669. 

  669.                     $this->arraysqltable[$this->m]["$out"]=$row["$out"];
    670. 

  670.                 }
    671. 

  671.                 $this->m++;
    672. 

  672.             }
    673. 

  673.         }
    674. 

  674. 

  675.        	//close connection to db
    676. 

  676. 

  677.     }
    678. 

  678. 

  679.     public function time_to_sec($time) {
    680. 

  680.         $hours = substr($time, 0, -6);
    681. 

  681.         $minutes = substr($time, -5, 2);
    682. 

  682.         $seconds = substr($time, -2);
    683. 

  683. 

  684.         return $hours * 3600 + $minutes * 60 + $seconds;
    685. 

  685.     }
    686. 

  686. 

  687.     public function sec_to_time($seconds) {
    688. 

  688.         $hours = floor($seconds / 3600);
    689. 

  689.         $minutes = floor($seconds % 3600 / 60);
    690. 

  690.         $seconds = $seconds % 60;
    691. 

  691. 

  692.         return sprintf("%d:%02d:%02d", $hours, $minutes, $seconds);
    693. 

  693.     }
    694. 

  694. 

  695.     public function orivariable_calculation() {
    696. 

  696. 

  697.         foreach($this->arrayVariable as $k=>$out) {
    698. 

  698.          //   echo $out['resetType']. "<br/><br/>";
    699. 

  699.             switch($out["calculation"]) {
    700. 

  700.                 case "Sum":
    701. 

  701.                     $sum=0;
    702. 

  702.                     if(isset($this->arrayVariable[$k]['class'])&&$this->arrayVariable[$k]['class']=="java.sql.Time") {
    703. 

  703.                         foreach($this->arraysqltable as $table) {
    704. 

  704.                             $sum=$sum+$this->time_to_sec($table["$out[target]"]);
    705. 

  705.                             //$sum=$sum+substr($table["$out[target]"],0,2)*3600+substr($table["$out[target]"],3,2)*60+substr($table["$out[target]"],6,2);
    706. 

  706.                         }
    707. 

  707.                         //$sum= floor($sum / 3600).":".floor($sum%3600 / 60);
    708. 

  708.                         //if($sum=="0:0"){$sum="00:00";}
    709. 

  709.                         $sum=$this->sec_to_time($sum);
    710. 

  710.                     }
    711. 

  711.                     else {
    712. 

  712.                         foreach($this->arraysqltable as $table) {
    713. 

  713.                             $sum=$sum+$table[$out["target"]];
    714. 

  714.                             $table[$out["target"]];
    715. 

  715.                         }
    716. 

  716.                     }
    717. 

  717. 

  718.                     $this->arrayVariable[$k]["ans"]=$sum;
    719. 

  719.                     break;
    720. 

  720.                 case "Average":
    721. 

  721. 

  722.                     $sum=0;
    723. 

  723. 

  724.                     if(isset($this->arrayVariable[$k]['class'])&&$this->arrayVariable[$k]['class']=="java.sql.Time") {
    725. 

  725.                         $m=0;
    726. 

  726.                         foreach($this->arraysqltable as $table) {
    727. 

  727.                             $m++;
    728. 

  728. 

  729.                             $sum=$sum+$this->time_to_sec($table["$out[target]"]);
    730. 

  730. 

  731. 

  732.                         }
    733. 

  733. 

  734.                         $sum=$this->sec_to_time($sum/$m);
    735. 

  735.                         $this->arrayVariable[$k]["ans"]=$sum;
    736. 

  736. 

  737.                     }
    738. 

  738.                     else {
    739. 

  739.                         $this->arrayVariable[$k]["ans"]=$sum;
    740. 

  740.                         $m=0;
    741. 

  741.                         foreach($this->arraysqltable as $table) {
    742. 

  742.                             $m++;
    743. 

  743.                             $sum=$sum+$table["$out[target]"];
    744. 

  744.                         }
    745. 

  745.                         $this->arrayVariable[$k]["ans"]=$sum/$m;
    746. 

  746. 

  747. 

  748.                     }
    749. 

  749. 

  750. 

  751.                     break;
    752. 

  752.                 case "DistinctCount":
    753. 

  753.                     break;
    754. 

  754.                 case "Lowest":
    755. 

  755. 

  756.                     foreach($this->arraysqltable as $table) {
    757. 

  757.                         $lowest=$table[$out["target"]];
    758. 

  758.                         if($table[$out["target"]]<$lowest) {
    759. 

  759.                             $lowest=$table[$out["target"]];
    760. 

  760.                         }
    761. 

  761.                         $this->arrayVariable[$k]["ans"]=$lowest;
    762. 

  762.                     }
    763. 

  763.                     break;
    764. 

  764.                 case "Highest":
    765. 

  765.                     $out["ans"]=0;
    766. 

  766.                     foreach($this->arraysqltable as $table) {
    767. 

  767.                         if($table[$out["target"]]>$out["ans"]) {
    768. 

  768.                             $this->arrayVariable[$k]["ans"]=$table[$out["target"]];
    769. 

  769.                         }
    770. 

  770.                     }
    771. 

  771.                     break;
    772. 

  772. //### A Count for groups, as a variable. Not tested yet, but seemed to work in print_r()
    773. 

  773. 				case "Count":
    774. 

  774. 					$value=$this->arrayVariable[$k]["ans"];
    775. 

  775. 					if( $this->arraysqltable[$this->global_pointer][$this->group_pointer]!=$this->arraysqltable[$this->global_pointer-1][$this->group_pointer])
    776. 

  776.                        $value=0;
    777. 

  777. 					$value++;
    778. 

  778.                     $this->arrayVariable[$k]["ans"]=$value;
    779. 

  779. 				break;	
    780. 

  780. //### End of modification				
    781. 

  781.                 default:
    782. 

  782.                     $out["target"]=0;		//other cases needed, temporary leave 0 if not suitable case
    783. 

  783.                     break;
    784. 

  784. 

  785.             }
    786. 

  786.         }
    787. 

  787.     }
    788. 

  788. 

  789. 

  790.       public function variable_calculation($rowno) {
    791. 

  791. //   $this->variable_calculation($rownum, $this->arraysqltable[$this->global_pointer][$this->group_pointer]);
    792. 

  792.      //   print_r($this->arraysqltable);
    793. 

  793. 

  794. 

  795.         foreach($this->arrayVariable as $k=>$out) {
    796. 

  796.          //   echo $out['resetType']. "<br/><br/>";
    797. 

  797.             switch($out["calculation"]) {
    798. 

  798.                 case "Sum":
    799. 

  799. 

  800.                          $value=$this->arrayVariable[$k]["ans"];
    801. 

  801.                     if($out['resetType']==''){
    802. 

  802.                             if(isset($this->arrayVariable[$k]['class'])&&$this->arrayVariable[$k]['class']=="java.sql.Time") {
    803. 

  803.                             //    foreach($this->arraysqltable as $table) {
    804. 

  804.                                     $value=$this->time_to_sec($value);
    805. 

  805. 

  806.                                     $value+=$this->time_to_sec($this->arraysqltable[$rowno]["$out[target]"]);
    807. 

  807.                                     //$sum=$sum+substr($table["$out[target]"],0,2)*3600+substr($table["$out[target]"],3,2)*60+substr($table["$out[target]"],6,2);
    808. 

  808.                                // }
    809. 

  809.                                 //$sum= floor($sum / 3600).":".floor($sum%3600 / 60);
    810. 

  810.                                 //if($sum=="0:0"){$sum="00:00";}
    811. 

  811.                                 $value=$this->sec_to_time($value);
    812. 

  812.                             }
    813. 

  813.                             else {
    814. 

  814.                                // foreach($this->arraysqltable as $table) {
    815. 

  815.                                          $value+=$this->arraysqltable[$rowno]["$out[target]"];
    816. 

  816. 

  817.                               //      $table[$out["target"]];
    818. 

  818.                              //   }
    819. 

  819.                             }
    820. 

  820.                     }// finisish resettype=''
    821. 

  821.                     else //reset type='group'
    822. 

  822.                     {if( $this->arraysqltable[$this->global_pointer][$this->group_pointer]!=$this->arraysqltable[$this->global_pointer-1][$this->group_pointer])
    823. 

  823.                              $value=0;
    824. 

  824.                       //    echo $this->global_pointer.",".$this->group_pointer.",".$this->arraysqltable[$this->global_pointer][$this->group_pointer].",".$this->arraysqltable[$this->global_pointer-1][$this->group_pointer].",".$this->arraysqltable[$rowno]["$out[target]"];
    825. 

  825.                                  if(isset($this->arrayVariable[$k]['class'])&&$this->arrayVariable[$k]['class']=="java.sql.Time") {
    826. 

  826.                                       $value+=$this->time_to_sec($this->arraysqltable[$rowno]["$out[target]"]);
    827. 

  827.                                 //$sum= floor($sum / 3600).":".floor($sum%3600 / 60);
    828. 

  828.                                 //if($sum=="0:0"){$sum="00:00";}
    829. 

  829.                                 $value=$this->sec_to_time($value);
    830. 

  830.                             }
    831. 

  831.                             else {
    832. 

  832.                                       $value+=$this->arraysqltable[$rowno]["$out[target]"];
    833. 

  833.                             }
    834. 

  834.                     }
    835. 

  835. 

  836. 

  837.                     $this->arrayVariable[$k]["ans"]=$value;
    838. 

  838.               //      echo ",$value<br/>";
    839. 

  839.                     break;
    840. 

  840.                 case "Average":
    841. 

  841. 

  842.                     $sum=0;
    843. 

  843. 

  844.                     if(isset($this->arrayVariable[$k]['class'])&&$this->arrayVariable[$k]['class']=="java.sql.Time") {
    845. 

  845.                         $m=0;
    846. 

  846.                         //$value=$this->arrayVariable[$k]["ans"];
    847. 

  847.                         //$value=$this->time_to_sec($value);
    848. 

  848.                         //$value+=$this->time_to_sec($this->arraysqltable[$rowno]["$out[target]"]);
    849. 

  849. 

  850.                         foreach($this->arraysqltable as $table) {
    851. 

  851.                             $m++;
    852. 

  852. 

  853.                              $sum=$sum+$this->time_to_sec($table["$out[target]"]);
    854. 

  854.                            // echo ",".$table["$out[target]"]."<br/>";
    855. 

  855. 

  856.                         }
    857. 

  857. 

  858. 

  859.                         $sum=$this->sec_to_time($sum/$m);
    860. 

  860.                      // echo "Total:".$sum."<br/>";
    861. 

  861.                          $this->arrayVariable[$k]["ans"]=$sum;
    862. 

  862. 

  863. 

  864.                     }
    865. 

  865.                     else {
    866. 

  866.                         $this->arrayVariable[$k]["ans"]=$sum;
    867. 

  867.                         $m=0;
    868. 

  868.                         foreach($this->arraysqltable as $table) {
    869. 

  869.                             $m++;
    870. 

  870.                             $sum=$sum+$table["$out[target]"];
    871. 

  871.                         }
    872. 

  872.                         $this->arrayVariable[$k]["ans"]=$sum/$m;
    873. 

  873. 

  874. 

  875.                     }
    876. 

  876. 

  877. 

  878.                     break;
    879. 

  879.                 case "DistinctCount":
    880. 

  880.                     break;
    881. 

  881.                 case "Lowest":
    882. 

  882. 

  883.                     foreach($this->arraysqltable as $table) {
    884. 

  884.                         $lowest=$table[$out["target"]];
    885. 

  885.                         if($table[$out["target"]]<$lowest) {
    886. 

  886.                             $lowest=$table[$out["target"]];
    887. 

  887.                         }
    888. 

  888.                         $this->arrayVariable[$k]["ans"]=$lowest;
    889. 

  889.                     }
    890. 

  890.                     break;
    891. 

  891.                 case "Highest":
    892. 

  892.                     $out["ans"]=0;
    893. 

  893.                     foreach($this->arraysqltable as $table) {
    894. 

  894.                         if($table[$out["target"]]>$out["ans"]) {
    895. 

  895.                             $this->arrayVariable[$k]["ans"]=$table[$out["target"]];
    896. 

  896.                         }
    897. 

  897.                     }
    898. 

  898.                     break;
    899. 

  899. //### A Count for groups, as a variable. Not tested yet, but seemed to work in print_r()					
    900. 

  900.                 case "Count":
    901. 

  901. 					$value=$this->arrayVariable[$k]["ans"];
    902. 

  902. 					if( $this->arraysqltable[$this->global_pointer][$this->group_pointer]!=$this->arraysqltable[$this->global_pointer-1][$this->group_pointer])
    903. 

  903.                        $value=0;
    904. 

  904. 					$value++;
    905. 

  905.                     $this->arrayVariable[$k]["ans"]=$value;
    906. 

  906. 				break;
    907. 

  907. //### End of modification
    908. 

  908.                 default:
    909. 

  909.                     $out["target"]=0;		//other cases needed, temporary leave 0 if not suitable case
    910. 

  910.                     break;
    911. 

  911. 

  912.             }
    913. 

  913.         }
    914. 

  914.     }
    915. 

  915. 

  916. 

  917.     public function outpage($out_method="I",$filename="") {
    918. 

  918. 		
    919. 

  919.         if($this->lang=="cn") {
    920. 

  920.             if($this->arrayPageSetting["orientation"]=="P") {
    921. 

  921.                 $this->pdf=new PDF_Unicode($this->arrayPageSetting["orientation"],'pt',array($this->arrayPageSetting["pageWidth"],$this->arrayPageSetting["pageHeight"]));
    922. 

  922.                 $this->pdf->AddUniGBhwFont("uGB");
    923. 

  923.             }
    924. 

  924.             else {
    925. 

  925.                 $this->pdf=new PDF_Unicode($this->arrayPageSetting["orientation"],'pt',array($this->arrayPageSetting["pageHeight"],$this->arrayPageSetting["pageWidth"]));
    926. 

  926.                 $this->pdf->AddUniGBhwFont("uGB");
    927. 

  927.             }
    928. 

  928.         }
    929. 

  929.         else {
    930. 

  930. 

  931.             if($this->pdflib=="TCPDF") {
    932. 

  932.                 if($this->arrayPageSetting["orientation"]=="P")
    933. 

  933.                     $this->pdf=new TCPDF($this->arrayPageSetting["orientation"],'pt',array($this->arrayPageSetting["pageWidth"],$this->arrayPageSetting["pageHeight"]));
    934. 

  934.                 else
    935. 

  935.                     $this->pdf=new TCPDF($this->arrayPageSetting["orientation"],'pt',array($this->arrayPageSetting["pageHeight"],$this->arrayPageSetting["pageWidth"]));
    936. 

  936.                 $this->pdf->setPrintHeader(false);
    937. 

  937.                 $this->pdf->setPrintFooter(false);
    938. 

  938.             }elseif($this->pdflib=="FPDF") {
    939. 

  939.                 if($this->arrayPageSetting["orientation"]=="P")
    940. 

  940.                     $this->pdf=new FPDF($this->arrayPageSetting["orientation"],'pt',array($this->arrayPageSetting["pageWidth"],$this->arrayPageSetting["pageHeight"]));
    941. 

  941.                 else
    942. 

  942.                     $this->pdf=new FPDF($this->arrayPageSetting["orientation"],'pt',array($this->arrayPageSetting["pageHeight"],$this->arrayPageSetting["pageWidth"]));
    943. 

  943.             }
    944. 

  944.             elseif($this->pdflib=="XLS"){
    945. 

  945.                 
    946. 

  946. 

  947.             
    948. 

  948.                  include dirname(__FILE__)."/ExportXLS.inc.php";
    949. 

  949.                 $xls= new ExportXLS($this,$filename);
    950. 

  950.                 die;
    951. 

  951. 

  952. 

  953.             }
    954. 

  954.         }
    955. 

  955.         //$this->arrayPageSetting["language"]=$xml_path["language"];
    956. 

  956.         $this->pdf->SetLeftMargin($this->arrayPageSetting["leftMargin"]);
    957. 

  957.         $this->pdf->SetRightMargin($this->arrayPageSetting["rightMargin"]);
    958. 

  958.         $this->pdf->SetTopMargin($this->arrayPageSetting["topMargin"]);
    959. 

  959.         $this->pdf->SetAutoPageBreak(true,$this->arrayPageSetting["bottomMargin"]/2);
    960. 

  960.         $this->pdf->AliasNbPages();
    961. 

  961. 

  962. 

  963.         $this->global_pointer=0;
    964. 

  964. 

  965.         foreach ($this->arrayband as $band) {
    966. 

  966. //            $this->currentband=$band["name"]; // to know current where current band in!
    967. 

  967.             switch($band["name"]) {
    968. 

  968.                 case "title":
    969. 

  969.                   if($this->arraytitle[0]["height"]>0)
    970. 

  970.                     $this->title();
    971. 

  971.                     break;
    972. 

  972.                 case "pageHeader":
    973. 

  973.                     if(!$this->newPageGroup) {
    974. 

  974.                         $headerY = $this->arrayPageSetting["topMargin"]+$this->arraypageHeader[0]["height"];
    975. 

  975.                         $this->pageHeader($headerY);
    976. 

  976.                     }else {
    977. 

  977.                         $this->pageHeaderNewPage();
    978. 

  978.                     }
    979. 

  979.                     break;
    980. 

  980.                 case "detail":
    981. 

  981.                     if(!$this->newPageGroup) {
    982. 

  982.                         $this->detail();
    983. 

  983.                     }else {
    984. 

  984.                         $this->detailNewPage();
    985. 

  985.                         //$this->groupNewPage();
    986. 

  986.                     }
    987. 

  987.                     break;
    988. 

  988. 

  989.                 case "group":
    990. 

  990.                     $this->group_pointer=$band["groupExpression"];
    991. 

  991.                     $this->group_name=$band["gname"];
    992. 

  992.                     break;
    993. 

  993. 

  994. 

  995. 

  996. 

  997. 

  998.                     default:
    999. 

  999.                 break;
    1000. 

  1000. 

  1001.             }
    1002. 

  1002. 

  1003.         }
    1004. 

  1004. 

  1005.         if($filename=="")
    1006. 

  1006.             $filename=$this->arrayPageSetting["name"].".pdf";
    1007. 

  1007. 

  1008.          $this->disconnect($this->cndriver);
    1009. 

  1009.         return $this->pdf->Output($filename,$out_method);	//send out the complete page
    1010. 

  1010. 

  1011.     }
    1012. 

  1012. public function element_pieChart($data){
    1013. 

  1013. 

  1014.           $height=$data->chart->reportElement["height"];
    1015. 

  1015.           $width=$data->chart->reportElement["width"];
    1016. 

  1016.          $x=$data->chart->reportElement["x"];
    1017. 

  1017.          $y=$data->chart->reportElement["y"];
    1018. 

  1018.           $charttitle['position']=$data->chart->chartTitle['position'];
    1019. 

  1019. 

  1020.            $charttitle['text']=$data->chart->chartTitle->titleExpression;
    1021. 

  1021.           $chartsubtitle['text']=$data->chart->chartSubTitle->subtitleExpression;
    1022. 

  1022.           $chartLegendPos=$data->chart->chartLegend['position'];
    1023. 

  1023. 

  1024.           $dataset=$data->pieDataset->dataset->datasetRun['subDataset'];
    1025. 

  1025. 

  1026.           $seriesexp=$data->pieDataset->keyExpression;
    1027. 

  1027.           $valueexp=$data->pieDataset->valueExpression;
    1028. 

  1028.           $bb=$data->pieDataset->dataset->datasetRun['subDataset'];
    1029. 

  1029.           $sql=$this->arraysubdataset["$bb"]['sql'];
    1030. 

  1030. 

  1031.          // $ylabel=$data->linePlot->valueAxisLabelExpression;
    1032. 

  1032. 

  1033. 

  1034.           $param=array();
    1035. 

  1035.           foreach($data->categoryDataset->dataset->datasetRun->datasetParameter as $tag=>$value){
    1036. 

  1036.               $param[]=  array("$value[name]"=>$value->datasetParameterExpression);
    1037. 

  1037.           }
    1038. 

  1038. //          print_r($param);
    1039. 

  1039. 

  1040.          $this->pointer[]=array('type'=>'PieChart','x'=>$x,'y'=>$y,'height'=>$height,'width'=>$width,'charttitle'=>$charttitle,
    1041. 

  1041.             'chartsubtitle'=> $chartsubtitle,
    1042. 

  1042.                'chartLegendPos'=> $chartLegendPos,'dataset'=>$dataset,'seriesexp'=>$seriesexp,
    1043. 

  1043.             'valueexp'=>$valueexp,'param'=>$param,'sql'=>$sql,'ylabel'=>$ylabel);
    1044. 

  1044. 

  1045.     }
    1046. 

  1046.     public function element_pie3DChart($data){
    1047. 

  1047. 

  1048. 

  1049.     }
    1050. 

  1050. 

  1051.     public function element_Chart($data,$type){
    1052. 

  1052.    $seriesexp=array();
    1053. 

  1053.           $catexp=array();
    1054. 

  1054.           $valueexp=array();
    1055. 

  1055.           $labelexp=array();
    1056. 

  1056.           $height=$data->chart->reportElement["height"];
    1057. 

  1057.           $width=$data->chart->reportElement["width"];
    1058. 

  1058.          $x=$data->chart->reportElement["x"];
    1059. 

  1059.          $y=$data->chart->reportElement["y"];
    1060. 

  1060.           $charttitle['position']=$data->chart->chartTitle['position'];
    1061. 

  1061.                     $titlefontname=$data->chart->chartTitle->font['pdfFontName'];
    1062. 

  1062.           $titlefontsize=$data->chart->chartTitle->font['size'];
    1063. 

  1063.            $charttitle['text']=$data->chart->chartTitle->titleExpression;
    1064. 

  1064.           $chartsubtitle['text']=$data->chart->chartSubTitle->subtitleExpression;
    1065. 

  1065.           $chartLegendPos=$data->chart->chartLegend['position'];
    1066. 

  1066.           $dataset=$data->categoryDataset->dataset->datasetRun['subDataset'];
    1067. 

  1067.           $subcatdataset=$data->categoryDataset;
    1068. 

  1068.           //echo $subcatdataset;
    1069. 

  1069.           $i=0;
    1070. 

  1070.           foreach($subcatdataset as $cat => $catseries){
    1071. 

  1071.             foreach($catseries as $a => $series){
    1072. 

  1072.                if("$series->categoryExpression"!=''){
    1073. 

  1073.                 array_push( $seriesexp,"$series->seriesExpression");
    1074. 

  1074.                 array_push( $catexp,"$series->categoryExpression");
    1075. 

  1075.                 array_push( $valueexp,"$series->valueExpression");
    1076. 

  1076.                 array_push( $labelexp,"$series->labelExpression");
    1077. 

  1077.                }
    1078. 

  1078. 

  1079.             }
    1080. 

  1080. 

  1081.           }
    1082. 

  1082. 

  1083. 

  1084.           $bb=$data->categoryDataset->dataset->datasetRun['subDataset'];
    1085. 

  1085.           $sql=$this->arraysubdataset[$bb]['sql'];
    1086. 

  1086.           switch($type){
    1087. 

  1087.             case "barChart":
    1088. 

  1088.                 $ylabel=$data->barPlot->valueAxisLabelExpression;
    1089. 

  1089.                 $xlabel=$data->barPlot->categoryAxisLabelExpression;
    1090. 

  1090.                 $maxy=$data->barPlot->rangeAxisMaxValueExpression;
    1091. 

  1091.                 $miny=$data->barPlot->rangeAxisMinValueExpression;
    1092. 

  1092.                 break;
    1093. 

  1093.             case "lineChart":
    1094. 

  1094.                 $ylabel=$data->linePlot->valueAxisLabelExpression;
    1095. 

  1095.                 $xlabel=$data->linePlot->categoryAxisLabelExpression;
    1096. 

  1096.                 $maxy=$data->linePlot->rangeAxisMaxValueExpression;
    1097. 

  1097.                 $miny=$data->linePlot->rangeAxisMinValueExpression;
    1098. 

  1098.                 $showshape=$data->linePlot["isShowShapes"];
    1099. 

  1099.                 break;
    1100. 

  1100.              case "stackedAreaChart":
    1101. 

  1101.                       $ylabel=$data->areaPlot->valueAxisLabelExpression;
    1102. 

  1102.                         $xlabel=$data->areaPlot->categoryAxisLabelExpression;
    1103. 

  1103.                         $maxy=$data->areaPlot->rangeAxisMaxValueExpression;
    1104. 

  1104.                         $miny=$data->areaPlot->rangeAxisMinValueExpression;
    1105. 

  1105.                         
    1106. 

  1106.                 
    1107. 

  1107.                  break;
    1108. 

  1108.           }
    1109. 

  1109.           
    1110. 

  1110. 

  1111. 

  1112.           $param=array();
    1113. 

  1113.           foreach($data->categoryDataset->dataset->datasetRun->datasetParameter as $tag=>$value){
    1114. 

  1114.               $param[]=  array("$value[name]"=>$value->datasetParameterExpression);
    1115. 

  1115.           }
    1116. 

  1116.           if($maxy!='' && $miny!=''){
    1117. 

  1117.               $scalesetting=array(0=>array("Min"=>$miny,"Max"=>$maxy));
    1118. 

  1118.           }
    1119. 

  1119.           else
    1120. 

  1120.               $scalesetting="";
    1121. 

  1121. 

  1122.          $this->pointer[]=array('type'=>$type,'x'=>$x,'y'=>$y,'height'=>$height,'width'=>$width,'charttitle'=>$charttitle,
    1123. 

  1123.             'chartsubtitle'=> $chartsubtitle,
    1124. 

  1124.                'chartLegendPos'=> $chartLegendPos,'dataset'=>$dataset,'seriesexp'=>$seriesexp,
    1125. 

  1125.              'catexp'=>$catexp,'valueexp'=>$valueexp,'labelexp'=>$labelexp,'param'=>$param,'sql'=>$sql,'xlabel'=>$xlabel,'showshape'=>$showshape,
    1126. 

  1126.              'titlefontsize'=>$titlefontname,'titlefontsize'=>$titlefontsize,'scalesetting'=>$scalesetting);
    1127. 

  1127. 

  1128. 

  1129.     }
    1130. 

  1130. //    public function element_lineChart($data){
    1131. 

  1131. //
    1132. 

  1132. //           $seriesexp=array();
    1133. 

  1133. //          $catexp=array();
    1134. 

  1134. //          $valueexp=array();
    1135. 

  1135. //          $labelexp=array();
    1136. 

  1136. //          $height=$data->chart->reportElement["height"];
    1137. 

  1137. //          $width=$data->chart->reportElement["width"];
    1138. 

  1138. //         $x=$data->chart->reportElement["x"];
    1139. 

  1139. //         $y=$data->chart->reportElement["y"];
    1140. 

  1140. //          $charttitle['position']=$data->chart->chartTitle['position'];
    1141. 

  1141. //                    $titlefontname=$data->chart->chartTitle->font['pdfFontName'];
    1142. 

  1142. //          $titlefontsize=$data->chart->chartTitle->font['size'];
    1143. 

  1143. //           $charttitle['text']=$data->chart->chartTitle->titleExpression;
    1144. 

  1144. //          $chartsubtitle['text']=$data->chart->chartSubTitle->subtitleExpression;
    1145. 

  1145. //          $chartLegendPos=$data->chart->chartLegend['position'];
    1146. 

  1146. //          $dataset=$data->categoryDataset->dataset->datasetRun['subDataset'];
    1147. 

  1147. //          $subcatdataset=$data->categoryDataset;
    1148. 

  1148. //          //echo $subcatdataset;
    1149. 

  1149. //          $i=0;
    1150. 

  1150. //          foreach($subcatdataset as $cat => $catseries){
    1151. 

  1151. //            foreach($catseries as $a => $series){
    1152. 

  1152. //               if("$series->categoryExpression"!=''){
    1153. 

  1153. //                array_push( $seriesexp,"$series->seriesExpression");
    1154. 

  1154. //                array_push( $catexp,"$series->categoryExpression");
    1155. 

  1155. //                array_push( $valueexp,"$series->valueExpression");
    1156. 

  1156. //                array_push( $labelexp,"$series->labelExpression");
    1157. 

  1157. //               }
    1158. 

  1158. //
    1159. 

  1159. //            }
    1160. 

  1160. //
    1161. 

  1161. //          }
    1162. 

  1162. //
    1163. 

  1163. //
    1164. 

  1164. //          $bb=$data->categoryDataset->dataset->datasetRun['subDataset'];
    1165. 

  1165. //          $sql=$this->arraysubdataset[$bb]['sql'];
    1166. 

  1166. //          $ylabel=$data->linePlot->valueAxisLabelExpression;
    1167. 

  1167. //          $xlabel=$data->linePlot->categoryAxisLabelExpression;
    1168. 

  1168. //        $showshape=$data->linePlot["isShowShapes"];
    1169. 

  1169. //
    1170. 

  1170. //
    1171. 

  1171. //          $param=array();
    1172. 

  1172. //          foreach($data->categoryDataset->dataset->datasetRun->datasetParameter as $tag=>$value){
    1173. 

  1173. //              $param[]=  array("$value[name]"=>$value->datasetParameterExpression);
    1174. 

  1174. //          }
    1175. 

  1175. //          $maxy=$data->barPlot->rangeAxisMaxValueExpression;
    1176. 

  1176. //          $miny=$data->barPlot->rangeAxisMinValueExpression;
    1177. 

  1177. //          if($maxy!='' && $miny!=''){
    1178. 

  1178. //              $scalesetting=array(0=>array("Min"=>$miny,"Max"=>$maxy));
    1179. 

  1179. //          }
    1180. 

  1180. //          else
    1181. 

  1181. //              $scalesetting="";
    1182. 

  1182. //
    1183. 

  1183. //         $this->pointer[]=array('type'=>'LineChart','x'=>$x,'y'=>$y,'height'=>$height,'width'=>$width,'charttitle'=>$charttitle,
    1184. 

  1184. //            'chartsubtitle'=> $chartsubtitle,
    1185. 

  1185. //               'chartLegendPos'=> $chartLegendPos,'dataset'=>$dataset,'seriesexp'=>$seriesexp,
    1186. 

  1186. //             'catexp'=>$catexp,'valueexp'=>$valueexp,'labelexp'=>$labelexp,'param'=>$param,'sql'=>$sql,'xlabel'=>$xlabel,'showshape'=>$showshape,
    1187. 

  1187. //             'titlefontsize'=>$titlefontname,'titlefontsize'=>$titlefontsize,'scalesetting'=>$scalesetting);
    1188. 

  1188. //
    1189. 

  1189. //    }
    1190. 

  1190. 

  1191. //
    1192. 

  1192. //
    1193. 

  1193. //    public function element_barChart($data,$type='BarChart'){
    1194. 

  1194. //
    1195. 

  1195. //           $seriesexp=array();
    1196. 

  1196. //          $catexp=array();
    1197. 

  1197. //          $valueexp=array();
    1198. 

  1198. //          $labelexp=array();
    1199. 

  1199. //          $height=$data->chart->reportElement["height"];
    1200. 

  1200. //          $width=$data->chart->reportElement["width"];
    1201. 

  1201. //          $x=$data->chart->reportElement["x"];
    1202. 

  1202. //          $y=$data->chart->reportElement["y"];
    1203. 

  1203. //          $charttitle['position']=$data->chart->chartTitle['position'];
    1204. 

  1204. //          $titlefontname=$data->chart->chartTitle->font['pdfFontName'];
    1205. 

  1205. //          $titlefontsize=$data->chart->chartTitle->font['size'];
    1206. 

  1206. //          $charttitle['text']=$data->chart->chartTitle->titleExpression;
    1207. 

  1207. //          $chartsubtitle['text']=$data->chart->chartSubTitle->subtitleExpression;
    1208. 

  1208. //
    1209. 

  1209. //
    1210. 

  1210. //          $chartLegendPos=$data->chart->chartLegend['position'];
    1211. 

  1211. //          $dataset=$data->categoryDataset->dataset->datasetRun['subDataset'];
    1212. 

  1212. //          $subcatdataset=$data->categoryDataset;
    1213. 

  1213. //
    1214. 

  1214. //          //echo $subcatdataset;
    1215. 

  1215. //          foreach($subcatdataset as $cat => $catseries){
    1216. 

  1216. //            foreach($catseries as $a => $series){
    1217. 

  1217. //               if("$series->categoryExpression"!=''){
    1218. 

  1218. //                array_push( $seriesexp,"$series->seriesExpression");
    1219. 

  1219. //                array_push( $catexp,"$series->categoryExpression");
    1220. 

  1220. //                array_push( $valueexp,"$series->valueExpression");
    1221. 

  1221. //                array_push( $labelexp,"$series->labelExpression");
    1222. 

  1222. //               }
    1223. 

  1223. //            }
    1224. 

  1224. //
    1225. 

  1225. //          }
    1226. 

  1226. //
    1227. 

  1227. //          $bb=$data->categoryDataset->dataset->datasetRun['subDataset'];
    1228. 

  1228. //          $sql=$this->arraysubdataset[$bb]['sql'];
    1229. 

  1229. //         $ylabel=$data->barPlot->valueAxisLabelExpression;
    1230. 

  1230. //          $xlabel=$data->barPlot->categoryAxisLabelExpression;
    1231. 

  1231. //          $maxy=$data->barPlot->rangeAxisMaxValueExpression;
    1232. 

  1232. //          $miny=$data->barPlot->rangeAxisMinValueExpression;
    1233. 

  1233. //          if($maxy!='' && $miny!=''){
    1234. 

  1234. //              $scalesetting=array(0=>array("Min"=>$miny,"Max"=>$maxy));
    1235. 

  1235. //          }
    1236. 

  1236. //          else
    1237. 

  1237. //              $scalesetting="";
    1238. 

  1238. //
    1239. 

  1239. //          $param=array();
    1240. 

  1240. //          foreach($data->categoryDataset->dataset->datasetRun->datasetParameter as $tag=>$value){
    1241. 

  1241. //              $param[]=  array("$value[name]"=>$value->datasetParameterExpression);
    1242. 

  1242. //          }
    1243. 

  1243. ////          print_r($param);
    1244. 

  1244. //
    1245. 

  1245. //         $this->pointer[]=array('type'=>$type,'x'=>$x,'y'=>$y,'height'=>$height,'width'=>$width,'charttitle'=>$charttitle,
    1246. 

  1246. //            'chartsubtitle'=> $chartsubtitle,
    1247. 

  1247. //               'chartLegendPos'=> $chartLegendPos,'dataset'=>$dataset,'seriesexp'=>$seriesexp,
    1248. 

  1248. //             'catexp'=>$catexp,'valueexp'=>$valueexp,'labelexp'=>$labelexp,'param'=>$param,'sql'=>$sql,'ylabel'=>$ylabel,'xlabel'=>$xlabel,
    1249. 

  1249. //             'titlefontsize'=>$titlefontname,'titlefontsize'=>$titlefontsize,'scalesetting'=>$scalesetting);
    1250. 

  1250. //
    1251. 

  1251. //    }
    1252. 

  1252. 

  1253. 

  1254. public function setChartColor(){
    1255. 

  1255. 

  1256.     $k=0;
    1257. 

  1257. $this->chart->setColorPalette($k,0,255,88);$k++;
    1258. 

  1258. $this->chart->setColorPalette($k,121,88,255);$k++;
    1259. 

  1259. $this->chart->setColorPalette($k,255,91,99);$k++;
    1260. 

  1260. $this->chart->setColorPalette($k,255,0,0);$k++;
    1261. 

  1261. $this->chart->setColorPalette($k,0,0,100);$k++;
    1262. 

  1262. $this->chart->setColorPalette($k,200,0,100);$k++;
    1263. 

  1263. $this->chart->setColorPalette($k,0,100,0);$k++;
    1264. 

  1264. $this->chart->setColorPalette($k,100,0,0);$k++;
    1265. 

  1265. $this->chart->setColorPalette($k,200,0,0);$k++;
    1266. 

  1266. $this->chart->setColorPalette($k,0,0,200);$k++;
    1267. 

  1267. $this->chart->setColorPalette($k,50,0,0);$k++;
    1268. 

  1268. $this->chart->setColorPalette($k,100,0,50);$k++;
    1269. 

  1269. $this->chart->setColorPalette($k,0,50,0);$k++;
    1270. 

  1270. $this->chart->setColorPalette($k,100,50,0);$k++;
    1271. 

  1271. $this->chart->setColorPalette($k,50,100,50);$k++;
    1272. 

  1272. $this->chart->setColorPalette($k,0,255,0);$k++;
    1273. 

  1273. $this->chart->setColorPalette($k,100,50,0);$k++;
    1274. 

  1274. $this->chart->setColorPalette($k,200,100,50);$k++;
    1275. 

  1275. $this->chart->setColorPalette($k,100,50,200);$k++;
    1276. 

  1276. $this->chart->setColorPalette($k,0,200,0);$k++;
    1277. 

  1277. $this->chart->setColorPalette($k,200,100,0);$k++;
    1278. 

  1278. $this->chart->setColorPalette($k,200,50,50);$k++;
    1279. 

  1279. $this->chart->setColorPalette($k,50,50,50);$k++;
    1280. 

  1280. $this->chart->setColorPalette($k,200,100,100);$k++;
    1281. 

  1281. $this->chart->setColorPalette($k,50,50,100);$k++;
    1282. 

  1282. $this->chart->setColorPalette($k,100,0,200);$k++;
    1283. 

  1283. $this->chart->setColorPalette($k,200,50,100);$k++;
    1284. 

  1284. $this->chart->setColorPalette($k,100,100,200);$k++;
    1285. 

  1285. $this->chart->setColorPalette($k,0,0,50);$k++;
    1286. 

  1286. $this->chart->setColorPalette($k,50,250,200);$k++;
    1287. 

  1287. $this->chart->setColorPalette($k,100,250,200);$k++;
    1288. 

  1288. $this->chart->setColorPalette($k,10,10,10);$k++;
    1289. 

  1289. $this->chart->setColorPalette($k,20,30,50);$k++;
    1290. 

  1290. $this->chart->setColorPalette($k,80,150,200);$k++;
    1291. 

  1291. $this->chart->setColorPalette($k,30,70,20);$k++;
    1292. 

  1292. $this->chart->setColorPalette($k,33,60,0);$k++;
    1293. 

  1293. $this->chart->setColorPalette($k,150,0,200);$k++;
    1294. 

  1294. $this->chart->setColorPalette($k,20,60,50);$k++;
    1295. 

  1295. $this->chart->setColorPalette($k,50,250,250);$k++;
    1296. 

  1296. $this->chart->setColorPalette($k,33,250,70);$k++;
    1297. 

  1297. 

  1298. }
    1299. 

  1299. 

  1300. 

  1301. public function showLineChart($data,$y_axis){
    1302. 

  1302.     global $tmpchartfolder,$pchartfolder;
    1303. 

  1303. 

  1304. 

  1305.     if($pchartfolder=="")
    1306. 

  1306.         $pchartfolder="./pchart2";
    1307. 

  1307. //echo "$pchartfolder/class/pData.class.php";die;
    1308. 

  1308. 

  1309.         include_once("$pchartfolder/class/pData.class.php");
    1310. 

  1310.         include_once("$pchartfolder/class/pDraw.class.php");
    1311. 

  1311.         include_once("$pchartfolder/class/pImage.class.php");
    1312. 

  1312. 

  1313.     if($tmpchartfolder=="")
    1314. 

  1314.          $tmpchartfolder=$pchartfolder."/cache";
    1315. 

  1315. 

  1316.      $w=$data['width']+0;
    1317. 

  1317.      $h=$data['height']+0;
    1318. 

  1318. 

  1319. 

  1320. 

  1321.      $legendpos=$data['chartLegendPos'];
    1322. 

  1322.      //$legendpos="Right";
    1323. 

  1323.      $seriesexp=$data['seriesexp'];
    1324. 

  1324.      $catexp=$data['catexp'];
    1325. 

  1325.      $valueexp=$data['valueexp'];
    1326. 

  1326.      $labelexp=$data['labelexp'];
    1327. 

  1327.      $ylabel=$data['ylabel'].'';
    1328. 

  1328.      $xlabel=$data['xlabel'].'';
    1329. 

  1329.      $ylabel = str_replace(array('"',"'"),'',$ylabel);
    1330. 

  1330.      $xlabel = str_replace(array('"',"'"),'',$xlabel);
    1331. 

  1331.      $scalesetting=$data['scalesetting'];
    1332. 

  1332. 

  1333. 

  1334.      $x=$data['x'];
    1335. 

  1335.      $y1=$data['y'];
    1336. 

  1336.      $legendx=0;
    1337. 

  1337.      $legendy=0;
    1338. 

  1338. 

  1339.     $titlefontname=$data['titlefontname'].'';
    1340. 

  1340.     $titlefontsize=$data['titlefontsize']+0;
    1341. 

  1341. 

  1342. 

  1343.     $DataSet = new pData();
    1344. 

  1344. 

  1345.     foreach($catexp as $a=>$b)
    1346. 

  1346.        $catexp1[]=  str_replace(array('"',"'"), '',$b);
    1347. 

  1347. 

  1348.     $n=0;
    1349. 

  1349. 

  1350.     $DataSet->addPoints($catexp1,'S00');
    1351. 

  1351.     $DataSet->setSerieDescription('S00','asdasd');
    1352. 

  1352. 

  1353.     //$DataSet->AddSerie('S0');
    1354. 

  1354.     //$DataSet->SetSerieName('S0',"Cat");
    1355. 

  1355.     $DataSet->setAbscissa('S00');
    1356. 

  1356.     $n=$n+1;
    1357. 

  1357. 

  1358.     $ds=trim($data['dataset']);
    1359. 

  1359. 

  1360. 

  1361.     if($ds!=""){
    1362. 

  1362.               $sql=$this->subdataset[$ds];
    1363. 

  1363.         $param=$data['param'];
    1364. 

  1364.         foreach($param as $p)
    1365. 

  1365.             foreach($p as $tag =>$value)
    1366. 

  1366.                 $sql=str_replace('$P{'.$tag.'}',$value, $sql);
    1367. 

  1367.             $sql=$this->changeSubDataSetSql($sql);
    1368. 

  1368. 

  1369.         }
    1370. 

  1370.     else
    1371. 

  1371.         $sql=$this->sql;
    1372. 

  1372. 

  1373.     $result = @mysql_query($sql); //query from db
    1374. 

  1374.     $chartdata=array();
    1375. 

  1375.     $i=0;
    1376. 

  1376. //echo $sql."<br/><br/>";
    1377. 

  1377.     $seriesname=array();
    1378. 

  1378.     while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    1379. 

  1379. 

  1380.                 $j=0;
    1381. 

  1381.                 foreach($row as $key => $value){
    1382. 

  1382.                     //$chartdata[$j][$i]=$value;
    1383. 

  1383.                     if($value=='')
    1384. 

  1384.                         $value=0;
    1385. 

  1385.                     if($key==str_replace(array('$F{','}'),'',$seriesexp[0]))
    1386. 

  1386.                     array_push($seriesname,$value);
    1387. 

  1387.                     else
    1388. 

  1388.                     foreach($valueexp as $v => $y){
    1389. 

  1389.                      if($key==str_replace(array('$F{','}'),'',$y)){
    1390. 

  1390.                          $chartdata[$i][$j]=(int)$value;
    1391. 

  1391. 

  1392.                            $j++;
    1393. 

  1393.                      }
    1394. 

  1394.                     }
    1395. 

  1395. 

  1396. 

  1397. 

  1398. 

  1399. 

  1400.                 }
    1401. 

  1401.             $i++;
    1402. 

  1402. 

  1403.             }
    1404. 

  1404.             if($i==0)
    1405. 

  1405.                 return 0;
    1406. 

  1406.             foreach($seriesname as $s=>$v){
    1407. 

  1407. 

  1408.                     $DataSet->addPoints($chartdata[$s],"$v");
    1409. 

  1409.               //  $DataSet->AddSerie("$v");
    1410. 

  1410.             }
    1411. 

  1411.             $DataSet->setAxisName(0,$ylabel);
    1412. 

  1412. 

  1413. 

  1414. 

  1415. 

  1416.     $this->chart = new pImage($w,$h,$DataSet);
    1417. 

  1417.     //$c = new pChart($w,$h);
    1418. 

  1418.     //$this->setChartColor();
    1419. 

  1419.     $this->chart->drawRectangle(1,1,$w-2,$h-2);
    1420. 

  1420.     $legendfontsize=8;
    1421. 

  1421.     $this->chart->setFontProperties(array('FontName'=>"$pchartfolder/fonts/calibri.ttf",'FontSize'=>$legendfontsize));
    1422. 

  1422. 

  1423. 

  1424. $Title=$data['charttitle']['text'];
    1425. 

  1425. 

  1426. 

  1427.       switch($legendpos){
    1428. 

  1428.              case "Top":
    1429. 

  1429.                  $legendmode=array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_HORIZONTAL);
    1430. 

  1430.                  $lgsize=$this->chart->getLegendSize($legendmode);
    1431. 

  1431.                  $diffx=$w-$lgsize['Width'];
    1432. 

  1432.                  if($diffx>0)
    1433. 

  1433.                  $legendx=$diffx/2;
    1434. 

  1434.                  else
    1435. 

  1435.                  $legendx=0;
    1436. 

  1436. 

  1437.                  //$legendy=$h-$lgsize['Height']+$legendfontsize;
    1438. 

  1438. 

  1439.                  if($legendy<0)$legendy=0;
    1440. 

  1440. 

  1441.                  if($Title==''){
    1442. 

  1442. 

  1443.                      $graphareay1=5;
    1444. 

  1444.                      $legendy=$graphareay1+5;
    1445. 

  1445.                     $graphareax1=40;
    1446. 

  1446.                      $graphareax2=$w-10 ;
    1447. 

  1447.                      $graphareay2=$h-$legendfontsize-15;
    1448. 

  1448.                 }
    1449. 

  1449.                 else{
    1450. 

  1450.                     $graphareay1=30;
    1451. 

  1451.                     $legendy=$graphareay1+5;
    1452. 

  1452.                     $graphareax1=40;
    1453. 

  1453. 

  1454.                      $graphareax2=$w-10 ;
    1455. 

  1455.                      $graphareay2=$h-$legendfontsize-15;
    1456. 

  1456. 

  1457.                 }
    1458. 

  1458.                  break;
    1459. 

  1459.              case "Left":
    1460. 

  1460.                  $legendmode=array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_VERTICAL);
    1461. 

  1461.                  $lgsize=$this->chart->getLegendSize($legendmode);
    1462. 

  1462.                  $legendx=$lgsize['Width'];
    1463. 

  1463.                  if($Title==''){
    1464. 

  1464.                     $legendy=10;
    1465. 

  1465.                      $graphareay1=5;
    1466. 

  1466.                     $graphareax1=$legendx+5;
    1467. 

  1467.                      $graphareax2=$w-5;
    1468. 

  1468.                      $graphareay2=$h-20;
    1469. 

  1469.                 }
    1470. 

  1470.                 else{
    1471. 

  1471.                      $legendy=30;
    1472. 

  1472.                      $graphareay1=40;
    1473. 

  1473.                     $graphareax1=$legendx+5;
    1474. 

  1474.                      $graphareax2=$w-5 ;
    1475. 

  1475.                      $graphareay2=$h-20;
    1476. 

  1476.                 }
    1477. 

  1477.                  break;
    1478. 

  1478.              case "Right":
    1479. 

  1479.              $legendmode=array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_VERTICAL);
    1480. 

  1480.                  $lgsize=$this->chart->getLegendSize($legendmode);
    1481. 

  1481.                  $legendx=$w-$lgsize['Width'];
    1482. 

  1482.                  if($Title==''){
    1483. 

  1483.                     $legendy=10;
    1484. 

  1484.                      $graphareay1=5;
    1485. 

  1485.                     $graphareax1=40;
    1486. 

  1486.                      $graphareax2=$legendx-5 ;
    1487. 

  1487.                      $graphareay2=$h-20;
    1488. 

  1488.                 }
    1489. 

  1489.                 else{
    1490. 

  1490.                      $legendy=30;
    1491. 

  1491.                      $graphareay1=30;
    1492. 

  1492.                     $graphareax1=40;
    1493. 

  1493.                      $graphareax2=$legendx-5 ;
    1494. 

  1494.                      $graphareay2=$h-20;
    1495. 

  1495.                 }
    1496. 

  1496.                  break;
    1497. 

  1497.              case "Bottom":
    1498. 

  1498.                  $legendmode=array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_HORIZONTAL);
    1499. 

  1499.                  $lgsize=$this->chart->getLegendSize($legendmode);
    1500. 

  1500.                  $diffx=$w-$lgsize['Width'];
    1501. 

  1501.                  if($diffx>0)
    1502. 

  1502.                  $legendx=$diffx/2;
    1503. 

  1503.                  else
    1504. 

  1504.                  $legendx=0;
    1505. 

  1505. 

  1506.                  $legendy=$h-$lgsize['Height']+$legendfontsize;
    1507. 

  1507. 

  1508.                  if($legendy<0)$legendy=0;
    1509. 

  1509. 

  1510.                  if($Title==''){
    1511. 

  1511. 

  1512.                      $graphareay1=5;
    1513. 

  1513.                     $graphareax1=40;
    1514. 

  1514.                      $graphareax2=$w-10 ;
    1515. 

  1515.                      $graphareay2=$legendy-$legendfontsize-15;
    1516. 

  1516.                 }
    1517. 

  1517.                 else{
    1518. 

  1518.                     $graphareay1=30;
    1519. 

  1519.                     $graphareax1=40;
    1520. 

  1520.                      $graphareax2=$w-10 ;
    1521. 

  1521.                      $graphareay2=$legendy-$legendfontsize-15;
    1522. 

  1522.                 }
    1523. 

  1523.                  break;
    1524. 

  1524.              default:
    1525. 

  1525.                $legendmode=array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_HORIZONTAL);
    1526. 

  1526.                  $lgsize=$this->chart->getLegendSize($legendmode);
    1527. 

  1527.                  $diffx=$w-$lgsize['Width'];
    1528. 

  1528.                  if($diffx>0)
    1529. 

  1529.                  $legendx=$diffx/2;
    1530. 

  1530.                  else
    1531. 

  1531.                  $legendx=0;
    1532. 

  1532. 

  1533.                  $legendy=$h-$lgsize['Height']+$legendfontsize;
    1534. 

  1534. 

  1535.                  if($legendy<0)$legendy=0;
    1536. 

  1536. 

  1537.                  if($Title==''){
    1538. 

  1538. 

  1539.                      $graphareay1=5;
    1540. 

  1540.                     $graphareax1=40;
    1541. 

  1541.                      $graphareax2=$w-10 ;
    1542. 

  1542.                      $graphareay2=$legendy-$legendfontsize-15;
    1543. 

  1543.                 }
    1544. 

  1544.                 else{
    1545. 

  1545.                     $graphareay1=30;
    1546. 

  1546.                     $graphareax1=40;
    1547. 

  1547.                      $graphareax2=$w-10 ;
    1548. 

  1548.                      $graphareay2=$legendy-$legendfontsize-15;
    1549. 

  1549.                 }
    1550. 

  1550.                  break;
    1551. 

  1551. 

  1552.          }
    1553. 

  1553. 

  1554. 

  1555.          //echo "$graphareax1,$graphareay1,$graphareax2,$graphareay2";die;
    1556. 

  1556.     //print_r($lgsize);die;
    1557. 

  1557. 

  1558.     $this->chart->setGraphArea($graphareax1,$graphareay1,$graphareax2,$graphareay2);
    1559. 

  1559.     $this->chart->setFontProperties(array('FontName'=>"$pchartfolder/fonts/calibri.ttf",'FontSize'=>8));
    1560. 

  1560. 

  1561. 

  1562. 

  1563.     //if($type=='StackedBarChart')
    1564. 

  1564.       //  $scalesetting=array("Floating"=>TRUE,"GridR"=>200, "GridG"=>200,"GridB"=>200,"DrawSubTicks"=>TRUE, "CycleBackground"=>TRUE,
    1565. 

  1565.         //    "DrawSubTicks"=>TRUE,"Mode"=>SCALE_MODE_ADDALL_START0,"DrawArrows"=>TRUE,"ArrowSize"=>6);
    1566. 

  1566.     //else
    1567. 

  1567.     $ScaleSpacing=5;
    1568. 

  1568.         $scalesetting= $scaleSettings = array("XMargin"=>10,"YMargin"=>10,"Floating"=>TRUE,"GridR"=>200,"GridG"=>200,
    1569. 

  1569.             "GridB"=>200,"DrawSubTicks"=>TRUE,"CycleBackground"=>TRUE,"Mode"=>SCALE_MODE_START0,'ScaleSpacing'=>$ScaleSpacing);
    1570. 

  1570. 

  1571.     $this->chart->drawScale($scalesetting);
    1572. 

  1572. 

  1573.     $this->chart->drawLegend($legendx,$legendy,$legendmode);
    1574. 

  1574. 

  1575. 

  1576.     $Title = str_replace(array('"',"'"),'',$data['charttitle']['text']);
    1577. 

  1577. 

  1578.     if($Title!=''){
    1579. 

  1579.         $titlefontsize+0;
    1580. 

  1580.     if($titlefontsize==0)
    1581. 

  1581.         $titlefontsize=8;
    1582. 

  1582.      if($titlefontname=='')
    1583. 

  1583.         $titlefontname='calibri';
    1584. 

  1584. $titlefontname=strtolower($titlefontname);
    1585. 

  1585. 

  1586. 

  1587.     $textsetting=array('DrawBox'=>FALSE,'FontSize'=>$titlefontsize,'FontName'=>"$pchartfolder/fonts/".$titlefontname.".ttf",'align'=>TEXT_ALIGN_TOPMIDDLE);
    1588. 

  1588. 

  1589.     $this->chart->drawText($w/3,($titlefontsize+10),$Title,$textsetting);
    1590. 

  1590.     }
    1591. 

  1591. 

  1592.       $this->chart->setFontProperties(array('FontName'=>"$pchartfolder/fonts/calibri.ttf",'FontSize'=>7));
    1593. 

  1593. 

  1594.          $this->chart->drawLineChart();
    1595. 

  1595. 

  1596. 

  1597.    $randomchartno=rand();
    1598. 

  1598. 	  $photofile="$tmpchartfolder/chart$randomchartno.png";
    1599. 

  1599. 

  1600.              $this->chart->Render($photofile);
    1601. 

  1601. 			
    1602. 

  1602.              if(file_exists($photofile)){
    1603. 

  1603.                 $this->pdf->Image($photofile,$x+$this->arrayPageSetting["leftMargin"],$y_axis+$y1,$w,$h,"PNG");
    1604. 

  1604.                 unlink($photofile);
    1605. 

  1605.              }
    1606. 

  1606. 

  1607. }
    1608. 

  1608. 

  1609. 

  1610. 

  1611. public function showBarChart($data,$y_axis,$type='barChart'){
    1612. 

  1612.       global $tmpchartfolder,$pchartfolder;
    1613. 

  1613. 

  1614. 

  1615.     if($pchartfolder=="")
    1616. 

  1616.         $pchartfolder="./pchart2";
    1617. 

  1617. //echo "$pchartfolder/class/pData.class.php";die;
    1618. 

  1618. 

  1619.         include_once("$pchartfolder/class/pData.class.php");
    1620. 

  1620.         include_once("$pchartfolder/class/pDraw.class.php");
    1621. 

  1621.         include_once("$pchartfolder/class/pImage.class.php");
    1622. 

  1622. 

  1623.     if($tmpchartfolder=="")
    1624. 

  1624.          $tmpchartfolder=$pchartfolder."/cache";
    1625. 

  1625. 

  1626.      $w=$data['width']+0;
    1627. 

  1627.      $h=$data['height']+0;
    1628. 

  1628. 

  1629. 

  1630. 

  1631.      $legendpos=$data['chartLegendPos'];
    1632. 

  1632.      //$legendpos="Right";
    1633. 

  1633.      $seriesexp=$data['seriesexp'];
    1634. 

  1634.      $catexp=$data['catexp'];
    1635. 

  1635.      $valueexp=$data['valueexp'];
    1636. 

  1636.      $labelexp=$data['labelexp'];
    1637. 

  1637.      $ylabel=$data['ylabel'].'';
    1638. 

  1638.      $xlabel=$data['xlabel'].'';
    1639. 

  1639.      $ylabel = str_replace(array('"',"'"),'',$ylabel);
    1640. 

  1640.      $xlabel = str_replace(array('"',"'"),'',$xlabel);
    1641. 

  1641.      $scalesetting=$data['scalesetting'];
    1642. 

  1642. 

  1643. 

  1644.      $x=$data['x'];
    1645. 

  1645.      $y1=$data['y'];
    1646. 

  1646.      $legendx=0;
    1647. 

  1647.      $legendy=0;
    1648. 

  1648.     $titlefontname=$data['titlefontname'].'';
    1649. 

  1649.     $titlefontsize=$data['titlefontsize']+0;
    1650. 

  1650. 

  1651. 

  1652.     $DataSet = new pData();
    1653. 

  1653. 

  1654.     foreach($catexp as $a=>$b)
    1655. 

  1655.        $catexp1[]=  str_replace(array('"',"'"), '',$b);
    1656. 

  1656. 

  1657.     $n=0;
    1658. 

  1658. 

  1659.     $DataSet->addPoints($catexp1,'S00');
    1660. 

  1660.     $DataSet->setSerieDescription('S00','asdasd');
    1661. 

  1661. 

  1662.     //$DataSet->AddSerie('S0');
    1663. 

  1663.     //$DataSet->SetSerieName('S0',"Cat");
    1664. 

  1664.     $DataSet->setAbscissa('S00');
    1665. 

  1665.     $n=$n+1;
    1666. 

  1666. 

  1667.     $ds=trim($data['dataset']);
    1668. 

  1668. 

  1669. 

  1670.     if($ds!=""){
    1671. 

  1671.               $sql=$this->subdataset[$ds];
    1672. 

  1672.         $param=$data['param'];
    1673. 

  1673.         foreach($param as $p)
    1674. 

  1674.             foreach($p as $tag =>$value)
    1675. 

  1675.                 $sql=str_replace('$P{'.$tag.'}',$value, $sql);
    1676. 

  1676.             $sql=$this->changeSubDataSetSql($sql);
    1677. 

  1677. 

  1678.         }
    1679. 

  1679.     else
    1680. 

  1680.         $sql=$this->sql;
    1681. 

  1681. 

  1682.     $result = @mysql_query($sql); //query from db
    1683. 

  1683.     $chartdata=array();
    1684. 

  1684.     $i=0;
    1685. 

  1685. //echo $sql."<br/><br/>";
    1686. 

  1686.     $seriesname=array();
    1687. 

  1687.     while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    1688. 

  1688. 

  1689.                 $j=0;
    1690. 

  1690.                 foreach($row as $key => $value){
    1691. 

  1691.                     //$chartdata[$j][$i]=$value;
    1692. 

  1692.                     if($value=='')
    1693. 

  1693.                         $value=0;
    1694. 

  1694.                     if($key==str_replace(array('$F{','}'),'',$seriesexp[0]))
    1695. 

  1695.                     array_push($seriesname,$value);
    1696. 

  1696.                     else
    1697. 

  1697.                     foreach($valueexp as $v => $y){
    1698. 

  1698.                      if($key==str_replace(array('$F{','}'),'',$y)){
    1699. 

  1699.                          $chartdata[$i][$j]=(int)$value;
    1700. 

  1700. 

  1701.                            $j++;
    1702. 

  1702.                      }
    1703. 

  1703.                     }
    1704. 

  1704. 

  1705. 

  1706. 

  1707. 

  1708. 

  1709.                 }
    1710. 

  1710.             $i++;
    1711. 

  1711. 

  1712.             }
    1713. 

  1713.             if($i==0)
    1714. 

  1714.                 return 0;
    1715. 

  1715.             foreach($seriesname as $s=>$v){
    1716. 

  1716. 

  1717.                     $DataSet->addPoints($chartdata[$s],"$v");
    1718. 

  1718.               //  $DataSet->AddSerie("$v");
    1719. 

  1719.             }
    1720. 

  1720.             $DataSet->setAxisName(0,$ylabel);
    1721. 

  1721. 

  1722. 

  1723. 

  1724. 

  1725.     $this->chart = new pImage($w,$h,$DataSet);
    1726. 

  1726.     //$c = new pChart($w,$h);
    1727. 

  1727.     //$this->setChartColor();
    1728. 

  1728.     $this->chart->drawRectangle(1,1,$w-2,$h-2);
    1729. 

  1729.     $legendfontsize=8;
    1730. 

  1730.     $this->chart->setFontProperties(array('FontName'=>"$pchartfolder/fonts/calibri.ttf",'FontSize'=>$legendfontsize));
    1731. 

  1731. 

  1732. 

  1733.  $Title=$data['charttitle']['text'];
    1734. 

  1734. 

  1735. 

  1736.       switch($legendpos){
    1737. 

  1737.              case "Top":
    1738. 

  1738.                  $legendmode=array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_HORIZONTAL);
    1739. 

  1739.                  $lgsize=$this->chart->getLegendSize($legendmode);
    1740. 

  1740.                  $diffx=$w-$lgsize['Width'];
    1741. 

  1741.                  if($diffx>0)
    1742. 

  1742.                  $legendx=$diffx/2;
    1743. 

  1743.                  else
    1744. 

  1744.                  $legendx=0;
    1745. 

  1745. 

  1746.                  //$legendy=$h-$lgsize['Height']+$legendfontsize;
    1747. 

  1747. 

  1748.                  if($legendy<0)$legendy=0;
    1749. 

  1749. 

  1750.                  if($Title==''){
    1751. 

  1751. 

  1752.                      $graphareay1=15;
    1753. 

  1753.                      $legendy=$graphareay1+5;
    1754. 

  1754.                     $graphareax1=40;
    1755. 

  1755.                      $graphareax2=$w-10 ;
    1756. 

  1756.                      $graphareay2=$h-$legendfontsize-15;
    1757. 

  1757.                 }
    1758. 

  1758.                 else{
    1759. 

  1759.                     $graphareay1=30;
    1760. 

  1760.                     $legendy=$graphareay1+5;
    1761. 

  1761.                     $graphareax1=40;
    1762. 

  1762. 

  1763.                      $graphareax2=$w-10 ;
    1764. 

  1764.                      $graphareay2=$h-$legendfontsize-15;
    1765. 

  1765. 

  1766.                 }
    1767. 

  1767.                  break;
    1768. 

  1768.              case "Left":
    1769. 

  1769.                  $legendmode=array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_VERTICAL);
    1770. 

  1770.                  $lgsize=$this->chart->getLegendSize($legendmode);
    1771. 

  1771.                  $legendx=$lgsize['Width'];
    1772. 

  1772.                  if($Title==''){
    1773. 

  1773.                     $legendy=10;
    1774. 

  1774.                      $graphareay1=10;
    1775. 

  1775.                     $graphareax1=$legendx+5;
    1776. 

  1776.                      $graphareax2=$w-5;
    1777. 

  1777.                      $graphareay2=$h-20;
    1778. 

  1778.                 }
    1779. 

  1779.                 else{
    1780. 

  1780.                      $legendy=30;
    1781. 

  1781.                      $graphareay1=40;
    1782. 

  1782.                     $graphareax1=$legendx+5;
    1783. 

  1783.                      $graphareax2=$w-5 ;
    1784. 

  1784.                      $graphareay2=$h-20;
    1785. 

  1785.                 }
    1786. 

  1786.                  break;
    1787. 

  1787.              case "Right":
    1788. 

  1788.              $legendmode=array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_VERTICAL);
    1789. 

  1789.                  $lgsize=$this->chart->getLegendSize($legendmode);
    1790. 

  1790.                  $legendx=$w-$lgsize['Width'];
    1791. 

  1791.                  if($Title==''){
    1792. 

  1792.                     $legendy=10;
    1793. 

  1793.                      $graphareay1=5;
    1794. 

  1794.                     $graphareax1=40;
    1795. 

  1795.                      $graphareax2=$legendx-5 ;
    1796. 

  1796.                      $graphareay2=$h-20;
    1797. 

  1797.                 }
    1798. 

  1798.                 else{
    1799. 

  1799.                      $legendy=30;
    1800. 

  1800.                      $graphareay1=30;
    1801. 

  1801.                     $graphareax1=40;
    1802. 

  1802.                      $graphareax2=$legendx-5 ;
    1803. 

  1803.                      $graphareay2=$h-20;
    1804. 

  1804.                 }
    1805. 

  1805.                  break;
    1806. 

  1806.              case "Bottom":
    1807. 

  1807.                  $legendmode=array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_HORIZONTAL);
    1808. 

  1808.                  $lgsize=$this->chart->getLegendSize($legendmode);
    1809. 

  1809.                  $diffx=$w-$lgsize['Width'];
    1810. 

  1810.                  if($diffx>0)
    1811. 

  1811.                  $legendx=$diffx/2;
    1812. 

  1812.                  else
    1813. 

  1813.                  $legendx=0;
    1814. 

  1814. 

  1815.                  $legendy=$h-$lgsize['Height']+$legendfontsize;
    1816. 

  1816. 

  1817.                  if($legendy<0)$legendy=0;
    1818. 

  1818. 

  1819.                  if($Title==''){
    1820. 

  1820. 

  1821.                      $graphareay1=15;
    1822. 

  1822.                     $graphareax1=40;
    1823. 

  1823.                      $graphareax2=$w-10 ;
    1824. 

  1824.                      $graphareay2=$legendy-$legendfontsize-15;
    1825. 

  1825.                 }
    1826. 

  1826.                 else{
    1827. 

  1827.                     $graphareay1=30;
    1828. 

  1828.                     $graphareax1=40;
    1829. 

  1829.                      $graphareax2=$w-10 ;
    1830. 

  1830.                      $graphareay2=$legendy-$legendfontsize-15;
    1831. 

  1831.                 }
    1832. 

  1832.                  break;
    1833. 

  1833.              default:
    1834. 

  1834.                $legendmode=array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_HORIZONTAL);
    1835. 

  1835.                  $lgsize=$this->chart->getLegendSize($legendmode);
    1836. 

  1836.                  $diffx=$w-$lgsize['Width'];
    1837. 

  1837.                  if($diffx>0)
    1838. 

  1838.                  $legendx=$diffx/2;
    1839. 

  1839.                  else
    1840. 

  1840.                  $legendx=0;
    1841. 

  1841. 

  1842.                  $legendy=$h-$lgsize['Height']+$legendfontsize;
    1843. 

  1843. 

  1844.                  if($legendy<0)$legendy=0;
    1845. 

  1845. 

  1846.                  if($Title==''){
    1847. 

  1847. 

  1848.                      $graphareay1=15;
    1849. 

  1849.                     $graphareax1=40;
    1850. 

  1850.                      $graphareax2=$w-10 ;
    1851. 

  1851.                      $graphareay2=$legendy-$legendfontsize-15;
    1852. 

  1852.                 }
    1853. 

  1853.                 else{
    1854. 

  1854.                     $graphareay1=30;
    1855. 

  1855.                     $graphareax1=40;
    1856. 

  1856.                      $graphareax2=$w-10 ;
    1857. 

  1857.                      $graphareay2=$legendy-$legendfontsize-15;
    1858. 

  1858.                 }
    1859. 

  1859.                  break;
    1860. 

  1860. 

  1861.          }
    1862. 

  1862. 

  1863. 

  1864.          //echo "$graphareax1,$graphareay1,$graphareax2,$graphareay2";die;
    1865. 

  1865.     //print_r($lgsize);die;
    1866. 

  1866. 

  1867.     $this->chart->setGraphArea($graphareax1,$graphareay1,$graphareax2,$graphareay2);
    1868. 

  1868.     $this->chart->setFontProperties(array('FontName'=>"$pchartfolder/fonts/calibri.ttf",'FontSize'=>8));
    1869. 

  1869. 

  1870. 

  1871. if($type=='stackedBarChart')
    1872. 

  1872.         $scalesetting=array("Floating"=>TRUE,"GridR"=>200, "GridG"=>200,"GridB"=>200,"DrawSubTicks"=>TRUE, "CycleBackground"=>TRUE,
    1873. 

  1873.             "DrawSubTicks"=>TRUE,"Mode"=>SCALE_MODE_ADDALL_START0,"ArrowSize"=>6);
    1874. 

  1874.     else
    1875. 

  1875.             $scalesetting=array("Floating"=>TRUE,"GridR"=>200, "GridG"=>200,"GridB"=>200,"DrawSubTicks"=>TRUE, "CycleBackground"=>TRUE,
    1876. 

  1876.             "DrawSubTicks"=>TRUE,"Mode"=>SCALE_MODE_START0,"ArrowSize"=>6);
    1877. 

  1877.     $this->chart->drawScale($scalesetting);
    1878. 

  1878. 

  1879.     $this->chart->drawLegend($legendx,$legendy,$legendmode);
    1880. 

  1880. 

  1881. 

  1882.     $Title = str_replace(array('"',"'"),'',$data['charttitle']['text']);
    1883. 

  1883. 

  1884.     if($Title!=''){
    1885. 

  1885.         $titlefontsize+0;
    1886. 

  1886.     if($titlefontsize==0)
    1887. 

  1887.         $titlefontsize=8;
    1888. 

  1888.      if($titlefontname=='')
    1889. 

  1889.         $titlefontname='calibri';
    1890. 

  1890. $titlefontname=strtolower($titlefontname);
    1891. 

  1891. 

  1892.     $textsetting=array('DrawBox'=>FALSE,'FontSize'=>$titlefontsize,'FontName'=>"$pchartfolder/fonts/".$titlefontname.".ttf",'align'=>TEXT_ALIGN_TOPMIDDLE);
    1893. 

  1893. //print_r($textsetting);die;
    1894. 

  1894.     $this->chart->drawText($w/3,($titlefontsize+10),$Title,$textsetting);
    1895. 

  1895.     }
    1896. 

  1896. 

  1897.       $this->chart->setFontProperties(array('FontName'=>"$pchartfolder/fonts/calibri.ttf",'FontSize'=>7));
    1898. 

  1898. 

  1899. 

  1900.     if($type=='stackedBarChart')
    1901. 

  1901.         $this->chart->drawStackedBarChart();
    1902. 

  1902.     else
    1903. 

  1903.         $this->chart->drawBarChart();
    1904. 

  1904. 

  1905. 

  1906.    $randomchartno=rand();
    1907. 

  1907. 	  $photofile="$tmpchartfolder/chart$randomchartno.png";
    1908. 

  1908. 

  1909.              $this->chart->Render($photofile);
    1910. 

  1910. 

  1911.              if(file_exists($photofile)){
    1912. 

  1912.                 $this->pdf->Image($photofile,$x+$this->arrayPageSetting["leftMargin"],$y_axis+$y1,$w,$h,"PNG");
    1913. 

  1913.                 unlink($photofile);
    1914. 

  1914.              }
    1915. 

  1915. 

  1916. 

  1917. }
    1918. 

  1918. 

  1919. 

  1920. 

  1921. 

  1922. public function showAreaChart($data,$y_axis,$type){
    1923. 

  1923.     global $tmpchartfolder,$pchartfolder;
    1924. 

  1924. 

  1925. 

  1926.     if($pchartfolder=="")
    1927. 

  1927.         $pchartfolder="./pchart2";
    1928. 

  1928. //echo "$pchartfolder/class/pData.class.php";die;
    1929. 

  1929. 

  1930.         include_once("$pchartfolder/class/pData.class.php");
    1931. 

  1931.         include_once("$pchartfolder/class/pDraw.class.php");
    1932. 

  1932.         include_once("$pchartfolder/class/pImage.class.php");
    1933. 

  1933. 

  1934.     if($tmpchartfolder=="")
    1935. 

  1935.          $tmpchartfolder=$pchartfolder."/cache";
    1936. 

  1936. 

  1937.      $w=$data['width']+0;
    1938. 

  1938.      $h=$data['height']+0;
    1939. 

  1939. 

  1940. 

  1941. 

  1942.      $legendpos=$data['chartLegendPos'];
    1943. 

  1943.      //$legendpos="Right";
    1944. 

  1944.      $seriesexp=$data['seriesexp'];
    1945. 

  1945.      $catexp=$data['catexp'];
    1946. 

  1946.      $valueexp=$data['valueexp'];
    1947. 

  1947.      $labelexp=$data['labelexp'];
    1948. 

  1948.      $ylabel=$data['ylabel'].'';
    1949. 

  1949.      $xlabel=$data['xlabel'].'';
    1950. 

  1950.      $ylabel = str_replace(array('"',"'"),'',$ylabel);
    1951. 

  1951.      $xlabel = str_replace(array('"',"'"),'',$xlabel);
    1952. 

  1952.      $scalesetting=$data['scalesetting'];
    1953. 

  1953. 

  1954. 

  1955.      $x=$data['x'];
    1956. 

  1956.      $y1=$data['y'];
    1957. 

  1957.      $legendx=0;
    1958. 

  1958.      $legendy=0;
    1959. 

  1959. 

  1960.     $titlefontname=$data['titlefontname'].'';
    1961. 

  1961.     $titlefontsize=$data['titlefontsize']+0;
    1962. 

  1962. 

  1963. 

  1964.     $DataSet = new pData();
    1965. 

  1965. 

  1966.     foreach($catexp as $a=>$b)
    1967. 

  1967.        $catexp1[]=  str_replace(array('"',"'"), '',$b);
    1968. 

  1968. 

  1969.     $n=0;
    1970. 

  1970. 

  1971.     $DataSet->addPoints($catexp1,'S00');
    1972. 

  1972.     $DataSet->setSerieDescription('S00','asdasd');
    1973. 

  1973. 

  1974.     //$DataSet->AddSerie('S0');
    1975. 

  1975.     //$DataSet->SetSerieName('S0',"Cat");
    1976. 

  1976.     $DataSet->setAbscissa('S00');
    1977. 

  1977.     $n=$n+1;
    1978. 

  1978. 

  1979.     $ds=trim($data['dataset']);
    1980. 

  1980. 

  1981. 

  1982.     if($ds!=""){
    1983. 

  1983.               $sql=$this->subdataset[$ds];
    1984. 

  1984.         $param=$data['param'];
    1985. 

  1985.         foreach($param as $p)
    1986. 

  1986.             foreach($p as $tag =>$value)
    1987. 

  1987.                 $sql=str_replace('$P{'.$tag.'}',$value, $sql);
    1988. 

  1988.             $sql=$this->changeSubDataSetSql($sql);
    1989. 

  1989. 

  1990.         }
    1991. 

  1991.     else
    1992. 

  1992.         $sql=$this->sql;
    1993. 

  1993. 

  1994.     $result = @mysql_query($sql); //query from db
    1995. 

  1995.     $chartdata=array();
    1996. 

  1996.     $i=0;
    1997. 

  1997. //echo $sql."<br/><br/>";
    1998. 

  1998.     $seriesname=array();
    1999. 

  1999.     while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    2000. 

  2000. 

  2001.                 $j=0;
    2002. 

  2002.                 foreach($row as $key => $value){
    2003. 

  2003.                     //$chartdata[$j][$i]=$value;
    2004. 

  2004.                     if($value=='')
    2005. 

  2005.                         $value=0;
    2006. 

  2006.                     if($key==str_replace(array('$F{','}'),'',$seriesexp[0]))
    2007. 

  2007.                     array_push($seriesname,$value);
    2008. 

  2008.                     else
    2009. 

  2009.                     foreach($valueexp as $v => $y){
    2010. 

  2010.                      if($key==str_replace(array('$F{','}'),'',$y)){
    2011. 

  2011.                          $chartdata[$i][$j]=(int)$value;
    2012. 

  2012. 

  2013.                            $j++;
    2014. 

  2014.                      }
    2015. 

  2015.                     }
    2016. 

  2016. 

  2017. 

  2018. 

  2019. 

  2020. 

  2021.                 }
    2022. 

  2022.             $i++;
    2023. 

  2023. 

  2024.             }
    2025. 

  2025.             if($i==0)
    2026. 

  2026.                 return 0;
    2027. 

  2027.             foreach($seriesname as $s=>$v){
    2028. 

  2028. 

  2029.                     $DataSet->addPoints($chartdata[$s],"$v");
    2030. 

  2030.               //  $DataSet->AddSerie("$v");
    2031. 

  2031.             }
    2032. 

  2032.             $DataSet->setAxisName(0,$ylabel);
    2033. 

  2033. 

  2034. 

  2035. 

  2036. 

  2037.     $this->chart = new pImage($w,$h,$DataSet);
    2038. 

  2038.     //$c = new pChart($w,$h);
    2039. 

  2039.     //$this->setChartColor();
    2040. 

  2040.     $this->chart->drawRectangle(1,1,$w-2,$h-2);
    2041. 

  2041.     $legendfontsize=8;
    2042. 

  2042.     $this->chart->setFontProperties(array('FontName'=>"$pchartfolder/fonts/calibri.ttf",'FontSize'=>$legendfontsize));
    2043. 

  2043. 

  2044. 

  2045. $Title=$data['charttitle']['text'];
    2046. 

  2046. 

  2047. 

  2048.       switch($legendpos){
    2049. 

  2049.              case "Top":
    2050. 

  2050.                  $legendmode=array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_HORIZONTAL);
    2051. 

  2051.                  $lgsize=$this->chart->getLegendSize($legendmode);
    2052. 

  2052.                  $diffx=$w-$lgsize['Width'];
    2053. 

  2053.                  if($diffx>0)
    2054. 

  2054.                  $legendx=$diffx/2;
    2055. 

  2055.                  else
    2056. 

  2056.                  $legendx=0;
    2057. 

  2057. 

  2058.                  //$legendy=$h-$lgsize['Height']+$legendfontsize;
    2059. 

  2059. 

  2060.                  if($legendy<0)$legendy=0;
    2061. 

  2061. 

  2062.                  if($Title==''){
    2063. 

  2063. 

  2064.                      $graphareay1=5;
    2065. 

  2065.                      $legendy=$graphareay1+5;
    2066. 

  2066.                     $graphareax1=40;
    2067. 

  2067.                      $graphareax2=$w-10 ;
    2068. 

  2068.                      $graphareay2=$h-$legendfontsize-15;
    2069. 

  2069.                 }
    2070. 

  2070.                 else{
    2071. 

  2071.                     $graphareay1=30;
    2072. 

  2072.                     $legendy=$graphareay1+5;
    2073. 

  2073.                     $graphareax1=40;
    2074. 

  2074. 

  2075.                      $graphareax2=$w-10 ;
    2076. 

  2076.                      $graphareay2=$h-$legendfontsize-15;
    2077. 

  2077. 

  2078.                 }
    2079. 

  2079.                  break;
    2080. 

  2080.              case "Left":
    2081. 

  2081.                  $legendmode=array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_VERTICAL);
    2082. 

  2082.                  $lgsize=$this->chart->getLegendSize($legendmode);
    2083. 

  2083.                  $legendx=$lgsize['Width'];
    2084. 

  2084.                  if($Title==''){
    2085. 

  2085.                     $legendy=10;
    2086. 

  2086.                      $graphareay1=5;
    2087. 

  2087.                     $graphareax1=$legendx+5;
    2088. 

  2088.                      $graphareax2=$w-5;
    2089. 

  2089.                      $graphareay2=$h-20;
    2090. 

  2090.                 }
    2091. 

  2091.                 else{
    2092. 

  2092.                      $legendy=30;
    2093. 

  2093.                      $graphareay1=40;
    2094. 

  2094.                     $graphareax1=$legendx+5;
    2095. 

  2095.                      $graphareax2=$w-5 ;
    2096. 

  2096.                      $graphareay2=$h-20;
    2097. 

  2097.                 }
    2098. 

  2098.                  break;
    2099. 

  2099.              case "Right":
    2100. 

  2100.              $legendmode=array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_VERTICAL);
    2101. 

  2101.                  $lgsize=$this->chart->getLegendSize($legendmode);
    2102. 

  2102.                  $legendx=$w-$lgsize['Width'];
    2103. 

  2103.                  if($Title==''){
    2104. 

  2104.                     $legendy=10;
    2105. 

  2105.                      $graphareay1=5;
    2106. 

  2106.                     $graphareax1=40;
    2107. 

  2107.                      $graphareax2=$legendx-5 ;
    2108. 

  2108.                      $graphareay2=$h-20;
    2109. 

  2109.                 }
    2110. 

  2110.                 else{
    2111. 

  2111.                      $legendy=30;
    2112. 

  2112.                      $graphareay1=30;
    2113. 

  2113.                     $graphareax1=40;
    2114. 

  2114.                      $graphareax2=$legendx-5 ;
    2115. 

  2115.                      $graphareay2=$h-20;
    2116. 

  2116.                 }
    2117. 

  2117.                  break;
    2118. 

  2118.              case "Bottom":
    2119. 

  2119.                  $legendmode=array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_HORIZONTAL);
    2120. 

  2120.                  $lgsize=$this->chart->getLegendSize($legendmode);
    2121. 

  2121.                  $diffx=$w-$lgsize['Width'];
    2122. 

  2122.                  if($diffx>0)
    2123. 

  2123.                  $legendx=$diffx/2;
    2124. 

  2124.                  else
    2125. 

  2125.                  $legendx=0;
    2126. 

  2126. 

  2127.                  $legendy=$h-$lgsize['Height']+$legendfontsize;
    2128. 

  2128. 

  2129.                  if($legendy<0)$legendy=0;
    2130. 

  2130. 

  2131.                  if($Title==''){
    2132. 

  2132. 

  2133.                      $graphareay1=5;
    2134. 

  2134.                     $graphareax1=40;
    2135. 

  2135.                      $graphareax2=$w-10 ;
    2136. 

  2136.                      $graphareay2=$legendy-$legendfontsize-15;
    2137. 

  2137.                 }
    2138. 

  2138.                 else{
    2139. 

  2139.                     $graphareay1=30;
    2140. 

  2140.                     $graphareax1=40;
    2141. 

  2141.                      $graphareax2=$w-10 ;
    2142. 

  2142.                      $graphareay2=$legendy-$legendfontsize-15;
    2143. 

  2143.                 }
    2144. 

  2144.                  break;
    2145. 

  2145.              default:
    2146. 

  2146.                $legendmode=array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_HORIZONTAL);
    2147. 

  2147.                  $lgsize=$this->chart->getLegendSize($legendmode);
    2148. 

  2148.                  $diffx=$w-$lgsize['Width'];
    2149. 

  2149.                  if($diffx>0)
    2150. 

  2150.                  $legendx=$diffx/2;
    2151. 

  2151.                  else
    2152. 

  2152.                  $legendx=0;
    2153. 

  2153. 

  2154.                  $legendy=$h-$lgsize['Height']+$legendfontsize;
    2155. 

  2155. 

  2156.                  if($legendy<0)$legendy=0;
    2157. 

  2157. 

  2158.                  if($Title==''){
    2159. 

  2159. 

  2160.                      $graphareay1=5;
    2161. 

  2161.                     $graphareax1=40;
    2162. 

  2162.                      $graphareax2=$w-10 ;
    2163. 

  2163.                      $graphareay2=$legendy-$legendfontsize-15;
    2164. 

  2164.                 }
    2165. 

  2165.                 else{
    2166. 

  2166.                     $graphareay1=30;
    2167. 

  2167.                     $graphareax1=40;
    2168. 

  2168.                      $graphareax2=$w-10 ;
    2169. 

  2169.                      $graphareay2=$legendy-$legendfontsize-15;
    2170. 

  2170.                 }
    2171. 

  2171.                  break;
    2172. 

  2172. 

  2173.          }
    2174. 

  2174. 

  2175. 

  2176.          //echo "$graphareax1,$graphareay1,$graphareax2,$graphareay2";die;
    2177. 

  2177.     //print_r($lgsize);die;
    2178. 

  2178. 

  2179.     $this->chart->setGraphArea($graphareax1,$graphareay1,$graphareax2,$graphareay2);
    2180. 

  2180.     $this->chart->setFontProperties(array('FontName'=>"$pchartfolder/fonts/calibri.ttf",'FontSize'=>8));
    2181. 

  2181. 

  2182. 

  2183. 

  2184.     //if($type=='StackedBarChart')
    2185. 

  2185.       //  $scalesetting=array("Floating"=>TRUE,"GridR"=>200, "GridG"=>200,"GridB"=>200,"DrawSubTicks"=>TRUE, "CycleBackground"=>TRUE,
    2186. 

  2186.         //    "DrawSubTicks"=>TRUE,"Mode"=>SCALE_MODE_ADDALL_START0,"DrawArrows"=>TRUE,"ArrowSize"=>6);
    2187. 

  2187.     //else
    2188. 

  2188.     $ScaleSpacing=5;
    2189. 

  2189.         $scalesetting= $scaleSettings = array("XMargin"=>10,"YMargin"=>10,"Floating"=>TRUE,"GridR"=>200,"GridG"=>200,
    2190. 

  2190.             "GridB"=>200,"DrawSubTicks"=>TRUE,"CycleBackground"=>TRUE,"Mode"=>SCALE_MODE_ADDALL_START0,'ScaleSpacing'=>$ScaleSpacing);
    2191. 

  2191. 

  2192.     $this->chart->drawScale($scalesetting);
    2193. 

  2193. 

  2194.     $this->chart->drawLegend($legendx,$legendy,$legendmode);
    2195. 

  2195. 

  2196. 

  2197.     $Title = str_replace(array('"',"'"),'',$data['charttitle']['text']);
    2198. 

  2198. 

  2199.     if($Title!=''){
    2200. 

  2200.         $titlefontsize+0;
    2201. 

  2201.     if($titlefontsize==0)
    2202. 

  2202.         $titlefontsize=8;
    2203. 

  2203.      if($titlefontname=='')
    2204. 

  2204.         $titlefontname='calibri';
    2205. 

  2205. $titlefontname=strtolower($titlefontname);
    2206. 

  2206. 

  2207. 

  2208.     $textsetting=array('DrawBox'=>FALSE,'FontSize'=>$titlefontsize,'FontName'=>"$pchartfolder/fonts/".$titlefontname.".ttf",'align'=>TEXT_ALIGN_TOPMIDDLE);
    2209. 

  2209. 

  2210.     $this->chart->drawText($w/3,($titlefontsize+10),$Title,$textsetting);
    2211. 

  2211.     }
    2212. 

  2212. 

  2213.       $this->chart->setFontProperties(array('FontName'=>"$pchartfolder/fonts/calibri.ttf",'FontSize'=>7));
    2214. 

  2214. 

  2215. $this->chart->drawStackedAreaChart(array("Surrounding"=>60));
    2216. 

  2216. 

  2217. 

  2218.    $randomchartno=rand();
    2219. 

  2219. 	  $photofile="$tmpchartfolder/chart$randomchartno.png";
    2220. 

  2220. 

  2221.              $this->chart->Render($photofile);
    2222. 

  2222. 

  2223.              if(file_exists($photofile)){
    2224. 

  2224.                 $this->pdf->Image($photofile,$x+$this->arrayPageSetting["leftMargin"],$y_axis+$y1,$w,$h,"PNG");
    2225. 

  2225.                 unlink($photofile);
    2226. 

  2226.              }
    2227. 

  2227. 

  2228. }
    2229. 

  2229. 

  2230. 

  2231. 

  2232. 

  2233. private function changeSubDataSetSql($sql){
    2234. 

  2234. 

  2235. foreach($this->currentrow as $name =>$value)
    2236. 

  2236.         $sql=str_replace('$F{'.$name.'}',$value,$sql);
    2237. 

  2237. 

  2238. foreach($this->arrayParameter as $name=>$value)
    2239. 

  2239.     $sql=str_replace('$P{'.$name.'}',$value,$sql);
    2240. 

  2240. 

  2241. foreach($this->arrayVariable as $name=>$value){
    2242. 

  2242.     $sql=str_replace('$V{'.$value['target'].'}',$value['ans'],$sql);
    2243. 

  2243. 

  2244. 

  2245. }
    2246. 

  2246. 

  2247. 

  2248. //print_r($this->arrayparameter);
    2249. 

  2249. 

  2250. 

  2251. //variable not yet implemented
    2252. 

  2252.      return $sql;
    2253. 

  2253. 

  2254. 

  2255. }
    2256. 

  2256.     public function background() {
    2257. 

  2257.         foreach ($this->arraybackground as $out) {
    2258. 

  2258.             switch($out["hidden_type"]) {
    2259. 

  2259.                 case "field":
    2260. 

  2260.                     $this->display($out,$this->arrayPageSetting["topMargin"],true);
    2261. 

  2261.                     break;
    2262. 

  2262.                 default:
    2263. 

  2263.                     $this->display($out,$this->arrayPageSetting["topMargin"],false);
    2264. 

  2264.                     break;
    2265. 

  2265.             }
    2266. 

  2266. 

  2267.         }
    2268. 

  2268.     }
    2269. 

  2269. 

  2270.     public function pageHeader($headerY) {
    2271. 

  2271.         $this->currentband='pageHeader';// to know current where current band in!
    2272. 

  2272.         $this->pdf->AddPage();
    2273. 

  2273.         $this->background();
    2274. 

  2274.         if(isset($this->arraypageHeader)) {
    2275. 

  2275.             $this->arraypageHeader[0]["y_axis"]=$this->arrayPageSetting["topMargin"];
    2276. 

  2276.         }
    2277. 

  2277.         foreach ($this->arraypageHeader as $out) {
    2278. 

  2278.             switch($out["hidden_type"]) {
    2279. 

  2279.                 case "field":
    2280. 

  2280.                     $this->display($out,$this->arraypageHeader[0]["y_axis"],true);
    2281. 

  2281.                     break;
    2282. 

  2282.                 default:
    2283. 

  2283.                     $this->display($out,$this->arraypageHeader[0]["y_axis"],false);
    2284. 

  2284.                     break;
    2285. 

  2285.             }
    2286. 

  2286.         }
    2287. 

  2287.         
    2288. 

  2288.         $this->currentband='';
    2289. 

  2289.     }
    2290. 

  2290. 

  2291.     public function pageHeaderNewPage() {
    2292. 

  2292.         $this->currentband='pageHeader';
    2293. 

  2293.         $this->pdf->AddPage();
    2294. 

  2294.         $this->background();
    2295. 

  2295.         if(isset($this->arraypageHeader)) {
    2296. 

  2296.             $this->arraypageHeader[0]["y_axis"]=$this->arrayPageSetting["topMargin"];
    2297. 

  2297.         }
    2298. 

  2298.         foreach ($this->arraypageHeader as $out) {
    2299. 

  2299.             switch($out["hidden_type"]) {
    2300. 

  2300.                 case "textfield":
    2301. 

  2301.                     $this->display($out,$this->arraypageHeader[0]["y_axis"],true);
    2302. 

  2302.                     break;
    2303. 

  2303.                 default:
    2304. 

  2304.                     $this->display($out,$this->arraypageHeader[0]["y_axis"],true);
    2305. 

  2305.                     break;
    2306. 

  2306.             }
    2307. 

  2307.         }
    2308. 

  2308.         $this->showGroupHeader($this->arrayPageSetting["topMargin"]+$this->arraypageHeader[0]["height"]);
    2309. 

  2309.     }
    2310. 

  2310. 

  2311. 

  2312.     public function title() {
    2313. 

  2313.                 $this->currentband='title';
    2314. 

  2314.         $this->pdf->AddPage();
    2315. 

  2315.         $this->background();
    2316. 

  2316. 

  2317.             $this->titleheight=$this->arraytitle[0]["height"];
    2318. 

  2318. 

  2319.             //print_r($this->arraytitle);die;
    2320. 

  2320.         if(isset($this->arraytitle)) {
    2321. 

  2321.             $this->arraytitle[0]["y_axis"]=$this->arrayPageSetting["topMargin"];
    2322. 

  2322.         }
    2323. 

  2323. 

  2324.         foreach ($this->arraytitle as $out) {
    2325. 

  2325. 

  2326.             switch($out["hidden_type"]) {
    2327. 

  2327.                 case "field":
    2328. 

  2328.                     $this->display($out,$this->arraytitle[0]["y_axis"],true);
    2329. 

  2329.                     break;
    2330. 

  2330.                 default:
    2331. 

  2331.                     $this->display($out,$this->arraytitle[0]["y_axis"],false);
    2332. 

  2332.                     break;
    2333. 

  2333.             }
    2334. 

  2334.         }
    2335. 

  2335. 

  2336.         $this->currentband='';
    2337. 

  2337.     }
    2338. 

  2338. 

  2339.       public function summary($y) {
    2340. 

  2340.         //$this->pdf->AddPage();
    2341. 

  2341.         //$this->background();
    2342. 

  2342.             $this->currentband='summary';
    2343. 

  2343.             $this->titlesummary=$this->arraysummary[0]["height"];
    2344. 

  2344. 

  2345.             //print_r($this->arraytitle);die;
    2346. 

  2346. 

  2347.         foreach ($this->arraysummary as $out) {
    2348. 

  2348. 

  2349.             switch($out["hidden_type"]) {
    2350. 

  2350.                 case "field":
    2351. 

  2351.                     $this->display($out,$y,true);
    2352. 

  2352.                     break;
    2353. 

  2353.                 default:
    2354. 

  2354.                     $this->display($out,$y,false);
    2355. 

  2355.                     break;
    2356. 

  2356.             }
    2357. 

  2357.         }
    2358. 

  2358. 

  2359.                 $this->currentband='';
    2360. 

  2360.     }
    2361. 

  2361. 

  2362.     public function group($headerY) {
    2363. 

  2363. 

  2364. 

  2365.         $gname=$this->arrayband[0]["gname"]."";
    2366. 

  2366.         if(isset($this->arraypageHeader)) {
    2367. 

  2367.             $this->arraygroup[$gname]["groupHeader"][0]["y_axis"]=$headerY;
    2368. 

  2368.         }
    2369. 

  2369.         if(isset($this->arraypageFooter)) {
    2370. 

  2370.             $this->arraygroup[$gname]["groupFooter"][0]["y_axis"]=$this->arrayPageSetting["pageHeight"]-$this->arraypageFooter[0]["height"]-$this->arrayPageSetting["bottomMargin"]-$this->arraygroup[$gname]["groupFooter"][0]["height"];
    2371. 

  2371.         }
    2372. 

  2372.         else {
    2373. 

  2373.             $this->arraygroup[$gname]["groupFooter"][0]["y_axis"]=$this->arrayPageSetting["pageHeight"]-$this->arrayPageSetting["bottomMargin"]-$this->arraygroup[$gname]["groupFooter"][0]["height"];
    2374. 

  2374.         }
    2375. 

  2375. 

  2376.         if(isset($this->arraygroup)) {
    2377. 

  2377. 

  2378.             foreach($this->arraygroup[$gname] as $name=>$out) {
    2379. 

  2379. 

  2380. 

  2381.                 switch($name) {
    2382. 

  2382.                     case "groupHeader":
    2383. 

  2383. //###                        $this->group_count=0;
    2384. 

  2384.                         foreach($out as $path) { //print_r($out);
    2385. 

  2385.                             switch($path["hidden_type"]) {
    2386. 

  2386.                                 case "field":
    2387. 

  2387. 

  2388.                                     $this->display($path,$this->arraygroup[$gname]["groupHeader"][0]["y_axis"],true);
    2389. 

  2389.                                     break;
    2390. 

  2390.                                 default:
    2391. 

  2391. 

  2392.                                     $this->display($path,$this->arraygroup[$gname]["groupHeader"][0]["y_axis"],false);
    2393. 

  2393.                                     break;
    2394. 

  2394.                             }
    2395. 

  2395.                         }
    2396. 

  2396.                         break;
    2397. 

  2397.                     case "groupFooter":
    2398. 

  2398.                         foreach($out as $path) {
    2399. 

  2399.                             switch($path["hidden_type"]) {
    2400. 

  2400.                                 case "field":
    2401. 

  2401.                                     $this->display($path,$this->arraygroup[$gname]["groupFooter"][0]["y_axis"],true);
    2402. 

  2402.                                     break;
    2403. 

  2403.                                 default:
    2404. 

  2404.                                     $this->display($path,$this->arraygroup[$gname]["groupFooter"][0]["y_axis"],false);
    2405. 

  2405.                                     break;
    2406. 

  2406.                             }
    2407. 

  2407.                         }
    2408. 

  2408.                         break;
    2409. 

  2409.                     default:
    2410. 

  2410.                         break;
    2411. 

  2411.                 }
    2412. 

  2412.             }
    2413. 

  2413.         }
    2414. 

  2414.     }
    2415. 

  2415. 

  2416. 

  2417.     public function groupNewPage() {
    2418. 

  2418.         $gname=$this->arrayband[0]["gname"]."";
    2419. 

  2419. 

  2420.         if(isset($this->arraypageHeader)) {
    2421. 

  2421.             $this->arraygroup[$gname]["groupHeader"][0]["y_axis"]=$this->arrayPageSetting["topMargin"]+$this->arraypageHeader[0]["height"];
    2422. 

  2422.         }
    2423. 

  2423.         if(isset($this->arraypageFooter)) {
    2424. 

  2424.             $this->arraygroup[$gname]["groupFooter"][0]["y_axis"]=$this->arrayPageSetting["pageHeight"]-$this->arraypageFooter[0]["height"]-$this->arrayPageSetting["bottomMargin"]-$this->arraygroup[$gname]["groupFooter"][0]["height"];
    2425. 

  2425.         }
    2426. 

  2426.         else {
    2427. 

  2427.             $this->arraygroup[$gname]["groupFooter"][0]["y_axis"]=$this->arrayPageSetting["pageHeight"]-$this->arrayPageSetting["bottomMargin"]-$this->arraygroup[$gname]["groupFooter"][0]["height"];
    2428. 

  2428.         }
    2429. 

  2429. 

  2430.         if(isset($this->arraygroup)) {
    2431. 

  2431.             foreach($this->arraygroup[$gname] as $name=>$out) {
    2432. 

  2432.                 switch($name) {
    2433. 

  2433.                     case "groupHeader":
    2434. 

  2434.                         foreach($out as $path) {
    2435. 

  2435.                             switch($path["hidden_type"]) {
    2436. 

  2436.                                 case "field":
    2437. 

  2437.                                     $this->display($path,$this->arraygroup[$gname]["groupHeader"][0]["y_axis"],true);
    2438. 

  2438.                                     break;
    2439. 

  2439.                                 default:
    2440. 

  2440. 

  2441.                                     $this->display($path,$this->arraygroup[$gname]["groupHeader"][0]["y_axis"],false);
    2442. 

  2442.                                     break;
    2443. 

  2443.                             }
    2444. 

  2444.                         }
    2445. 

  2445.                         break;
    2446. 

  2446.                     case "groupFooter":
    2447. 

  2447.                         foreach($out as $path) {
    2448. 

  2448.                             switch($path["hidden_type"]) {
    2449. 

  2449.                                 case "field":
    2450. 

  2450.                                     $this->display($path,$this->arraygroup[$gname]["groupFooter"][0]["y_axis"],true);
    2451. 

  2451.                                     break;
    2452. 

  2452.                                 default:
    2453. 

  2453.                                     $this->display($path,$this->arraygroup[$gname]["groupFooter"][0]["y_axis"],false);
    2454. 

  2454.                                     break;
    2455. 

  2455.                             }
    2456. 

  2456.                         }
    2457. 

  2457.                         break;
    2458. 

  2458.                     default:
    2459. 

  2459.                         break;
    2460. 

  2460.                 }
    2461. 

  2461.             }
    2462. 

  2462.         }
    2463. 

  2463.     }
    2464. 

  2464. 

  2465.     public function pageFooter() {
    2466. 

  2466.         $this->currentband='pageFooter';
    2467. 

  2467.         if(isset($this->arraypageFooter)) {
    2468. 

  2468.             foreach ($this->arraypageFooter as $out) {
    2469. 

  2469.                 switch($out["hidden_type"]) {
    2470. 

  2470.                     case "field":
    2471. 

  2471.                         $this->display($out,$this->arrayPageSetting["pageHeight"]-$this->arraypageFooter[0]["height"]-$this->arrayPageSetting["bottomMargin"],true);
    2472. 

  2472.                         break;
    2473. 

  2473.                     default:
    2474. 

  2474.                         $this->display($out,$this->arrayPageSetting["pageHeight"]-$this->arraypageFooter[0]["height"]-$this->arrayPageSetting["bottomMargin"],false);
    2475. 

  2475.                         break;
    2476. 

  2476.                 }
    2477. 

  2477.             }
    2478. 

  2478.         }
    2479. 

  2479.         else {
    2480. 

  2480.             $this->lastPageFooter();
    2481. 

  2481.         }
    2482. 

  2482.         $this->currentband='';
    2483. 

  2483.     }
    2484. 

  2484. 

  2485.     public function lastPageFooter() {
    2486. 

  2486.         $this->currentband='lastPageFooter';
    2487. 

  2487.         if(isset($this->arraylastPageFooter)) {
    2488. 

  2488.             foreach ($this->arraylastPageFooter as $out) {
    2489. 

  2489.                 switch($out["hidden_type"]) {
    2490. 

  2490.                     case "field":
    2491. 

  2491.                         $this->display($out,$this->arrayPageSetting["pageHeight"]-$this->arraylastPageFooter[0]["height"]-$this->arrayPageSetting["bottomMargin"],true);
    2492. 

  2492.                         break;
    2493. 

  2493.                     default:
    2494. 

  2494.                         $this->display($out,$this->arrayPageSetting["pageHeight"]-$this->arraylastPageFooter[0]["height"]-$this->arrayPageSetting["bottomMargin"],false);
    2495. 

  2495.                         break;
    2496. 

  2496.                 }
    2497. 

  2497.             }
    2498. 

  2498.         }
    2499. 

  2499.         $this->currentband='';
    2500. 

  2500.     }
    2501. 

  2501. 

  2502.     public function NbLines($w,$txt) {
    2503. 

  2503.         //Computes the number of lines a MultiCell of width w will take
    2504. 

  2504.         $cw=&$this->pdf->CurrentFont['cw'];
    2505. 

  2505.         if($w==0)
    2506. 

  2506.             $w=$this->pdf->w-$this->pdf->rMargin-$this->pdf->x;
    2507. 

  2507.         $wmax=($w-2*$this->pdf->cMargin)*1000/$this->pdf->FontSize;
    2508. 

  2508.         $s=str_replace("\r",'',$txt);
    2509. 

  2509.         $nb=strlen($s);
    2510. 

  2510.         if($nb>0 and $s[$nb-1]=="\n")
    2511. 

  2511.             $nb--;
    2512. 

  2512.         $sep=-1;
    2513. 

  2513.         $i=0;
    2514. 

  2514.         $j=0;
    2515. 

  2515.         $l=0;
    2516. 

  2516.         $nl=1;
    2517. 

  2517.         while($i<$nb) {
    2518. 

  2518.             $c=$s[$i];
    2519. 

  2519.             if($c=="\n") {
    2520. 

  2520.                 $i++;
    2521. 

  2521.                 $sep=-1;
    2522. 

  2522.                 $j=$i;
    2523. 

  2523.                 $l=0;
    2524. 

  2524.                 $nl++;
    2525. 

  2525.                 continue;
    2526. 

  2526.             }
    2527. 

  2527.             if($c==' ')
    2528. 

  2528.                 $sep=$i;
    2529. 

  2529.             $l+=$cw[$c];
    2530. 

  2530.             if($l>$wmax) {
    2531. 

  2531.                 if($sep==-1) {
    2532. 

  2532.                     if($i==$j)
    2533. 

  2533.                         $i++;
    2534. 

  2534.                 }
    2535. 

  2535.                 else
    2536. 

  2536.                     $i=$sep+1;
    2537. 

  2537.                 $sep=-1;
    2538. 

  2538.                 $j=$i;
    2539. 

  2539.                 $l=0;
    2540. 

  2540.                 $nl++;
    2541. 

  2541.             }
    2542. 

  2542.             else
    2543. 

  2543.                 $i++;
    2544. 

  2544.         }
    2545. 

  2545.         return $nl;
    2546. 

  2546.     }
    2547. 

  2547.     
    2548. 

  2548. 

  2549. 	public function printlongtext($fontfamily,$fontstyle,$fontsize){
    2550. 

  2550. 					//$this->gotTextOverPage=false;
    2551. 

  2551. 						
    2552. 

  2552. 							$this->pageFooter();
    2553. 

  2553. 						$this->pageHeader();
    2554. 

  2554. 					$this->hideheader==true;
    2555. 

  2555. 					
    2556. 

  2556. 					$this->currentband='detail';  
    2557. 

  2557. 					$this->pdf->SetFont($fontfamily,$fontstyle,$fontsize);
    2558. 

  2558. 					$this->pdf->SetTextColor($this->forcetextcolor_r,$this->forcetextcolor_g,$this->forcetextcolor_b);
    2559. 

  2559. 					//$this->pdf->SetTextColor(44,123,4);
    2560. 

  2560. 					$this->pdf->SetFillColor($this->forcefillcolor_r,$this->forcefillcolor_g,$this->forcefillcolor_b);
    2561. 

  2561. 

  2562. 					$bltxt=$this->continuenextpageText; 
    2563. 

  2563. 					$this->pdf->SetY($this->arraypageHeader[0]["height"]+15);
    2564. 

  2564. 					$this->pdf->SetX($bltxt['x']);
    2565. 

  2565. 					$maxheight=$this->arrayPageSetting["pageHeight"]-$this->arraypageFooter[0]["height"]-$this->pdf->GetY()-$bltxt['height'];
    2566. 

  2566. 

  2567. 					$this->pdf->MultiCell($bltxt['width'],$bltxt['height'],$bltxt['txt'],
    2568. 

  2568. 								$bltxt['border'],
    2569. 

  2569. 								$bltxt['align'],$bltxt['fill'],$bltxt['ln'],'','',$bltxt['reset'],
    2570. 

  2570. 								$bltxt['streth'],$bltxt['ishtml'],$bltxt['autopadding'],$maxheight-$bltxt['height']);
    2571. 

  2571. 							
    2572. 

  2572. 					   if($this->pdf->balancetext!=''){
    2573. 

  2573. 							$this->continuenextpageText=array('width'=>$bltxt["width"], 'height'=>$bltxt["height"], 
    2574. 

  2574. 								'txt'=>$this->pdf->balancetext,	'border'=>$bltxt["border"] ,'align'=>$bltxt["align"], 'fill'=>$bltxt["fill"],'ln'=>1,
    2575. 

  2575. 										'x'=>$bltxt['x'],'y'=>'','reset'=>true,'streth'=>0,'ishtml'=>false,'autopadding'=>true);
    2576. 

  2576. 								$this->pdf->balancetext='';
    2577. 

  2577. 								$this->printlongtext($fontfamily,$fontstyle,$fontsize);
    2578. 

  2578. 					  }
    2579. 

  2579. 					//echo $this->currentband;  
    2580. 

  2580. 				if( $this->pdf->balancetext=='' && $this->currentband=='detail'){
    2581. 

  2581. 					if($this->maxpagey['page_'.($this->pdf->getPage()-1)]=='')
    2582. 

  2582. 						$this->maxpagey['page_'.($this->pdf->getPage()-1)]=$this->pdf->GetY();
    2583. 

  2583. 					else{
    2584. 

  2584. 						if($this->maxpagey['page_'.($this->pdf->getPage()-1)]<$this->pdf->GetY())
    2585. 

  2585. 								$this->maxpagey['page_'.($this->pdf->getPage()-1)]=$this->pdf->GetY();
    2586. 

  2586. 					}
    2587. 

  2587. 					
    2588. 

  2588. 				}
    2589. 

  2589. 		}
    2590. 

  2590. 		
    2591. 

  2591. 		
    2592. 

  2592.     public function detail() {
    2593. 

  2593. 		
    2594. 

  2594. 		$currentpage= $this->pdf->getNumPages();
    2595. 

  2595. 		$this->maxpagey=array();
    2596. 

  2596.         $this->currentband='detail';
    2597. 

  2597.    
    2598. 

  2598.         $this->arraydetail[0]["y_axis"]=$this->arraydetail[0]["y_axis"]- $this->titleheight;
    2599. 

  2599.         $field_pos_y=$this->arraydetail[0]["y_axis"];
    2600. 

  2600.         $biggestY=0;
    2601. 

  2601.         $tempY=$this->arraydetail[0]["y_axis"];
    2602. 

  2602.         
    2603. 

  2603.         if(isset($this->SubReportCheckPoint))
    2604. 

  2604. 			$checkpoint=$this->SubReportCheckPoint;
    2605. 

  2605.       //  else
    2606. 

  2606. 		//	$checkpoint=$this->arraydetail[0]["y_axis"];
    2607. 

  2607. 			$checkpoint=$this->arraydetail[0]["y_axis"];
    2608. 

  2608. 

  2609. //		$this->pdf->SetY($checkpoint);
    2610. 

  2610. 	//	$this->pdf->MultiCell(200,10,"====",1);
    2611. 

  2611. 

  2612. 	    $gheader=$this->showGroupHeader($this->arrayPageSetting["topMargin"]+$this->arraypageHeader[0]["height"]);
    2613. 

  2613. 		$isgroupfooterprinted=false;
    2614. 

  2614. //		$this->pdf->SetY($checkpoint+$gheader);
    2615. 

  2615. 	//	$this->pdf->MultiCell(200,10,"????",1);
    2616. 

  2616. 		$this->maxpagey=array('page_0'=>$checkpoint);
    2617. 

  2617.         $rownum=0; 
    2618. 

  2618.         
    2619. 

  2619.         if($this->arraysqltable) {
    2620. 

  2620. 		$n=0;
    2621. 

  2621.             foreach($this->arraysqltable as $row) {
    2622. 

  2622. 	
    2623. 

  2623. 	
    2624. 

  2624. 		//	$this->currentband='detail';
    2625. 

  2625.    			$n++;
    2626. 

  2626. 				$currentpage= $this->pdf->getNumPages();
    2627. 

  2627. 				
    2628. 

  2628. 				$this->pdf->lastPage();
    2629. 

  2629. 				$this->hideheader==false;
    2630. 

  2630. 					
    2631. 

  2631. 				if($n>1)
    2632. 

  2632. 					$checkpoint=$this->maxpagey['page_'.($this->pdf->getNumPages()-1)];
    2633. 

  2633.       //                   echo $checkpoint."<br/>";
    2634. 

  2634. 

  2635. 		$pageheight=$this->arrayPageSetting["pageHeight"];
    2636. 

  2636. 		$footerheight=$this->footerbandheight;
    2637. 

  2637. 		$headerheight=$this->headerbandheight;
    2638. 

  2638. 		$bottommargin=$this->arrayPageSetting["bottomMargin"];
    2639. 

  2639. 		$detailheight=$this->detailbandheight;
    2640. 

  2640. 		
    2641. 

  2641. 		//if content near page footer
    2642. 

  2642. 		if($checkpoint>= $pageheight- $footerheight -$bottommargin- $detailheight-1){
    2643. 

  2643. 						$this->pageFooter();
    2644. 

  2644. 						$this->pageHeader();
    2645. 

  2645. 						$currentpage= $this->pdf->getNumPages();
    2646. 

  2646. 						$checkpoint=$this->arrayPageSetting["topMargin"]+$this->arraypageHeader[0]["height"];//$this->arraydetail[0]["y_axis"]- $this->titleheight;
    2647. 

  2647. 						$this->maxpagey[($this->pdf->getPage()-1)]=$checkpoint;
    2648. 

  2648. 			}
    2649. 

  2649. 

  2650. 				if(isset($this->arrayVariable))	//if self define variable existing, go to do the calculation
    2651. 

  2651.                     $this->variable_calculation($rownum, $this->arraysqltable[$this->global_pointer][$this->group_pointer]);
    2652. 

  2652.                 
    2653. 

  2653. 		if(isset($this->arraygroup)&&($this->global_pointer>0)&&
    2654. 

  2654.                         ($this->arraysqltable[$this->global_pointer][$this->group_pointer]!=$this->arraysqltable[$this->global_pointer-1][$this->group_pointer])){	//check the group's groupExpression existed and same or not
    2655. 

  2655. 

  2656. 					if($isgroupfooterprinted==true){
    2657. 

  2657. 						$gfoot=0;
    2658. 

  2658. 					}
    2659. 

  2659. 					
    2660. 

  2660.                    $ghheight=$this->showGroupHeader($checkpoint+$gfoot);
    2661. 

  2661.                    $isgroupfooterprinted=false;
    2662. 

  2662. 					$checkpoint=$checkpoint+$gfoot+$ghheight;//after group header add height band, so detail no crash with group header.	
    2663. 

  2663.                    $this->footershowed=true;
    2664. 

  2664.                     $this->pdf->SetY($checkpoint); 
    2665. 

  2665.          			$this->group_count["$this->group_name"]=1;	// We're on the first row of the group.				 
    2666. 

  2666. 		
    2667. 

  2667.                 }
    2668. 

  2668. 

  2669. 

  2670. 		$this->currentband='detail';
    2671. 

  2671. 	
    2672. 

  2672. /* begin page handling*/
    2673. 

  2673. 

  2674. 

  2675. //begin page handling
    2676. 

  2676.                 foreach ($this->arraydetail as $out) {
    2677. 

  2677. //						echo $out["hidden_type"]."<br/>";
    2678. 

  2678.                     switch ($out["hidden_type"]) {
    2679. 

  2679.                         case "field":
    2680. 

  2680.                      //        $txt=$this->analyse_expression($compare["txt"]);
    2681. 

  2681. 

  2682. 							$maxheight=$this->arrayPageSetting["pageHeight"]-$this->arraypageFooter[0]["height"]-$this->pdf->GetY()-15;
    2683. 

  2683.                             $this->prepare_print_array=array("type"=>"MultiCell","width"=>$out["width"],"height"=>$out["height"],"txt"=>$out["txt"],
    2684. 

  2684. 									"border"=>$out["border"],"align"=>$out["align"],"fill"=>$out["fill"],"hidden_type"=>$out["hidden_type"],
    2685. 

  2685. 									"printWhenExpression"=>$out["printWhenExpression"],"soverflow"=>$out["soverflow"],"poverflow"=>$out["poverflow"],"link"=>$out["link"],
    2686. 

  2686. 									"pattern"=>$out["pattern"],"writeHTML"=>$out["writeHTML"],"isPrintRepeatedValues"=>$out["isPrintRepeatedValues"]);
    2687. 

  2687.                             $this->display($this->prepare_print_array,0,true,$maxheight);
    2688. 

  2688.               //                                  $checkpoint=$this->arraydetail[0]["y_axis"];
    2689. 

  2689. 

  2690. 					        break;
    2691. 

  2691.                         case "relativebottomline":
    2692. 

  2692.                         //$this->relativebottomline($out,$tempY);
    2693. 

  2693.                             $this->relativebottomline($out,$biggestY);
    2694. 

  2694.                             break;
    2695. 

  2695.                           case "subreport":
    2696. 

  2696.                             $this->display($out,$checkpoint);
    2697. 

  2697. 						 break;
    2698. 

  2698.                         default:
    2699. 

  2699. 							//echo $out["hidden_type"]."=".print_r($out,true)."<br/><br/>";
    2700. 

  2700.                             $this->display($out,$checkpoint);
    2701. 

  2701. 							$maxheight=$this->arrayPageSetting["pageHeight"]-$this->arraypageFooter[0]["height"]-$this->pdf->GetY()-15;
    2702. 

  2702. 				//				$checkpoint=$this->arraydetail[0]["y_axis"];
    2703. 

  2703. 

  2704.                             //$checkpoint=$this->pdf->GetY();
    2705. 

  2705.                             break;
    2706. 

  2706.                     }
    2707. 

  2707.                     
    2708. 

  2708.                     $this->pdf->setPage($currentpage);
    2709. 

  2709. 

  2710.                 }
    2711. 

  2711. 

  2712. 				$this->pdf->lastPage();
    2713. 

  2713. 								
    2714. 

  2714. //                if($this->SubReportCheckPoint>0)
    2715. 

  2715. 	//				$biggestY=$this->SubReportCheckPoint;
    2716. 

  2716. 		//			$this->SubReportCheckPoint=0; //if subreport return position
    2717. 

  2717. 

  2718.         if(isset($this->arraygroup)&&
    2719. 

  2719.            ($this->arraysqltable[$this->global_pointer][$this->group_pointer]!=$this->arraysqltable[$this->global_pointer+1][$this->group_pointer])){
    2720. 

  2720. 

  2721. 

  2722. 

  2723. 

  2724. 		$pageheight=$this->arrayPageSetting["pageHeight"];
    2725. 

  2725. 		$footerheight=$this->footerbandheight;
    2726. 

  2726. 		$headerheight=$this->headerbandheight;
    2727. 

  2727. 		$topmargin=$this->arrayPageSetting["topMargin"];
    2728. 

  2728. 		$bottommargin=$this->arrayPageSetting["bottomMargin"];
    2729. 

  2729. 		$detailheight=$this->detailbandheight;
    2730. 

  2730. 		$gfootheight=$this->arraygroupfoot[0]['height'];
    2731. 

  2731. 		$currentY=$this->maxpagey['page_'.($this->pdf->getNumPages()-1)];
    2732. 

  2732. 		
    2733. 

  2733. 		if(($currentY+$gfootheight) < ($pageheight-$bottommargin-$footerheight)){
    2734. 

  2734.                          
    2735. 

  2735. 							$gfoot= $this->showGroupFooter($this->maxpagey['page_'.($this->pdf->getPage()-1)]);
    2736. 

  2736. 							$checkpoint=$this->maxpagey['page_'.($this->pdf->getNumPages()-1)]+$gfoot;
    2737. 

  2737. 						  				      
    2738. 

  2738. 						}else{
    2739. 

  2739. 						$this->pageFooter();
    2740. 

  2740. 						$hhead=	$this->pageHeader($this->arrayPageSetting["topMargin"]+$this->arraypageHeader[0]["height"]);
    2741. 

  2741. 	//					  $checkpoint=$this->maxpagey['page_'.($this->pdf->getNumPages()-1)]+$gfoot;						      
    2742. 

  2742.                          $gfoot= $this->showGroupFooter($headerheight+$this->arrayPageSetting["topMargin"]);
    2743. 

  2743.                          $isgroupfooterprinted=true;
    2744. 

  2744. 						//	$this->pdf->Cell(100,30,"New pages footer",1);
    2745. 

  2745. 						  $checkpoint=$gfoot+$headerheight+$this->arrayPageSetting["topMargin"];//$hhead+$this->arrayPageSetting["topMargin"]+$this->arraypageHeader[0]["height"]+$gfoot;						      
    2746. 

  2746. 							$this->maxpagey['page_'.($this->pdf->getNumPages()-1)]=	$checkpoint;
    2747. 

  2747. 						
    2748. 

  2748. 							}  
    2749. 

  2749.                         $this->currentband='detail';
    2750. 

  2750.    			            }
    2751. 

  2751. 

  2752. 				foreach($this->group_count as &$cntval) {
    2753. 

  2753. 					$cntval++;
    2754. 

  2754. 				}
    2755. 

  2755. 				$this->report_count++;
    2756. 

  2756. 				
    2757. 

  2757.                 $this->global_pointer++;
    2758. 

  2758.                    $rownum++;			   
    2759. 

  2759. 				  $this->pdf->lastpage();
    2760. 

  2760. 				  $headerY=$checkpoint;            
    2761. 

  2761.             
    2762. 

  2762.             }
    2763. 

  2763.         
    2764. 

  2764.         
    2765. 

  2765. 					$this->global_pointer--;
    2766. 

  2766.         }else {
    2767. 

  2767.             echo "No data found";
    2768. 

  2768.             exit(0);
    2769. 

  2769.         }
    2770. 

  2770.  
    2771. 

  2771.  
    2772. 

  2772.  			
    2773. 

  2773. 

  2774. 

  2775. 

  2776. //        $this->global_pointer--;
    2777. 

  2777.            if($this->arraysummary[0]["height"]>0)
    2778. 

  2778.                     $this->summary($checkpoint);
    2779. 

  2779.  
    2780. 

  2780.         if(isset($this->arraylastPageFooter))
    2781. 

  2781.             $this->lastPageFooter();
    2782. 

  2782.         else
    2783. 

  2783.              $this->pageFooter();
    2784. 

  2784.        
    2785. 

  2785.         $this->currentband='';
    2786. 

  2786.         
    2787. 

  2787.    			
    2788. 

  2788.     }
    2789. 

  2789.     
    2790. 

  2790.         public function detailNewPage() {
    2791. 

  2791. 		$currentpage= $this->pdf->getNumPages();
    2792. 

  2792. 		$this->maxpagey=array();
    2793. 

  2793.         $this->currentband='detail';
    2794. 

  2794.    
    2795. 

  2795.         $this->arraydetail[0]["y_axis"]=$this->arraydetail[0]["y_axis"]- $this->titleheight;
    2796. 

  2796.         $field_pos_y=$this->arraydetail[0]["y_axis"];
    2797. 

  2797.         $biggestY=0;
    2798. 

  2798.         $tempY=$this->arraydetail[0]["y_axis"];
    2799. 

  2799.         
    2800. 

  2800.         if(isset($this->SubReportCheckPoint))
    2801. 

  2801. 			$checkpoint=$this->SubReportCheckPoint;
    2802. 

  2802. //        else
    2803. 

  2803. 	//		$checkpoint=$this->arraydetail[0]["y_axis"];
    2804. 

  2804. 			$checkpoint=$this->arraydetail[0]["y_axis"];
    2805. 

  2805. 

  2806. //		$this->pdf->SetY($checkpoint);
    2807. 

  2807. 	//	$this->pdf->MultiCell(200,10,"====",1);
    2808. 

  2808. 

  2809. 	  //  $gheader=$this->showGroupHeader($this->arrayPageSetting["topMargin"]+$this->arraypageHeader[0]["height"]);
    2810. 

  2810. 

  2811. //		$this->pdf->SetY($checkpoint+$gheader);
    2812. 

  2812. 	//	$this->pdf->MultiCell(200,10,"????",1);
    2813. 

  2813. 		$this->maxpagey=array('page_0'=>$checkpoint);
    2814. 

  2814.         $rownum=0; 
    2815. 

  2815.         
    2816. 

  2816.         if($this->arraysqltable) {
    2817. 

  2817. 		$n=0;
    2818. 

  2818.             foreach($this->arraysqltable as $row) {
    2819. 

  2819. 	
    2820. 

  2820. 	
    2821. 

  2821. 		//	$this->currentband='detail';
    2822. 

  2822.    			$n++;
    2823. 

  2823. 				$currentpage= $this->pdf->getNumPages();
    2824. 

  2824. 				
    2825. 

  2825. 				$this->pdf->lastPage();
    2826. 

  2826. 				if($n>1)
    2827. 

  2827. 					$checkpoint=$this->maxpagey['page_'.($this->pdf->getNumPages()-1)];
    2828. 

  2828.       //                   echo $checkpoint."<br/>";
    2829. 

  2829. 

  2830. 		$pageheight=$this->arrayPageSetting["pageHeight"];
    2831. 

  2831. 		$footerheight=$this->footerbandheight;
    2832. 

  2832. 		$headerheight=$this->headerbandheight;
    2833. 

  2833. 		$bottommargin=$this->arrayPageSetting["bottomMargin"];
    2834. 

  2834. 		$detailheight=$this->detailbandheight;
    2835. 

  2835. 		$topmargin=$this->arrayPageSetting["topmargin"];
    2836. 

  2836. 

  2837. 		
    2838. 

  2838. 		//if content near page footer
    2839. 

  2839. 		if($checkpoint>= $pageheight- $footerheight -$bottommargin- $detailheight-1){
    2840. 

  2840. 						$this->pageFooter();
    2841. 

  2841. 		                $this->pageHeaderNewPage();
    2842. 

  2842. 						$this->pdf->lastpage();
    2843. 

  2843. 						$currentpage= $this->pdf->getNumPages();
    2844. 

  2844. 						$checkpoint=$this->arrayPageSetting["topMargin"]+$this->arraypageHeader[0]["height"]+$this->arraygrouphead[0]['height'];//$this->arraydetail[0]["y_axis"]- $this->titleheight;
    2845. 

  2845. 	//	$this->pdf->Cell(300,10,"$currentY+$gfootheight > $pageheight-$bottommargin-$footerheight",1);
    2846. 

  2846.  						$this->maxpagey[($this->pdf->getPage()-1)]=$checkpoint;
    2847. 

  2847. 			}
    2848. 

  2848. 

  2849. 				if(isset($this->arrayVariable))	//if self define variable existing, go to do the calculation
    2850. 

  2850.                     $this->variable_calculation($rownum, $this->arraysqltable[$this->global_pointer][$this->group_pointer]);
    2851. 

  2851.                 
    2852. 

  2852. 

  2853. 				if(isset($this->arraygroup)&&($this->global_pointer>0)&&
    2854. 

  2854.                         ($this->arraysqltable[$this->global_pointer][$this->group_pointer]!=$this->arraysqltable[$this->global_pointer-1][$this->group_pointer])){	//check the group's groupExpression existed and same or not
    2855. 

  2855. 						$this->pageFooter();
    2856. 

  2856.                     $this->pageHeaderNewPage();
    2857. 

  2857. 					$this->pdf->lastPage();
    2858. 

  2858. 						$currentpage= $this->pdf->getNumPages();
    2859. 

  2859. 

  2860. 					$checkpoint=$this->arrayPageSetting["topMargin"]+$this->arraypageHeader[0]["height"]+$this->arraygrouphead[0]['height'];
    2861. 

  2861. 					$this->maxpagey[($this->pdf->getPage()-1)]=$checkpoint;
    2862. 

  2862. 					
    2863. 

  2863. 					$this->footershowed=true;
    2864. 

  2864.          			$this->group_count["$this->group_name"]=1;	// We're on the first row of the group.				 
    2865. 

  2865. 		
    2866. 

  2866.                 }
    2867. 

  2867. 

  2868. 

  2869. 		$this->currentband='detail';
    2870. 

  2870. 	
    2871. 

  2871. /* begin page handling*/
    2872. 

  2872. 

  2873. //                    $this->pdf->Cell(200,10,"?*$checkpoint"); 
    2874. 

  2874. 

  2875. //begin page handling
    2876. 

  2876.                 foreach ($this->arraydetail as $out) {
    2877. 

  2877. //						echo $out["hidden_type"]."<br/>";
    2878. 

  2878.                     switch ($out["hidden_type"]) {
    2879. 

  2879.                         case "field":
    2880. 

  2880.                      //        $txt=$this->analyse_expression($compare["txt"]);
    2881. 

  2881. //                $this->pdf->SetY($checkpoint);
    2882. 

  2882.     
    2883. 

  2883. 							$maxheight=$this->arrayPageSetting["pageHeight"]-$this->arraypageFooter[0]["height"]-$this->pdf->GetY()-10;
    2884. 

  2884.                             $this->prepare_print_array=array("type"=>"MultiCell","width"=>$out["width"],"height"=>$out["height"],"txt"=>$out["txt"],
    2885. 

  2885. 									"border"=>$out["border"],"align"=>$out["align"],"fill"=>$out["fill"],"hidden_type"=>$out["hidden_type"],
    2886. 

  2886. 									"printWhenExpression"=>$out["printWhenExpression"],"soverflow"=>$out["soverflow"],"poverflow"=>$out["poverflow"],"link"=>$out["link"],
    2887. 

  2887. 									"pattern"=>$out["pattern"],"writeHTML"=>$out["writeHTML"],"isPrintRepeatedValues"=>$out["isPrintRepeatedValues"]);
    2888. 

  2888. //		$this->pdf->Cell(300,10,"==$checkpoint --",1);
    2889. 

  2889.                             $this->display($this->prepare_print_array,0,true,$maxheight);
    2890. 

  2890.               //                                  $checkpoint=$this->arraydetail[0]["y_axis"];
    2891. 

  2891. 

  2892. 					        break;
    2893. 

  2893.                         case "relativebottomline":
    2894. 

  2894.                         //$this->relativebottomline($out,$tempY);
    2895. 

  2895.                             $this->relativebottomline($out,$biggestY);
    2896. 

  2896.                             break;
    2897. 

  2897.                           case "":
    2898. 

  2898.                           ;
    2899. 

  2899.                           break;
    2900. 

  2900.                         default:
    2901. 

  2901.                             $this->display($out,$checkpoint);
    2902. 

  2902.                             break;
    2903. 

  2903.                     }
    2904. 

  2904.                     
    2905. 

  2905.                     $this->pdf->setPage($currentpage);
    2906. 

  2906. 

  2907.                 }
    2908. 

  2908. 

  2909. 				$this->pdf->lastPage();
    2910. 

  2910. 								
    2911. 

  2911.                 if($this->SubReportCheckPoint>0)
    2912. 

  2912. 					$biggestY=$this->SubReportCheckPoint; $this->SubReportCheckPoint=0; //if subreport return position
    2913. 

  2913. 

  2914.         if(isset($this->arraygroup)&&
    2915. 

  2915.            ($this->arraysqltable[$this->global_pointer][$this->group_pointer]!=$this->arraysqltable[$this->global_pointer+1][$this->group_pointer])){
    2916. 

  2916. 

  2917. 

  2918. 

  2919. 

  2920. 		$pageheight=$this->arrayPageSetting["pageHeight"];
    2921. 

  2921. 		$footerheight=$this->footerbandheight;
    2922. 

  2922. 		$headerheight=$this->headerbandheight;
    2923. 

  2923. 		$topmargin=$this->arrayPageSetting["topMargin"];
    2924. 

  2924. 		$bottommargin=$this->arrayPageSetting["bottomMargin"];
    2925. 

  2925. 		$detailheight=$this->detailbandheight;
    2926. 

  2926. 		$gfootheight=$this->arraygroupfoot[0]['height'];
    2927. 

  2927. 		$currentY=$this->maxpagey['page_'.($this->pdf->getNumPages()-1)];
    2928. 

  2928. //		$this->pdf->Cell(300,10,"$currentY+$gfootheight > $pageheight-$bottommargin-$footerheight",1);
    2929. 

  2929. 

  2930. 

  2931. 		if(($currentY+$gfootheight) < ($pageheight-$bottommargin-$footerheight)){
    2932. 

  2932.                          
    2933. 

  2933. 							$gfoot= $this->showGroupFooter($this->maxpagey['page_'.($this->pdf->getPage()-1)]);
    2934. 

  2934. 							$checkpoint=$this->maxpagey['page_'.($this->pdf->getNumPages()-1)]+$gfoot;
    2935. 

  2935. 						  				      
    2936. 

  2936. 						}else{
    2937. 

  2937. 							$gfoot= $this->showGroupFooter($this->maxpagey['page_'.($this->pdf->getPage()-1)]);
    2938. 

  2938. 							$checkpoint=$this->maxpagey['page_'.($this->pdf->getNumPages()-1)]+$gfoot;
    2939. 

  2939. 			//			                    $this->pageHeader();
    2940. 

  2940. 

  2941. 			//			$this->pageHeader($this->arrayPageSetting["topMargin"]+$this->arraypageHeader[0]["height"]);
    2942. 

  2942.       //                   $gfoot= $this->showGroupFooter($this->maxpagey['page_'.($this->pdf->getPage()-1)]);
    2943. 

  2943. 		//				  $checkpoint=$this->maxpagey['page_'.($this->pdf->getNumPages()-1)]+$gfoot;						      
    2944. 

  2944. 				
    2945. 

  2945. 							}  
    2946. 

  2946.                         $this->currentband='detail';
    2947. 

  2947.    			            }
    2948. 

  2948. 

  2949. 				foreach($this->group_count as &$cntval) {
    2950. 

  2950. 					$cntval++;
    2951. 

  2951. 				}
    2952. 

  2952. 				$this->report_count++;
    2953. 

  2953. 				
    2954. 

  2954.                 $this->global_pointer++;
    2955. 

  2955.                    $rownum++;			   
    2956. 

  2956. 				  $this->pdf->lastpage();
    2957. 

  2957. 				  $headerY=$checkpoint;            
    2958. 

  2958.             
    2959. 

  2959.             }
    2960. 

  2960.         
    2961. 

  2961.         
    2962. 

  2962. 					$this->global_pointer--;
    2963. 

  2963.         }else {
    2964. 

  2964.             echo "No data found";
    2965. 

  2965.             exit(0);
    2966. 

  2966.         }
    2967. 

  2967.  
    2968. 

  2968.  
    2969. 

  2969.  			
    2970. 

  2970. 

  2971. 

  2972. 

  2973.         $this->global_pointer--;
    2974. 

  2974.            if($this->arraysummary[0]["height"]>0)
    2975. 

  2975.                     $this->summary($checkpoint);
    2976. 

  2976.  
    2977. 

  2977.         if(isset($this->arraylastPageFooter))
    2978. 

  2978.             $this->lastPageFooter();
    2979. 

  2979.         else
    2980. 

  2980.              $this->pageFooter();
    2981. 

  2981.        
    2982. 

  2982.         $this->currentband='';
    2983. 

  2983.         
    2984. 

  2984.    			
    2985. 

  2985.     }
    2986. 

  2986. 

  2987. /*
    2988. 

  2988.     public function detailNewPage() {
    2989. 

  2989.         $this->arraydetail[0]["y_axis"]=$this->arraydetail[0]["y_axis"]- $this->titleheight;
    2990. 

    2991. 

  2991.         $field_pos_y=$this->arraydetail[0]["y_axis"];
    2992. 

  2992.         $biggestY=0;
    2993. 

  2993.         $checkpoint=$this->arraydetail[0]["y_axis"];
    2994. 

  2994.         $tempY=$this->arraydetail[0]["y_axis"];
    2995. 

  2995.         $i=0;
    2996. 

    2997. 

    2998. 

  2998.         if($this->arraysqltable) {
    2999. 

  2999.             $oo=0;
    3000. 

    3001. 

  3001.             foreach($this->arraysqltable as $row) {
    3002. 

  3002.                 $oo++;
    3003. 

    3004. 

  3004.                 //check the group's groupExpression existed and same or not
    3005. 

  3005.                 if(isset($this->arraygroup)&&($this->global_pointer>0)&&($this->arraysqltable[$this->global_pointer][$this->group_pointer]!=$this->arraysqltable[$this->global_pointer-1][$this->group_pointer])) {
    3006. 

    3007. 

  3007.                 if(isset($this->arrayVariable))	//if self define variable existing, go to do the calculation
    3008. 

  3008.                 {
    3009. 

  3009.                     $this->variable_calculation($rownum, $this->arraysqltable[$this->global_pointer][$this->group_pointer]);
    3010. 

  3010.                 }
    3011. 

  3011.                     $this->pageFooter();
    3012. 

  3012.                     $this->pageHeaderNewPage();
    3013. 

  3013.                     $checkpoint=$this->arraydetail[0]["y_axis"];
    3014. 

  3014.                     $biggestY = 0;
    3015. 

  3015.                     $tempY=$this->arraydetail[0]["y_axis"];
    3016. 

  3016. //###                     $this->group_count=0;
    3017. 

  3017. 					$this->group_count["$this->group_name"]=1;
    3018. 

  3018. //### End of modification
    3019. 

  3019.                 }
    3020. 

    3021. 

  3021.                 foreach($this->arraydetail as $compare)	//this loop is to count possible biggest Y of the coming row
    3022. 

  3022.                 {$this->currentrow=$this->arraysqltable[$this->global_pointer];
    3023. 

  3023.                     switch($compare["hidden_type"]) {
    3024. 

  3024.                         case "field":
    3025. 

  3025.                             $txt=$this->analyse_expression($row["$compare[txt]"]);
    3026. 

  3026.                             //check group footer existed or not
    3027. 

    3028. 

  3028.                             if(isset($this->arraygroup[$this->group_name]["groupFooter"])&&(($checkpoint+($compare["height"]*$txt))>($this->arrayPageSetting[pageHeight]-$this->arraygroup["$this->group_name"][groupFooter][0]["height"]-$this->arrayPageSetting["bottomMargin"]))) {
    3029. 

  3029.                              //   $this->showGroupHeader();
    3030. 

  3030.                                 $this->showGroupFooter();
    3031. 

  3031.                                 $this->pageFooter();
    3032. 

  3032.                                // $this->pdf->AddPage();
    3033. 

  3033.                              //   $this->background();
    3034. 

  3034.                                 $this->pageHeaderNewPage();
    3035. 

    3036. 

  3036.                                 $checkpoint=$this->arraydetail[0]["y_axis"];
    3037. 

  3037.                                 $biggestY=0;
    3038. 

  3038.                                 $tempY=$this->arraydetail[0]["y_axis"];
    3039. 

  3039.                             }
    3040. 

  3040.                             //check pagefooter existed or not
    3041. 

  3041.                             elseif(isset($this->arraypageFooter)&&(($checkpoint+($compare["height"]*($this->NbLines($compare["width"],$txt))))>($this->arrayPageSetting["pageHeight"]-$this->arraypageFooter[0]["height"]-$this->arrayPageSetting["bottomMargin"]))) {
    3042. 

  3042.                                 $this->showGroupFooter();
    3043. 

  3043.                                 $this->pageFooter();
    3044. 

  3044.                               //  $this->pdf->AddPage();
    3045. 

  3045.                                 $this->pageHeaderNewPage();
    3046. 

  3046.                            //     $this->showGroupHeader();
    3047. 

  3047.                              //   $this->background();
    3048. 

  3048.                                 $headerY = $this->arrayPageSetting["topMargin"]+$this->arraypageHeader[0]["height"];
    3049. 

    3050. 

  3050.                                 $checkpoint=$this->arraydetail[0]["y_axis"];
    3051. 

  3051.                                 $biggestY=0;
    3052. 

  3052.                                 $tempY=$this->arraydetail[0]["y_axis"];
    3053. 

  3053.                             }
    3054. 

  3054.                             //check lastpagefooter existed or not
    3055. 

  3055.                             elseif(isset($this->arraylastPageFooter)&&(($checkpoint+($compare["height"]*($this->NbLines($compare["width"],$txt))))>($this->arrayPageSetting["pageHeight"]-$this->arraylastPageFooter[0]["height"]-$this->arrayPageSetting["bottomMargin"]))) {
    3056. 

    3057. 

  3057.                                 $this->showGroupFooter();
    3058. 

  3058.                                 $this->lastPageFooter();
    3059. 

  3059.                              //   $this->pdf->AddPage();
    3060. 

  3060.                                // $this->background();
    3061. 

  3061.                                 $this->pageHeaderNewPage();
    3062. 

    3063. 

  3063.                               //  $this->showGroupHeader();
    3064. 

  3064.                                 $checkpoint=$this->arraydetail[0]["y_axis"];
    3065. 

  3065.                                 $biggestY=0;
    3066. 

  3066.                                 $tempY=$this->arraydetail[0]["y_axis"];
    3067. 

  3067.                             }
    3068. 

    3069. 

  3069.                             if(($checkpoint+($compare["height"]*($this->NbLines($compare["width"],$txt))))>$tempY) {
    3070. 

  3070.                                 $tempY=$checkpoint+($compare["height"]*($this->NbLines($compare["width"],$txt)));
    3071. 

  3071.                             }
    3072. 

  3072.                             break;
    3073. 

  3073.                         case "relativebottomline":
    3074. 

  3074.                             break;
    3075. 

  3075.                         case "report_count":
    3076. 

  3076. //                            $this->report_count++;
    3077. 

  3077.                             break;
    3078. 

  3078.                                case "group_count":
    3079. 

  3079. //###                            $this->group_count++;
    3080. 

  3080.                             break;
    3081. 

  3081.                         default:
    3082. 

  3082.                             $this->display($compare,$checkpoint);
    3083. 

    3084. 

  3084.                             break;
    3085. 

  3085.                     }
    3086. 

  3086.                 }
    3087. 

    3088. 

    3089. 

    3090. 

  3090.                 if($checkpoint+$this->arraydetail[0]["height"]>($this->arrayPageSetting["pageHeight"]-$this->arraypageFooter[0]["height"]-$this->arrayPageSetting["bottomMargin"]))	//check the upcoming band is greater than footer position or not
    3091. 

  3091.                 {
    3092. 

  3092.                     $this->pageFooter();
    3093. 

    3094. 

  3094.               //      $this->pdf->AddPage();
    3095. 

  3095.                 //    $this->background();
    3096. 

  3096.                     $headerY = $this->arrayPageSetting["topMargin"]+$this->arraypageHeader[0]["height"];
    3097. 

  3097.                     $this->pageHeaderNewPage();
    3098. 

  3098.                   //  $this->showGroupHeader();
    3099. 

    3100. 

  3100.                     $checkpoint=$this->arraydetail[0]["y_axis"];
    3101. 

  3101.                     $biggestY=0;
    3102. 

  3102.                     $tempY=$this->arraydetail[0]["y_axis"];
    3103. 

  3103.                 }
    3104. 

    3105. 

  3105.                 foreach ($this->arraydetail as $out) {
    3106. 

  3106.                   $this->currentrow=$this->arraysqltable[$this->global_pointer];
    3107. 

  3107.                     switch ($out["hidden_type"]) {
    3108. 

  3108.                         case "field":
    3109. 

    3110. 

  3110.                             $this->prepare_print_array=array("type"=>"MultiCell","width"=>$out["width"],"height"=>$out["height"],"txt"=>$out["txt"],"border"=>$out["border"],"align"=>$out["align"],"fill"=>$out["fill"],"hidden_type"=>$out["hidden_type"],"printWhenExpression"=>$out["printWhenExpression"],"soverflow"=>$out["soverflow"],"poverflow"=>$out["poverflow"],"link"=>$out["link"],"pattern"=>$out["pattern"]);
    3111. 

  3111.                             $this->display($this->prepare_print_array,0,true);
    3112. 

    3113. 

  3113.                             if($this->pdf->GetY() > $biggestY) {
    3114. 

  3114.                                 $biggestY = $this->pdf->GetY();
    3115. 

  3115.                             }
    3116. 

  3116.                             break;
    3117. 

  3117.                         case "relativebottomline":
    3118. 

  3118.                         //$this->relativebottomline($out,$tempY);
    3119. 

  3119.                             $this->relativebottomline($out,$biggestY);
    3120. 

  3120.                             break;
    3121. 

  3121.                         default:
    3122. 

    3123. 

  3123.                             $this->display($out,$checkpoint);
    3124. 

    3125. 

  3125.                             //$checkpoint=$this->pdf->GetY();
    3126. 

  3126.                             break;
    3127. 

  3127.                     }
    3128. 

  3128.                 }
    3129. 

  3129.                 $this->pdf->SetY($biggestY);
    3130. 

  3130.                 if($biggestY>$checkpoint+$this->arraydetail[0]["height"]) {
    3131. 

  3131.                     $checkpoint=$biggestY;
    3132. 

  3132.                 }
    3133. 

  3133.                 elseif($biggestY<$checkpoint+$this->arraydetail[0]["height"]) {
    3134. 

  3134.                     $checkpoint=$checkpoint+$this->arraydetail[0]["height"];
    3135. 

  3135.                 }
    3136. 

  3136.                 else {
    3137. 

  3137.                     $checkpoint=$biggestY;
    3138. 

  3138.                 }
    3139. 

  3139. if(isset($this->arraygroup)&&($this->global_pointer>0)&&($this->arraysqltable[$this->global_pointer][$this->group_pointer]!=$this->arraysqltable[$this->global_pointer+1][$this->group_pointer]))
    3140. 

  3140.       $this->showGroupFooter($tempY);
    3141. 

  3141.                 //if(isset($this->arraygroup)){$this->global_pointer++;}
    3142. 

  3142.                 $this->global_pointer++;
    3143. 

  3143.             }
    3144. 

  3144.         }else {
    3145. 

  3145.             echo utf8_decode("Sorry cause there is not result from this query.");
    3146. 

  3146.             exit(0);
    3147. 

  3147.         }
    3148. 

  3148.         $this->global_pointer--;
    3149. 

  3149.                     $rownum++;
    3150. 

  3150.                        if($this->arraysummary[0]["height"]>0)
    3151. 

  3151.                     $this->summary();
    3152. 

  3152.         if(isset($this->arraylastPageFooter)) {
    3153. 

  3153.         //     $this->showGroupFooter();
    3154. 

  3154.             $this->lastPageFooter();
    3155. 

  3155.         }
    3156. 

  3156.         else {
    3157. 

  3157.         //     $this->showGroupFooter();
    3158. 

  3158.             $this->pageFooter();
    3159. 

  3159.         }
    3160. 

    3161. 

    3162. 

  3162.     }
    3163. 

  3163. */
    3164. 

  3164.     public function showGroupHeader($y) {
    3165. 

  3165.         $this->currentband='groupHeader';
    3166. 

  3166.         $bandheight=$this->arraygrouphead[0]['height'];
    3167. 

  3167.         foreach ($this->arraygrouphead as $out) {
    3168. 

  3168.             $this->display($out,$y,true);
    3169. 

  3169.         }
    3170. 

  3170.         $this->currentband='';
    3171. 

  3171.         return $bandheight;
    3172. 

  3172.     }
    3173. 

  3173.     public function showGroupFooter($y) {
    3174. 

  3174.         $this->currentband='groupFooter';
    3175. 

  3175.         //$this->pdf->MultiCell(100,10,"???1-$y,XY=". $this->pdf->GetX().",". $this->pdf->GetY());
    3176. 

  3176.         $bandheight=$this->arraygroupfoot[0]['height'];
    3177. 

  3177.         foreach ($this->arraygroupfoot as $out) {
    3178. 

  3178.             $this->display($out,$y,true);
    3179. 

  3179.         }
    3180. 

  3180.         $this->footershowed=true;
    3181. 

  3181.         $this->currentband='';
    3182. 

  3182.         return $bandheight;
    3183. 

  3183.         //$this->pdf->MultiCell(100,10,"???1-$y,XY=". $this->pdf->GetX().",". $this->pdf->GetY());
    3184. 

  3184. 

  3185.         $this->footershowed=true;
    3186. 

  3186.         return $bandheight;
    3187. 

  3187.         //$this->pdf->MultiCell(100,10,"???1-$y,XY=". $this->pdf->GetX().",". $this->pdf->GetY());
    3188. 

  3188. 

  3189.     }
    3190. 

  3190. 

  3191. 

  3192.     public function display($arraydata,$y_axis=0,$fielddata=false,$maxheight=0) {
    3193. 

  3193.   //print_r($arraydata);echo "<br/>";
    3194. 

  3194.     //    $this->pdf->Cell(10,10,"SSSS");
    3195. 

  3195.     $this->Rotate($arraydata["rotation"]);
    3196. 

  3196.     
    3197. 

  3197.     if($arraydata["rotation"]!=""){
    3198. 

  3198. 

  3199. 

  3200. 

  3201.     if($arraydata["rotation"]=="Left"){
    3202. 

  3202.          $w=$arraydata["width"];
    3203. 

  3203.         $arraydata["width"]=$arraydata["height"];
    3204. 

  3204.         $arraydata["height"]=$w;
    3205. 

  3205.             $this->pdf->SetXY($this->pdf->GetX()-$arraydata["width"],$this->pdf->GetY());
    3206. 

  3206.     }
    3207. 

  3207.     elseif($arraydata["rotation"]=="Right"){
    3208. 

  3208.          $w=$arraydata["width"];
    3209. 

  3209.         $arraydata["width"]=$arraydata["height"];
    3210. 

  3210.         $arraydata["height"]=$w;
    3211. 

  3211.             $this->pdf->SetXY($this->pdf->GetX(),$this->pdf->GetY()-$arraydata["height"]);
    3212. 

  3212.     }
    3213. 

  3213.     elseif($arraydata["rotation"]=="UpsideDown"){
    3214. 

  3214.         //soverflow"=>$stretchoverflow,"poverflow"
    3215. 

  3215.         $arraydata["soverflow"]=true;
    3216. 

  3216.         $arraydata["poverflow"]=true;
    3217. 

  3217.        //   $w=$arraydata["width"];
    3218. 

  3218.        // $arraydata["width"]=$arraydata["height"];
    3219. 

  3219.         //$arraydata["height"]=$w;
    3220. 

  3220.         $this->pdf->SetXY($this->pdf->GetX()- $arraydata["width"],$this->pdf->GetY()-$arraydata["height"]);
    3221. 

  3221.     }
    3222. 

  3222. 

  3223.     }
    3224. 

  3224. 

  3225.         if($arraydata["type"]=="SetFont") {
    3226. 

  3226.             if($arraydata["font"]=='uGB')
    3227. 

  3227.                 $this->pdf->isUnicode=true;
    3228. 

  3228.             else
    3229. 

  3229.                 $this->pdf->isUnicode=false;
    3230. 

  3230. 

  3231.             $this->pdf->SetFont($arraydata["font"],$arraydata["fontstyle"],$arraydata["fontsize"]);
    3232. 

  3232. 

  3233.         }
    3234. 

  3234.         elseif($arraydata["type"]=="subreport") {
    3235. 

  3235. 			
    3236. 

  3236.             $this->runSubReport($arraydata,$y_axis);
    3237. 

  3237. //            $y_axis=$this->SubReportCheckPoint;
    3238. 

  3238.         }
    3239. 

  3239.         elseif($arraydata["type"]=="MultiCell") {
    3240. 

  3240.            
    3241. 

  3241.             if($fielddata==false) {
    3242. 

  3242.                 $this->checkoverflow($arraydata,$this->updatePageNo($arraydata["txt"]),'',$maxheight);
    3243. 

  3243.             }
    3244. 

  3244.             elseif($fielddata==true) {
    3245. 

  3245.                 $this->checkoverflow($arraydata,$this->updatePageNo($this->analyse_expression($arraydata["txt"],$arraydata["isPrintRepeatedValues"] )),$maxheight);
    3246. 

  3246.             }
    3247. 

  3247.         }
    3248. 

  3248.         elseif($arraydata["type"]=="SetXY") {
    3249. 

  3249.             $this->pdf->SetXY($arraydata["x"]+$this->arrayPageSetting["leftMargin"],$arraydata["y"]+$y_axis);
    3250. 

  3250.         }
    3251. 

  3251.         elseif($arraydata["type"]=="Cell") {
    3252. 

  3252. 

  3253. 

  3254.             $this->pdf->Cell($arraydata["width"],$arraydata["height"],$this->updatePageNo($arraydata["txt"]),$arraydata["border"],$arraydata["ln"],$arraydata["align"],$arraydata["fill"],$arraydata["link"]);
    3255. 

  3255. 

  3256. 

  3257.         }
    3258. 

  3258.         elseif($arraydata["type"]=="Rect"){
    3259. 

  3259. 		if($arraydata['mode']=='Transparent')
    3260. 

  3260. 		$style='';
    3261. 

  3261. 		else
    3262. 

  3262. 		$style='FD';
    3263. 

  3263. 		
    3264. 

  3264. 			$this->pdf->Rect($arraydata["x"]+$this->arrayPageSetting["leftMargin"],$arraydata["y"]+$y_axis,$arraydata["width"],$arraydata["height"],
    3265. 

  3265. 			$style);
    3266. 

  3266.                 }
    3267. 

  3267.         elseif($arraydata["type"]=="RoundedRect"){
    3268. 

  3268. 			if($arraydata['mode']=='Transparent')
    3269. 

  3269. 				$style='';
    3270. 

  3270. 			else
    3271. 

  3271. 			$style='FD';
    3272. 

  3272. 			
    3273. 

  3273. 			 $this->pdf->RoundedRect($arraydata["x"]+$this->arrayPageSetting["leftMargin"], $arraydata["y"]+$y_axis, $arraydata["width"],$arraydata["height"], $arraydata["radius"], '1111', 
    3274. 

  3274. 			$style,array('color'=>$arraydata['drawcolor']),$arraydata['fillcolor']);
    3275. 

  3275. 			}
    3276. 

  3276.         elseif($arraydata["type"]=="Ellipse"){
    3277. 

  3277. 			 $this->pdf->Ellipse($arraydata["x"]+$arraydata["width"]/2+$this->arrayPageSetting["leftMargin"], $arraydata["y"]+$y_axis+$arraydata["height"]/2, $arraydata["width"]/2,$arraydata["height"]/2,
    3278. 

  3278. 				0,0,360,'FD',array('color'=>$arraydata['drawcolor']),$arraydata['fillcolor']);
    3279. 

  3279. 			}
    3280. 

  3280.         elseif($arraydata["type"]=="Image") {
    3281. 

  3281.             $path=$this->analyse_expression($arraydata["path"]);
    3282. 

  3282.             $imgtype=substr($path,-3);
    3283. 

  3283.             if($imgtype=='jpg')
    3284. 

  3284. 				$imgtype="JPEG";
    3285. 

  3285.          
    3286. 

  3286.         if(file_exists($path))
    3287. 

  3287.             $this->pdf->Image($path,$arraydata["x"]+$this->arrayPageSetting["leftMargin"],$arraydata["y"]+$y_axis,$arraydata["width"],$arraydata["height"],$imgtype,$arraydata["link"]);
    3288. 

  3288.         }
    3289. 

  3289. 

  3290.         elseif($arraydata["type"]=="SetTextColor") {
    3291. 

  3291. 			$this->textcolor_r=$arraydata['r'];
    3292. 

  3292. 			$this->textcolor_g=$arraydata['g'];
    3293. 

  3293. 			$this->textcolor_b=$arraydata['b'];
    3294. 

  3294. 			
    3295. 

  3295. 			if($this->hideheader==true && $this->currentband=='pageHeader')
    3296. 

  3296. 				$this->pdf->SetTextColor(100,33,30);
    3297. 

  3297. 			else
    3298. 

  3298. 				$this->pdf->SetTextColor($arraydata["r"],$arraydata["g"],$arraydata["b"]);
    3299. 

  3299.         }
    3300. 

  3300.         elseif($arraydata["type"]=="SetDrawColor") {
    3301. 

  3301. 			$this->drawcolor_r=$arraydata['r'];
    3302. 

  3302. 			$this->drawcolor_g=$arraydata['g'];
    3303. 

  3303. 			$this->drawcolor_b=$arraydata['b'];
    3304. 

  3304.             $this->pdf->SetDrawColor($arraydata["r"],$arraydata["g"],$arraydata["b"]);
    3305. 

  3305.         }
    3306. 

  3306.         elseif($arraydata["type"]=="SetLineWidth") {
    3307. 

  3307.             $this->pdf->SetLineWidth($arraydata["width"]);
    3308. 

  3308.         }
    3309. 

  3309.         elseif($arraydata["type"]=="Line") {
    3310. 

  3310.             $this->pdf->Line($arraydata["x1"]+$this->arrayPageSetting["leftMargin"],$arraydata["y1"]+$y_axis,$arraydata["x2"]+$this->arrayPageSetting["leftMargin"],$arraydata["y2"]+$y_axis);
    3311. 

  3311.         }
    3312. 

  3312.         elseif($arraydata["type"]=="SetFillColor") {
    3313. 

  3313. 			$this->fillcolor_r=$arraydata['r'];
    3314. 

  3314. 			$this->fillcolor_g=$arraydata['g'];
    3315. 

  3315. 			$this->fillcolor_b=$arraydata['b'];
    3316. 

  3316.             $this->pdf->SetFillColor($arraydata["r"],$arraydata["g"],$arraydata["b"]);
    3317. 

  3317.         }
    3318. 

  3318.       elseif($arraydata["type"]=="lineChart") {
    3319. 

  3319. 

  3320.             $this->showLineChart($arraydata, $y_axis);
    3321. 

  3321.         }
    3322. 

  3322.       elseif($arraydata["type"]=="barChart") {
    3323. 

  3323. 

  3324.             $this->showBarChart($arraydata, $y_axis,'barChart');
    3325. 

  3325.         }
    3326. 

  3326.       elseif($arraydata["type"]=="stackedBarChart") {
    3327. 

  3327. 

  3328.             $this->showBarChart($arraydata, $y_axis,'stackedBarChart');
    3329. 

  3329.         }
    3330. 

  3330.       elseif($arraydata["type"]=="stackedAreaChart") {
    3331. 

  3331. 

  3332.             $this->showAreaChart($arraydata, $y_axis,$arraydata["type"]);
    3333. 

  3333.         }
    3334. 

  3334. 

  3335.     }
    3336. 

  3336. 

  3337.     public function relativebottomline($path,$y) {
    3338. 

  3338.         $extra=$y-$path["y1"];
    3339. 

  3339.         $this->display($path,$extra);
    3340. 

  3340.     }
    3341. 

  3341. 

  3342.     public function updatePageNo($s) {
    3343. 

  3343.         return str_replace('$this->PageNo()', $this->pdf->PageNo(),$s);
    3344. 

  3344.     }
    3345. 

  3345. 

  3346.     public function staticText($xml_path) {//$this->pointer[]=array("type"=>"SetXY","x"=>$xml_path->reportElement["x"],"y"=>$xml_path->reportElement["y"]);
    3347. 

  3347.     }
    3348. 

  3348.     
    3349. 

  3349. 

  3350. 

  3351.     public function checkoverflow($arraydata,$txt="",$maxheight=0) {
    3352. 

  3352. 

  3353. 

  3354.         $this->print_expression($arraydata);
    3355. 

  3355. 

  3356.       
    3357. 

  3357.         if($this->print_expression_result==true) {
    3358. 

  3358. 

  3359.             if($arraydata["link"]) {
    3360. 

  3360.                 $arraydata["link"]=$this->analyse_expression($arraydata["link"],"");
    3361. 

  3361. 

  3362.             }
    3363. 

  3363. 

  3364.             if($arraydata["writeHTML"]==1 && $this->pdflib=="TCPDF") {
    3365. 

  3365.                 $this->pdf->writeHTML($txt);
    3366. 

  3366. 			$this->pdf->Ln();
    3367. 

  3367. 					if($this->currentband=='detail'){
    3368. 

  3368. 					if($this->maxpagey['page_'.($this->pdf->getPage()-1)]=='')
    3369. 

  3369. 						$this->maxpagey['page_'.($this->pdf->getPage()-1)]=$this->pdf->GetY();
    3370. 

  3370. 					else{
    3371. 

  3371. 						if($this->maxpagey['page_'.($this->pdf->getPage()-1)]<$this->pdf->GetY())
    3372. 

  3372. 							$this->maxpagey['page_'.($this->pdf->getPage()-1)]=$this->pdf->GetY();
    3373. 

  3373. 					}
    3374. 

  3374. 				}
    3375. 

  3375.             
    3376. 

  3376.             }
    3377. 

  3377.             elseif($arraydata["poverflow"]=="true"&&$arraydata["soverflow"]=="false") {
    3378. 

  3378.                 
    3379. 

  3379.                 $this->pdf->Cell($arraydata["width"], $arraydata["height"], $this->formatText($txt, $arraydata["pattern"]),$arraydata["border"],"",$arraydata["align"],$arraydata["fill"],$arraydata["link"]);
    3380. 

  3380. 				$this->pdf->Ln();
    3381. 

  3381. 					if($this->currentband=='detail'){
    3382. 

  3382. 					if($this->maxpagey['page_'.($this->pdf->getPage()-1)]=='')
    3383. 

  3383. 						$this->maxpagey['page_'.($this->pdf->getPage()-1)]=$this->pdf->GetY();
    3384. 

  3384. 					else{
    3385. 

  3385. 						if($this->maxpagey['page_'.($this->pdf->getPage()-1)]<$this->pdf->GetY())
    3386. 

  3386. 							$this->maxpagey['page_'.($this->pdf->getPage()-1)]=$this->pdf->GetY();
    3387. 

  3387. 					}
    3388. 

  3388. 				}
    3389. 

  3389.             
    3390. 

  3390.             }
    3391. 

  3391.             elseif($arraydata["poverflow"]=="false"&&$arraydata["soverflow"]=="false") {
    3392. 

  3392.                 while($this->pdf->GetStringWidth($txt) > $arraydata["width"]) {
    3393. 

  3393.                     $txt=substr_replace($txt,"",-1);
    3394. 

  3394.                 }
    3395. 

  3395.                 $this->pdf->Cell($arraydata["width"], $arraydata["height"],$this->formatText($txt, $arraydata["pattern"]),
    3396. 

  3396. 						$arraydata["border"],"",$arraydata["align"],$arraydata["fill"],$arraydata["link"]);
    3397. 

  3397. 				$this->pdf->Ln();
    3398. 

  3398. 					if($this->currentband=='detail'){
    3399. 

  3399. 					if($this->maxpagey['page_'.($this->pdf->getPage()-1)]=='')
    3400. 

  3400. 						$this->maxpagey['page_'.($this->pdf->getPage()-1)]=$this->pdf->GetY();
    3401. 

  3401. 					else{
    3402. 

  3402. 						if($this->maxpagey['page_'.($this->pdf->getPage()-1)]<$this->pdf->GetY())
    3403. 

  3403. 							$this->maxpagey['page_'.($this->pdf->getPage()-1)]=$this->pdf->GetY();
    3404. 

  3404. 					}
    3405. 

  3405. 				}
    3406. 

  3406. 		
    3407. 

  3407.             }
    3408. 

  3408.             elseif($arraydata["poverflow"]=="false"&&$arraydata["soverflow"]=="true") {
    3409. 

  3409. 				
    3410. 

  3410. 				$x=$this->pdf->GetX();
    3411. 

  3411. 		        $this->pdf->MultiCell($arraydata["width"], $arraydata["height"], $this->formatText($txt, $arraydata["pattern"]), $arraydata["border"] 
    3412. 

  3412.        							,$arraydata["align"], $arraydata["fill"],1,'','',true,0,false,true,$maxheight);
    3413. 

  3413. 		
    3414. 

  3414. 				if( $this->pdf->balancetext=='' && $this->currentband=='detail'){
    3415. 

  3415. 					if($this->maxpagey['page_'.($this->pdf->getPage()-1)]=='')
    3416. 

  3416. 						$this->maxpagey['page_'.($this->pdf->getPage()-1)]=$this->pdf->GetY();
    3417. 

  3417. 					else{
    3418. 

  3418. 						if($this->maxpagey['page_'.($this->pdf->getPage()-1)]<$this->pdf->GetY())
    3419. 

  3419. 							$this->maxpagey['page_'.($this->pdf->getPage()-1)]=$this->pdf->GetY();
    3420. 

  3420. 					}
    3421. 

  3421. 				}
    3422. 

  3422. 				
    3423. 

  3423. 			//$this->pageFooter();
    3424. 

  3424.             if($this->pdf->balancetext!='' ){
    3425. 

  3425. 				$this->continuenextpageText=array('width'=>$arraydata["width"], 'height'=>$arraydata["height"], 'txt'=>$this->pdf->balancetext,
    3426. 

  3426. 						'border'=>$arraydata["border"] ,'align'=>$arraydata["align"], 'fill'=>$arraydata["fill"],'ln'=>1,
    3427. 

  3427. 							'x'=>$x,'y'=>'','reset'=>true,'streth'=>0,'ishtml'=>false,'autopadding'=>true);
    3428. 

  3428. 					$this->pdf->balancetext='';
    3429. 

  3429. 					$this->forcetextcolor_b=$this->textcolor_b;
    3430. 

  3430. 					$this->forcetextcolor_g=$this->textcolor_g;
    3431. 

  3431. 					$this->forcetextcolor_r=$this->textcolor_r;
    3432. 

  3432. 					$this->forcefillcolor_b=$this->fillcolor_b;
    3433. 

  3433. 					$this->forcefillcolor_g=$this->fillcolor_g;
    3434. 

  3434. 					$this->forcefillcolor_r=$this->fillcolor_r;
    3435. 

  3435. 					if($this->continuenextpageText)
    3436. 

  3436. 						$this->printlongtext($this->pdf->getFontFamily(),$this->pdf->getFontStyle(),$this->pdf->getFontSize());
    3437. 

  3437. 					
    3438. 

  3438. 					}          
    3439. 

  3439. 				
    3440. 

  3440. 					
    3441. 

  3441.          
    3442. 

  3442. 

  3443.             }
    3444. 

  3444.             else {
    3445. 

  3445. 				//MultiCell($w, $h, $txt, $border=0, $align='J', $fill=0, $ln=1, $x='', $y='', $reseth=true, $stretch=0, $ishtml=false, $autopadding=true, $maxh=0) {	
    3446. 

  3446.                 $this->pdf->MultiCell($arraydata["width"], $arraydata["height"], $this->formatText($txt, $arraydata["pattern"]), $arraydata["border"], 
    3447. 

  3447. 							$arraydata["align"], $arraydata["fill"],1,'','',true,0,true,true,$maxheight);
    3448. 

  3448. 				if( $this->pdf->balancetext=='' && $this->currentband=='detail'){
    3449. 

  3449. 					if($this->maxpagey['page_'.($this->pdf->getPage()-1)]=='')
    3450. 

  3450. 						$this->maxpagey['page_'.($this->pdf->getPage()-1)]=$this->pdf->GetY();
    3451. 

  3451. 					else{
    3452. 

  3452. 						if($this->maxpagey['page_'.($this->pdf->getPage()-1)]<$this->pdf->GetY())
    3453. 

  3453. 							$this->maxpagey['page_'.($this->pdf->getPage()-1)]=$this->pdf->GetY();
    3454. 

  3454. 					}
    3455. 

  3455. 				}
    3456. 

  3456.             if($this->pdf->balancetext!=''){
    3457. 

  3457. 				$this->continuenextpageText=array('width'=>$arraydata["width"], 'height'=>$arraydata["height"], 'txt'=>$this->pdf->balancetext,
    3458. 

  3458. 						'border'=>$arraydata["border"] ,'align'=>$arraydata["align"], 'fill'=>$arraydata["fill"],'ln'=>1,
    3459. 

  3459. 							'x'=>$x,'y'=>'','reset'=>true,'streth'=>0,'ishtml'=>false,'autopadding'=>true);
    3460. 

  3460. 					$this->pdf->balancetext='';
    3461. 

  3461. 					$this->forcetextcolor_b=$this->textcolor_b;
    3462. 

  3462. 					$this->forcetextcolor_g=$this->textcolor_g;
    3463. 

  3463. 					$this->forcetextcolor_r=$this->textcolor_r;
    3464. 

  3464. 					$this->forcefillcolor_b=$this->fillcolor_b;
    3465. 

  3465. 					$this->forcefillcolor_g=$this->fillcolor_g;
    3466. 

  3466. 					$this->forcefillcolor_r=$this->fillcolor_r;
    3467. 

  3467. 					$this->gotTextOverPage=true;
    3468. 

  3468. 					if($this->continuenextpageText)
    3469. 

  3469. 						$this->printlongtext($this->pdf->getFontFamily(),$this->pdf->getFontStyle(),$this->pdf->getFontSize());
    3470. 

  3470. 					
    3471. 

  3471. 					}          
    3472. 

  3472. 

  3473. 

  3474. 

  3475.             }
    3476. 

  3476.         }
    3477. 

  3477.         $this->print_expression_result=false;
    3478. 

  3478.         
    3479. 

  3479. 

  3480. 

  3481.     }
    3482. 

  3482. 

  3483.     public function hex_code_color($value) {
    3484. 

  3484.         $r=hexdec(substr($value,1,2));
    3485. 

  3485.         $g=hexdec(substr($value,3,2));
    3486. 

  3486.         $b=hexdec(substr($value,5,2));
    3487. 

  3487.         return array("r"=>$r,"g"=>$g,"b"=>$b);
    3488. 

  3488.     }
    3489. 

  3489. 

  3490.     public function get_first_value($value) {
    3491. 

  3491.         return (substr($value,0,1));
    3492. 

  3492.     }
    3493. 

  3493. 

  3494.     function right($value, $count) {
    3495. 

  3495. 

  3496.         return substr($value, ($count*-1));
    3497. 

  3497. 

  3498.     }
    3499. 

  3499. 

  3500.     function left($string, $count) {
    3501. 

  3501.         return substr($string, 0, $count);
    3502. 

  3502.     }
    3503. 

  3503. 

  3504.     public function analyse_expression($data,$isPrintRepeatedValue="true") {
    3505. 

  3505.         $arrdata=explode("+",$data);
    3506. 

  3506. 

  3507.         $i=0;
    3508. 

  3508.         
    3509. 

  3509.         foreach($arrdata as $num=>$out) {
    3510. 

  3510.             $i++;
    3511. 

  3511.             $arrdata[$num]=str_replace('"',"",$out);
    3512. 

  3512.             $this->arraysqltable[$this->global_pointer][substr($out,3,-1)];
    3513. 

  3513. 

  3514.             if(substr($out,0,3)=='$F{') {
    3515. 

  3515.                 
    3516. 

  3516.                 if($isPrintRepeatedValue=="true" ||$isPrintRepeatedValue=="") {
    3517. 

  3517.                     $arrdata[$num]=$this->arraysqltable[$this->global_pointer][substr($out,3,-1)];
    3518. 

  3518.                     
    3519. 

  3519.                 }
    3520. 

  3520.                 else {
    3521. 

  3521. 

  3522.                     if($this->previousarraydata[$arrdata[$num]]==$this->arraysqltable[$this->global_pointer][substr($out,3,-1)]) {
    3523. 

  3523. 

  3524.                         $arrdata[$num]="";
    3525. 

  3525.                     }
    3526. 

  3526.                     else {
    3527. 

  3527.                         $arrdata[$num]=$this->arraysqltable[$this->global_pointer][substr($out,3,-1)];
    3528. 

  3528.                         $this->previousarraydata[$out]=$this->arraysqltable[$this->global_pointer][substr($out,3,-1)];
    3529. 

  3529.                     }
    3530. 

  3530.                 }
    3531. 

  3531.               //  echo $arrdata[$num]."==";
    3532. 

  3532.             }
    3533. 

  3533.             elseif(substr($out,0,3)=='$V{') {
    3534. 

  3534. //###	A new function to handle iReport's "+-/*" expressions.
    3535. 

  3535. // It works like a cheap calculator, without precedences, so 1+2*3 will be 9, NOT 7.
    3536. 

  3536. 			
    3537. 

  3537. 				$p1=3;
    3538. 

  3538. 				$p2=strpos($out,"}");
    3539. 

  3539. 				if ($p2!==false){ 
    3540. 

  3540. 					$total=&$this->arrayVariable[substr($out,$p1,$p2-$p1)]["ans"];
    3541. 

  3541. 					$p1=$p2+1;
    3542. 

  3542. 					while ($p1<strlen($out)){
    3543. 

  3543. 						if (strpos("+-/*",substr($out,$p1,1))!==false) $opr=substr($out,$p1,1);
    3544. 

  3544. 						else $opr="";
    3545. 

  3545. 						$p1=strpos($out,'$V{',$p1)+3;
    3546. 

  3546. 						$p2=strpos($out,"}",$p1);
    3547. 

  3547. 						if ($p2!==false){ $nbr=&$this->arrayVariable[substr($out,$p1,$p2-$p1)]["ans"];
    3548. 

  3548. 							switch ($opr){
    3549. 

  3549. 								case "+": $total+=$nbr;
    3550. 

  3550. 										  break;
    3551. 

  3551. 								case "-": $total-=$nbr;
    3552. 

  3552. 										  break;
    3553. 

  3553. 								case "*": $total*=$nbr;
    3554. 

  3554. 										  break;
    3555. 

  3555. 								case "/": $total/=$nbr;
    3556. 

  3556. 										  break;
    3557. 

  3557. 							}
    3558. 

  3558. 						}
    3559. 

  3559. 						$p1=$p2+1;
    3560. 

  3560. 					}
    3561. 

  3561. 				}
    3562. 

  3562. 				$arrdata[$num]=$total;
    3563. 

  3563. //### End of modifications, below is the original line.				
    3564. 

  3564. //                $arrdata[$num]=&$this->arrayVariable[substr($out,3,-1)]["ans"];
    3565. 

  3565.             }
    3566. 

  3566.             elseif(substr($out,0,3)=='$P{') {
    3567. 

  3567.                 $arrdata[$num]=$this->arrayParameter[substr($out,3,-1)];
    3568. 

  3568.             }
    3569. 

  3569.           //  echo "<br/>";
    3570. 

  3570.         }
    3571. 

  3571. 

  3572.         if($this->left($data,3)=='"("' && $this->right($data,3)=='")"') {
    3573. 

  3573.             $total=0;
    3574. 

  3574. 

  3575.             foreach($arrdata as $num=>$out) {
    3576. 

  3576.                 if($num>0 && $num<$i)
    3577. 

  3577.                     $total+=$out;
    3578. 

  3578. 

  3579.             }
    3580. 

  3580.             return $total;
    3581. 

  3581. 

  3582.         }
    3583. 

  3583.         else {
    3584. 

  3584. 

  3585.             return implode($arrdata);
    3586. 

  3586.         }
    3587. 

  3587.     }
    3588. 

  3588. 

  3589.     public function formatText($txt,$pattern) {
    3590. 

  3590.         if($pattern=="###0")
    3591. 

  3591.             return number_format($txt,0,"","");
    3592. 

  3592.         elseif($pattern=="#,##0")
    3593. 

  3593.             return number_format($txt,0,".",",");
    3594. 

  3594.         elseif($pattern=="###0.0")
    3595. 

  3595.             return number_format($txt,1,".","");
    3596. 

  3596.         elseif($pattern=="#,##0.0")
    3597. 

  3597.             return number_format($txt,1,".",",");
    3598. 

  3598.         elseif($pattern=="###0.00")
    3599. 

  3599.             return number_format($txt,2,".","");
    3600. 

  3600.         elseif($pattern=="#,##0.00")
    3601. 

  3601.             return number_format($txt,2,".",",");
    3602. 

  3602.         elseif($pattern=="###0.000")
    3603. 

  3603.             return number_format($txt,3,".","");
    3604. 

  3604.         elseif($pattern=="#,##0.000")
    3605. 

  3605.             return number_format($txt,3,".",",");
    3606. 

  3606.         elseif($pattern=="#,##0.0000")
    3607. 

  3607.             return number_format($txt,4,".",",");
    3608. 

  3608.         elseif($pattern=="###0.0000")
    3609. 

  3609.             return number_format($txt,4,".","");
    3610. 

  3610.         elseif($pattern=="dd/MM/yyyy" && $txt !="")
    3611. 

  3611.             return date("d/m/Y",strtotime($txt));
    3612. 

  3612.         elseif($pattern=="MM/dd/yyyy" && $txt !="")
    3613. 

  3613.             return date("m/d/Y",strtotime($txt));
    3614. 

  3614.         elseif($pattern=="yyyy/MM/dd" && $txt !="")
    3615. 

  3615.             return date("Y/m/d",strtotime($txt));
    3616. 

  3616.         elseif($pattern=="dd-MMM-yy" && $txt !="")
    3617. 

  3617.             return date("d-M-Y",strtotime($txt));
    3618. 

  3618.         elseif($pattern=="dd-MMM-yy" && $txt !="")
    3619. 

  3619.             return date("d-M-Y",strtotime($txt));
    3620. 

  3620.         elseif($pattern=="dd/MM/yyyy h.mm a" && $txt !="")
    3621. 

  3621.             return date("d/m/Y h:i a",strtotime($txt));
    3622. 

  3622.         elseif($pattern=="dd/MM/yyyy HH.mm.ss" && $txt !="")
    3623. 

  3623.             return date("d-m-Y H:i:s",strtotime($txt));
    3624. 

  3624.         else
    3625. 

  3625.             return $txt;
    3626. 

  3626. 

  3627. 

  3628.     }
    3629. 

  3629. 

  3630.     public function print_expression($data) {
    3631. 

  3631.         $expression=$data["printWhenExpression"];
    3632. 

  3632.         $expression=str_replace('$F{','$this->arraysqltable[$this->global_pointer][',$expression);
    3633. 

  3633.         $expression=str_replace('$P{','$this->arraysqltable[$this->global_pointer][',$expression);
    3634. 

  3634.         $expression=str_replace('$V{','$this->arraysqltable[$this->global_pointer][',$expression);
    3635. 

  3635.         $expression=str_replace('}',']',$expression);
    3636. 

  3636.         $this->print_expression_result=false;
    3637. 

  3637.         if($expression!="") {
    3638. 

  3638.             eval('if('.$expression.'){$this->print_expression_result=true;}');
    3639. 

  3639.         }
    3640. 

  3640.         elseif($expression=="") {
    3641. 

  3641.             $this->print_expression_result=true;
    3642. 

  3642.         }
    3643. 

  3643. 

  3644.     }
    3645. 

  3645. 

  3646.     public function runSubReport($d,$current_y) {
    3647. 

  3647.             $this->insubReport=1;
    3648. 

  3648.         foreach($d["subreportparameterarray"] as $name=>$b) {
    3649. 

  3649.             $t = $b->subreportParameterExpression;
    3650. 

  3650.             $arrdata=explode("+",$t);
    3651. 

  3651.             $i=0;
    3652. 

  3652.             foreach($arrdata as $num=>$out) {
    3653. 

  3653.                 $i++;
    3654. 

  3654. //                $arrdata[$num]=str_replace('"',"",$out);
    3655. 

  3655.                 if(substr($b,0,3)=='$F{') {
    3656. 

  3656.                     $arrdata2[$name.'']=$this->arraysqltable[$this->global_pointer][substr($b,3,-1)];
    3657. 

  3657.                 }
    3658. 

  3658.                 elseif(substr($b,0,3)=='$V{') {
    3659. 

  3659.                     $arrdata2[$name.'']=&$this->arrayVariable[substr($b,3,-1)]["ans"];
    3660. 

  3660.                 }
    3661. 

  3661.                 elseif(substr($b,0,3)=='$P{') {
    3662. 

  3662.                     $arrdata2[$name.'']=$this->arrayParameter[substr($b,3,-1)];
    3663. 

  3663.                 }
    3664. 

  3664.             }
    3665. 

  3665.             $t=implode($arrdata);
    3666. 

  3666.         }
    3667. 

  3667.    /*         if($this->currentband=='pageHeader'){
    3668. 

  3668.                 $this->includeSubReport($d,$arrdata2,$current_y);
    3669. 

  3669.             }
    3670. 

  3670.             if($this->currentband=='pageFooter'){
    3671. 

  3671.                 $this->includeSubReport($d,$arrdata2,$current_y);
    3672. 

  3672.             }
    3673. 

  3673.             if($this->currentband=='lastPageFooter'){
    3674. 

  3674.                 $this->includeSubReport($d,$arrdata2,$current_y);
    3675. 

  3675.             }
    3676. 

  3676.             if($this->currentband=='groupHeader'){
    3677. 

  3677.                 $this->includeSubReport($d,$arrdata2,$current_y);
    3678. 

  3678.             }
    3679. 

  3679.             if($this->currentband=='groupFooter'){
    3680. 

  3680.                 $this->includeSubReport($d,$arrdata2,$current_y);
    3681. 

  3681.             }
    3682. 

  3682.             if($this->currentband=='summary'){
    3683. 

  3683.                 $this->includeSubReport($d,$arrdata2,$current_y);
    3684. 

  3684.             }
    3685. 

  3685.             if($this->currentband=='detail'){
    3686. 

  3686.                 $this->includeSubReport($d,$arrdata2,$current_y);
    3687. 

  3687.             }
    3688. 

  3688.        */
    3689. 

  3689.               $this->includeSubReport($d,$arrdata2,$current_y);
    3690. 

  3690.         $this->insubReport=0;
    3691. 

  3691.     }
    3692. 

  3692.     
    3693. 

  3693.     public function transferXMLtoArray($fileName) {
    3694. 

  3694.         if(!file_exists($fileName))
    3695. 

  3695.             echo "File - $fileName does not exist";
    3696. 

  3696.         else {
    3697. 

  3697. 

  3698.             $xmlAry = $this->xmlobj2arr(simplexml_load_file($fileName));
    3699. 

  3699. 			
    3700. 

  3700.             foreach($xmlAry[header] as $key => $value)
    3701. 

  3701.                 $this->arraysqltable["$this->m"]["$key"]=$value;
    3702. 

  3702. 

  3703.             foreach($xmlAry[detail][record]["$this->m"] as $key2 => $value2)
    3704. 

  3704.                 $this->arraysqltable["$this->m"]["$key2"]=$value2;
    3705. 

  3705.         }
    3706. 

  3706. 

  3707.       //  if(isset($this->arrayVariable))	//if self define variable existing, go to do the calculation
    3708. 

  3708.        //     $this->variable_calculation();
    3709. 

  3709. 

  3710.     }
    3711. 

  3711. 

  3712.     public function includeSubReport($d,$arrdata,$current_y){ 
    3713. 

  3713.                include_once ("PHPJasperXMLSubReport.inc.php");
    3714. 

  3714.                $srxml=  simplexml_load_file($d['subreportExpression']);
    3715. 

  3715.                $PHPJasperXMLSubReport= new PHPJasperXMLSubReport($this->lang,$this->pdflib,$d['x']);
    3716. 

  3716.                $PHPJasperXMLSubReport->arrayParameter=$arrdata;
    3717. 

  3717.                $PHPJasperXMLSubReport->debugsql=$this->debugsql;
    3718. 

  3718.                $PHPJasperXMLSubReport->xml_dismantle($srxml);
    3719. 

  3719.                $this->passAllArrayDatatoSubReport($PHPJasperXMLSubReport,$d,$current_y);
    3720. 

  3720.                $PHPJasperXMLSubReport->transferDBtoArray($this->db_host,$this->db_user,$this->db_pass,$this->db_or_dsn_name);
    3721. 

  3721.                $PHPJasperXMLSubReport->pdf=$this->pdf;
    3722. 

  3722.                $PHPJasperXMLSubReport->outpage();    //page output method I:standard output  D:Download file
    3723. 

  3723.   
    3724. 

  3724.                $this->SubReportCheckPoint=$PHPJasperXMLSubReport->SubReportCheckPoint;
    3725. 

  3725.                $PHPJasperXMLSubReport->MainPageCurrentY=0;
    3726. 

  3726.     }
    3727. 

  3727. 

  3728.     public function passAllArrayDatatoSubReport($PHPJasperXMLSubReport,$d,$current_y){
    3729. 

  3729.         
    3730. 

  3730.                 $PHPJasperXMLSubReport->arrayMainPageSetting=$this->arrayPageSetting;
    3731. 

  3731.                 if(isset($this->arraypageHeader)) {
    3732. 

  3732.                 $PHPJasperXMLSubReport->arrayPageSetting["subreportpageHeight"]=$PHPJasperXMLSubReport->arrayPageSetting["pageHeight"];
    3733. 

  3733.                 $PHPJasperXMLSubReport->arrayMainpageHeader=$this->arraypageHeader;
    3734. 

  3734.                 $PHPJasperXMLSubReport->arrayMainpageFooter=$this->arraypageFooter;
    3735. 

  3735. 

  3736.                     if($this->currentband=='pageHeader'){ ///here need to add more conditions to fulfill different band subreport
    3737. 

  3737.                         $PHPJasperXMLSubReport->TopHeightFromMainPage=$PHPJasperXMLSubReport->arrayMainPageSetting["topMargin"]+$d['y'];
    3738. 

  3738.                     }
    3739. 

  3739.                     else{      
    3740. 

  3740.                         $PHPJasperXMLSubReport->TopHeightFromMainPage=$PHPJasperXMLSubReport->arrayMainPageSetting["topMargin"]
    3741. 

  3741.                                                                                                 +$PHPJasperXMLSubReport->arrayMainpageHeader[0]["height"]+$d['y'];
    3742. 

  3742.                     }
    3743. 

  3743. ###set different initial Y for subreport of each detail loop of main report
    3744. 

  3744.                 if($current_y>$PHPJasperXMLSubReport->TopHeightFromMainPage){$PHPJasperXMLSubReport->TopHeightFromMainPage=$current_y+$d['y'];}
    3745. 

  3745. ###
    3746. 

  3746.                 $PHPJasperXMLSubReport->BottomHeightFromMainPage=$PHPJasperXMLSubReport->arrayMainPageSetting["bottomMargin"]
    3747. 

  3747.                                                                                                 +$PHPJasperXMLSubReport->arrayMainpageFooter[0]["height"];
    3748. 

  3748.                 $PHPJasperXMLSubReport->arrayPageSetting["leftMargin"]=$PHPJasperXMLSubReport->arrayPageSetting["leftMargin"]+$this->arrayPageSetting["leftMargin"];
    3749. 

  3749. ###Set fixed pageHeight constant despite the changes of $PHPJasperXMLSubReport->TopHeightFromMainPage due to subreport in Detail band
    3750. 

  3750.                 $PHPJasperXMLSubReport->arrayPageSetting["pageHeight"]=$this->arrayPageSetting["pageHeight"]
    3751. 

  3751.                                                                                                                     -($PHPJasperXMLSubReport->arrayMainPageSetting["topMargin"]
    3752. 

  3752.                                                                                                 +$PHPJasperXMLSubReport->arrayMainpageHeader[0]["height"]+$d['y'])
    3753. 

  3753.                                                                                                                     -$this->arraypageFooter[0]["height"]
    3754. 

  3754.                                                                                                                     -$PHPJasperXMLSubReport->arrayMainPageSetting["bottomMargin"]-$d['y'];
    3755. 

  3755. ###
    3756. 

  3756. //                $PHPJasperXMLSubReport->arrayPageSetting["pageHeight"]=$this->arrayPageSetting["pageHeight"]
    3757. 

  3757. //                                                                                                                    -$PHPJasperXMLSubReport->TopHeightFromMainPage
    3758. 

  3758. //                                                                                                                    -$this->arraypageFooter[0]["height"]
    3759. 

  3759. //                                                                                                                    -$PHPJasperXMLSubReport->arrayMainPageSetting["bottomMargin"]-$d['y'];
    3760. 

  3760. //                    $PHPJasperXMLSubReport->arrayPageSetting['topMargin']=$PHPJasperXMLSubReport->arrayPageSetting['topMargin']
    3761. 

  3761. //                                                                                                                    +$PHPJasperXMLSubReport->arrayMainPageSetting["topMargin"]
    3762. 

  3762. //                                                                                                                    +$PHPJasperXMLSubReport->arrayMainpageHeader[0]["height"];
    3763. 

  3763. 

  3764. //                    elseif($this->currentband=='detail'){
    3765. 

  3765. ////                        $PHPJasperXMLSubReport->MainPageCurrentY=$current_y;
    3766. 

  3766. //                    }
    3767. 

  3767.                 }
    3768. 

  3768.                 if(isset($this->arraypageFooter)) {
    3769. 

  3769.                     $PHPJasperXMLSubReport->arrayMainpageFooter=$this->arraypageFooter;
    3770. 

  3770.                 }
    3771. 

  3771.                 if(isset($this->arraygroup)) {
    3772. 

  3772.                     $PHPJasperXMLSubReport->arrayMaingroup=$this->arraygroup;
    3773. 

  3773.                 }
    3774. 

  3774.                 if(isset($this->arraylastPageFooter)) {
    3775. 

  3775.                     $PHPJasperXMLSubReport->arrayMainlastPageFooter=$this->arraylastPageFooter;
    3776. 

  3776.                 }
    3777. 

  3777.                 if(isset($this->arraytitle)) {
    3778. 

  3778.                     $PHPJasperXMLSubReport->arrayMaintitle=$this->arraytitle;
    3779. 

  3779.                 }
    3780. 

  3780. 

  3781.     }
    3782. 

  3782. //wrote by huzursuz at mailinator dot com on 02-Feb-2009 04:44
    3783. 

  3783. //http://hk.php.net/manual/en/function.get-object-vars.php
    3784. 

  3784.     public function xmlobj2arr($Data) {
    3785. 

  3785.         if (is_object($Data)) {
    3786. 

  3786.             foreach (get_object_vars($Data) as $key => $val)
    3787. 

  3787.                 $ret[$key] = $this->xmlobj2arr($val);
    3788. 

  3788.             return $ret;
    3789. 

  3789.         }
    3790. 

  3790.         elseif (is_array($Data)) {
    3791. 

  3791.             foreach ($Data as $key => $val)
    3792. 

  3792.                 $ret[$key] = $this->xmlobj2arr($val);
    3793. 

  3793.             return $ret;
    3794. 

  3794.         }
    3795. 

  3795.         else
    3796. 

  3796.             return $Data;
    3797. 

  3797.     }
    3798. 

  3798. 

  3799. 

  3800. private function Rotate($type, $x=-1, $y=-1)
    3801. 

  3801. {
    3802. 

  3802.     if($type=="")
    3803. 

  3803.     $angle=0;
    3804. 

  3804.     elseif($type=="Left")
    3805. 

  3805.     $angle=90;
    3806. 

  3806.     elseif($type=="Right")
    3807. 

  3807.     $angle=270;
    3808. 

  3808.     elseif($type=="UpsideDown")
    3809. 

  3809.     $angle=180;
    3810. 

  3810. 

  3811.     if($x==-1)
    3812. 

  3812.         $x=$this->pdf->getX();
    3813. 

  3813.     if($y==-1)
    3814. 

  3814.         $y=$this->pdf->getY();
    3815. 

  3815.     if($this->angle!=0)
    3816. 

  3816.         $this->pdf->_out('Q');
    3817. 

  3817.     $this->angle=$angle;
    3818. 

  3818.     if($angle!=0)
    3819. 

  3819.     {
    3820. 

  3820.         $angle*=M_PI/180;
    3821. 

  3821.         $c=cos($angle);
    3822. 

  3822.         $s=sin($angle);
    3823. 

  3823.         $cx=$x*$this->pdf->k;
    3824. 

  3824.         $cy=($this->pdf->h-$y)*$this->pdf->k;
    3825. 

  3825.         $this->pdf->_out(sprintf('q %.5f %.5f %.5f %.5f %.2f %.2f cm 1 0 0 1 %.2f %.2f cm', $c, $s, -$s, $c, $cx, $cy, -$cx, -$cy));
    3826. 

  3826.     }
    3827. 

  3827. }
    3828. 

  3828. 

  3829. }
    3830. 

  3830.