| [ Index ] |
PHP Cross Reference of vtigercrm-6.1.0 |
[Summary view] [Print] [Text view]
1 <?php 2 /*+******************************************************************************** 3 * The contents of this file are subject to the vtiger CRM Public License Version 1.0 4 * ("License"); You may not use this file except in compliance with the License 5 * The Original Code is: vtiger CRM Open Source 6 * The Initial Developer of the Original Code is vtiger. 7 * Portions created by vtiger are Copyright (C) vtiger. 8 * All Rights Reserved. 9 ********************************************************************************/ 10 require_once ('include/database/PearDatabase.php'); 11 //require_once('modules/Reports/CannedReports.php'); 12 global $adb; 13 14 $rptfolder = Array(Array('Account and Contact Reports'=>'Account and Contact Reports'), 15 Array('Lead Reports'=>'Lead Reports'), 16 Array('Potential Reports'=>'Potential Reports'), 17 Array('Activity Reports'=>'Activity Reports'), 18 Array('HelpDesk Reports'=>'HelpDesk Reports'), 19 Array('Product Reports'=>'Product Reports'), 20 Array('Quote Reports' =>'Quote Reports'), 21 Array('PurchaseOrder Reports'=>'PurchaseOrder Reports'), 22 Array('Invoice Reports'=>'Invoice Reports'), 23 Array('SalesOrder Reports'=>'SalesOrder Reports'), 24 Array('Campaign Reports'=>'Campaign Reports') 25 ); 26 27 $reportmodules = Array(Array('primarymodule'=>'Contacts','secondarymodule'=>'Accounts'), 28 Array('primarymodule'=>'Contacts','secondarymodule'=>'Accounts'), 29 Array('primarymodule'=>'Contacts','secondarymodule'=>'Potentials'), 30 Array('primarymodule'=>'Leads','secondarymodule'=>''), 31 Array('primarymodule'=>'Leads','secondarymodule'=>''), 32 Array('primarymodule'=>'Potentials','secondarymodule'=>''), 33 Array('primarymodule'=>'Potentials','secondarymodule'=>''), 34 Array('primarymodule'=>'Calendar','secondarymodule'=>''), 35 Array('primarymodule'=>'Calendar','secondarymodule'=>''), 36 Array('primarymodule'=>'HelpDesk','secondarymodule'=>'Products'), 37 Array('primarymodule'=>'HelpDesk','secondarymodule'=>''), 38 Array('primarymodule'=>'HelpDesk','secondarymodule'=>''), 39 Array('primarymodule'=>'Products','secondarymodule'=>''), 40 Array('primarymodule'=>'Products','secondarymodule'=>'Contacts'), 41 Array('primarymodule'=>'Quotes','secondarymodule'=>''), 42 Array('primarymodule'=>'Quotes','secondarymodule'=>''), 43 Array('primarymodule'=>'PurchaseOrder','secondarymodule'=>'Contacts'), 44 Array('primarymodule'=>'PurchaseOrder','secondarymodule'=>''), 45 Array('primarymodule'=>'Invoice','secondarymodule'=>''), 46 Array('primarymodule'=>'SalesOrder','secondarymodule'=>''), 47 Array('primarymodule'=>'Campaigns','secondarymodule'=>'') 48 ); 49 50 $selectcolumns = Array(Array('vtiger_contactdetails:firstname:Contacts_First_Name:firstname:V', 51 'vtiger_contactdetails:lastname:Contacts_Last_Name:lastname:V', 52 'vtiger_contactsubdetails:leadsource:Contacts_Lead_Source:leadsource:V', 53 'vtiger_contactdetails:accountid:Contacts_Account_Name:account_id:V', 54 'vtiger_account:industry:Accounts_industry:industry:V', 55 'vtiger_contactdetails:email:Contacts_Email:email:E'), 56 57 Array('vtiger_contactdetails:firstname:Contacts_First_Name:firstname:V', 58 'vtiger_contactdetails:lastname:Contacts_Last_Name:lastname:V', 59 'vtiger_contactsubdetails:leadsource:Contacts_Lead_Source:leadsource:V', 60 'vtiger_contactdetails:accountid:Contacts_Account_Name:account_id:V', 61 'vtiger_account:industry:Accounts_industry:industry:V', 62 'vtiger_contactdetails:email:Contacts_Email:email:E'), 63 64 Array('vtiger_contactdetails:firstname:Contacts_First_Name:firstname:V', 65 'vtiger_contactdetails:lastname:Contacts_Last_Name:lastname:V', 66 'vtiger_contactdetails:accountid:Contacts_Account_Name:account_id:V', 67 'vtiger_contactdetails:email:Contacts_Email:email:E', 68 'vtiger_potential:potentialname:Potentials_Potential_Name:potentialname:V', 69 'vtiger_potential:sales_stage:Potentials_Sales_Stage:sales_stage:V'), 70 71 Array('vtiger_leaddetails:firstname:Leads_First_Name:firstname:V', 72 'vtiger_leaddetails:lastname:Leads_Last_Name:lastname:V', 73 'vtiger_leaddetails:company:Leads_Company:company:V', 74 'vtiger_leaddetails:email:Leads_Email:email:E', 75 'vtiger_leaddetails:leadsource:Leads_Lead_Source:leadsource:V'), 76 77 Array('vtiger_leaddetails:firstname:Leads_First_Name:firstname:V', 78 'vtiger_leaddetails:lastname:Leads_Last_Name:lastname:V', 79 'vtiger_leaddetails:company:Leads_Company:company:V', 80 'vtiger_leaddetails:email:Leads_Email:email:E', 81 'vtiger_leaddetails:leadsource:Leads_Lead_Source:leadsource:V', 82 'vtiger_leaddetails:leadstatus:Leads_Lead_Status:leadstatus:V'), 83 84 Array('vtiger_potential:potentialname:Potentials_Potential_Name:potentialname:V', 85 'vtiger_potential:amount:Potentials_Amount:amount:N', 86 'vtiger_potential:potentialtype:Potentials_Type:opportunity_type:V', 87 'vtiger_potential:leadsource:Potentials_Lead_Source:leadsource:V', 88 'vtiger_potential:sales_stage:Potentials_Sales_Stage:sales_stage:V'), 89 90 Array('vtiger_potential:potentialname:Potentials_Potential_Name:potentialname:V', 91 'vtiger_potential:amount:Potentials_Amount:amount:N', 92 'vtiger_potential:potentialtype:Potentials_Type:opportunity_type:V', 93 'vtiger_potential:leadsource:Potentials_Lead_Source:leadsource:V', 94 'vtiger_potential:sales_stage:Potentials_Sales_Stage:sales_stage:V'), 95 96 Array('vtiger_activity:subject:Calendar_Subject:subject:V', 97 'vtiger_contactdetailsCalendar:lastname:Calendar_Contact_Name:contact_id:I', 98 'vtiger_activity:status:Calendar_Status:taskstatus:V', 99 'vtiger_activity:priority:Calendar_Priority:taskpriority:V', 100 'vtiger_usersCalendar:user_name:Calendar_Assigned_To:assigned_user_id:V'), 101 102 Array('vtiger_activity:subject:Calendar_Subject:subject:V', 103 'vtiger_contactdetailsCalendar:lastname:Calendar_Contact_Name:contact_id:I', 104 'vtiger_activity:status:Calendar_Status:taskstatus:V', 105 'vtiger_activity:priority:Calendar_Priority:taskpriority:V', 106 'vtiger_usersCalendar:user_name:Calendar_Assigned_To:assigned_user_id:V'), 107 108 Array('vtiger_troubletickets:title:HelpDesk_Title:ticket_title:V', 109 'vtiger_troubletickets:status:HelpDesk_Status:ticketstatus:V', 110 'vtiger_products:productname:Products_Product_Name:productname:V', 111 'vtiger_products:discontinued:Products_Product_Active:discontinued:V', 112 'vtiger_products:productcategory:Products_Product_Category:productcategory:V', 113 'vtiger_products:manufacturer:Products_Manufacturer:manufacturer:V'), 114 115 Array('vtiger_troubletickets:title:HelpDesk_Title:ticket_title:V', 116 'vtiger_troubletickets:priority:HelpDesk_Priority:ticketpriorities:V', 117 'vtiger_troubletickets:severity:HelpDesk_Severity:ticketseverities:V', 118 'vtiger_troubletickets:status:HelpDesk_Status:ticketstatus:V', 119 'vtiger_troubletickets:category:HelpDesk_Category:ticketcategories:V', 120 'vtiger_usersHelpDesk:user_name:HelpDesk_Assigned_To:assigned_user_id:V'), 121 122 Array('vtiger_troubletickets:title:HelpDesk_Title:ticket_title:V', 123 'vtiger_troubletickets:priority:HelpDesk_Priority:ticketpriorities:V', 124 'vtiger_troubletickets:severity:HelpDesk_Severity:ticketseverities:V', 125 'vtiger_troubletickets:status:HelpDesk_Status:ticketstatus:V', 126 'vtiger_troubletickets:category:HelpDesk_Category:ticketcategories:V', 127 'vtiger_usersHelpDesk:user_name:HelpDesk_Assigned_To:assigned_user_id:V'), 128 129 Array('vtiger_products:productname:Products_Product_Name:productname:V', 130 'vtiger_products:productcode:Products_Product_Code:productcode:V', 131 'vtiger_products:discontinued:Products_Product_Active:discontinued:V', 132 'vtiger_products:productcategory:Products_Product_Category:productcategory:V', 133 'vtiger_products:website:Products_Website:website:V', 134 'vtiger_vendorRelProducts:vendorname:Products_Vendor_Name:vendor_id:I', 135 'vtiger_products:mfr_part_no:Products_Mfr_PartNo:mfr_part_no:V'), 136 137 Array('vtiger_products:productname:Products_Product_Name:productname:V', 138 'vtiger_products:manufacturer:Products_Manufacturer:manufacturer:V', 139 'vtiger_products:productcategory:Products_Product_Category:productcategory:V', 140 'vtiger_contactdetails:firstname:Contacts_First_Name:firstname:V', 141 'vtiger_contactdetails:lastname:Contacts_Last_Name:lastname:V', 142 'vtiger_contactsubdetails:leadsource:Contacts_Lead_Source:leadsource:V'), 143 144 Array('vtiger_quotes:subject:Quotes_Subject:subject:V', 145 'vtiger_potentialRelQuotes:potentialname:Quotes_Potential_Name:potential_id:I', 146 'vtiger_quotes:quotestage:Quotes_Quote_Stage:quotestage:V', 147 'vtiger_quotes:contactid:Quotes_Contact_Name:contact_id:V', 148 'vtiger_usersRel1:user_name:Quotes_Inventory_Manager:assigned_user_id1:I', 149 'vtiger_accountQuotes:accountname:Quotes_Account_Name:account_id:I'), 150 151 Array('vtiger_quotes:subject:Quotes_Subject:subject:V', 152 'vtiger_potentialRelQuotes:potentialname:Quotes_Potential_Name:potential_id:I', 153 'vtiger_quotes:quotestage:Quotes_Quote_Stage:quotestage:V', 154 'vtiger_quotes:contactid:Quotes_Contact_Name:contact_id:V', 155 'vtiger_usersRel1:user_name:Quotes_Inventory_Manager:assigned_user_id1:I', 156 'vtiger_accountQuotes:accountname:Quotes_Account_Name:account_id:I', 157 'vtiger_quotes:carrier:Quotes_Carrier:carrier:V', 158 'vtiger_quotes:shipping:Quotes_Shipping:shipping:V'), 159 160 Array('vtiger_purchaseorder:subject:PurchaseOrder_Subject:subject:V', 161 'vtiger_vendorRelPurchaseOrder:vendorname:PurchaseOrder_Vendor_Name:vendor_id:I', 162 'vtiger_purchaseorder:tracking_no:PurchaseOrder_Tracking_Number:tracking_no:V', 163 'vtiger_contactdetails:firstname:Contacts_First_Name:firstname:V', 164 'vtiger_contactdetails:lastname:Contacts_Last_Name:lastname:V', 165 'vtiger_contactsubdetails:leadsource:Contacts_Lead_Source:leadsource:V', 166 'vtiger_contactdetails:email:Contacts_Email:email:E'), 167 168 Array('vtiger_purchaseorder:subject:PurchaseOrder_Subject:subject:V', 169 'vtiger_vendorRelPurchaseOrder:vendorname:PurchaseOrder_Vendor_Name:vendor_id:I', 170 'vtiger_purchaseorder:requisition_no:PurchaseOrder_Requisition_No:requisition_no:V', 171 'vtiger_purchaseorder:tracking_no:PurchaseOrder_Tracking_Number:tracking_no:V', 172 'vtiger_contactdetailsPurchaseOrder:lastname:PurchaseOrder_Contact_Name:contact_id:I', 173 'vtiger_purchaseorder:carrier:PurchaseOrder_Carrier:carrier:V', 174 'vtiger_purchaseorder:salescommission:PurchaseOrder_Sales_Commission:salescommission:N', 175 'vtiger_purchaseorder:exciseduty:PurchaseOrder_Excise_Duty:exciseduty:N', 176 'vtiger_usersPurchaseOrder:user_name:PurchaseOrder_Assigned_To:assigned_user_id:V'), 177 178 Array('vtiger_invoice:subject:Invoice_Subject:subject:V', 179 'vtiger_invoice:salesorderid:Invoice_Sales_Order:salesorder_id:I', 180 'vtiger_invoice:customerno:Invoice_Customer_No:customerno:V', 181 'vtiger_invoice:exciseduty:Invoice_Excise_Duty:exciseduty:N', 182 'vtiger_invoice:salescommission:Invoice_Sales_Commission:salescommission:N', 183 'vtiger_accountInvoice:accountname:Invoice_Account_Name:account_id:I'), 184 185 Array('vtiger_salesorder:subject:SalesOrder_Subject:subject:V', 186 'vtiger_quotesSalesOrder:subject:SalesOrder_Quote_Name:quote_id:I', 187 'vtiger_contactdetailsSalesOrder:lastname:SalesOrder_Contact_Name:contact_id:I', 188 'vtiger_salesorder:duedate:SalesOrder_Due_Date:duedate:D', 189 'vtiger_salesorder:carrier:SalesOrder_Carrier:carrier:V', 190 'vtiger_salesorder:sostatus:SalesOrder_Status:sostatus:V', 191 'vtiger_accountSalesOrder:accountname:SalesOrder_Account_Name:account_id:I', 192 'vtiger_salesorder:salescommission:SalesOrder_Sales_Commission:salescommission:N', 193 'vtiger_salesorder:exciseduty:SalesOrder_Excise_Duty:exciseduty:N', 194 'vtiger_usersSalesOrder:user_name:SalesOrder_Assigned_To:assigned_user_id:V'), 195 196 Array('vtiger_campaign:campaignname:Campaigns_Campaign_Name:campaignname:V', 197 'vtiger_campaign:campaigntype:Campaigns_Campaign_Type:campaigntype:V', 198 'vtiger_campaign:targetaudience:Campaigns_Target_Audience:targetaudience:V', 199 'vtiger_campaign:budgetcost:Campaigns_Budget_Cost:budgetcost:I', 200 'vtiger_campaign:actualcost:Campaigns_Actual_Cost:actualcost:I', 201 'vtiger_campaign:expectedrevenue:Campaigns_Expected_Revenue:expectedrevenue:I', 202 'vtiger_campaign:expectedsalescount:Campaigns_Expected_Sales_Count:expectedsalescount:N', 203 'vtiger_campaign:actualsalescount:Campaigns_Actual_Sales_Count:actualsalescount:N', 204 'vtiger_usersCampaigns:user_name:Campaigns_Assigned_To:assigned_user_id:V') 205 ); 206 207 $reports = Array(Array('reportname'=>'Contacts by Accounts', 208 'reportfolder'=>'Account and Contact Reports', 209 'description'=>'Contacts related to Accounts', 210 'reporttype'=>'tabular', 211 'sortid'=>'','stdfilterid'=>'','advfilterid'=>'0'), 212 213 Array('reportname'=>'Contacts without Accounts', 214 'reportfolder'=>'Account and Contact Reports', 215 'description'=>'Contacts not related to Accounts', 216 'reporttype'=>'tabular', 217 'sortid'=>'','stdfilterid'=>'','advfilterid'=>'1'), 218 219 Array('reportname'=>'Contacts by Potentials', 220 'reportfolder'=>'Account and Contact Reports', 221 'description'=>'Contacts related to Potentials', 222 'reporttype'=>'tabular', 223 'sortid'=>'','stdfilterid'=>'','advfilterid'=>'2'), 224 225 Array('reportname'=>'Lead by Source', 226 'reportfolder'=>'Lead Reports', 227 'description'=>'Lead by Source', 228 'reporttype'=>'summary', 229 'sortid'=>'0','stdfilterid'=>'','advfilterid'=>''), 230 231 Array('reportname'=>'Lead Status Report', 232 'reportfolder'=>'Lead Reports', 233 'description'=>'Lead Status Report', 234 'reporttype'=>'summary', 235 'sortid'=>'1','stdfilterid'=>'','advfilterid'=>''), 236 237 Array('reportname'=>'Potential Pipeline', 238 'reportfolder'=>'Potential Reports', 239 'description'=>'Potential Pipeline', 240 'reporttype'=>'summary', 241 'sortid'=>'2','stdfilterid'=>'','advfilterid'=>''), 242 243 Array('reportname'=>'Closed Potentials', 244 'reportfolder'=>'Potential Reports', 245 'description'=>'Potential that have Won', 246 'reporttype'=>'tabular', 247 'sortid'=>'','stdfilterid'=>'','advfilterid'=>'3'), 248 249 Array('reportname'=>'Last Month Activities', 250 'reportfolder'=>'Activity Reports', 251 'description'=>'Last Month Activities', 252 'reporttype'=>'tabular', 253 'sortid'=>'','stdfilterid'=>'0','advfilterid'=>''), 254 255 Array('reportname'=>'This Month Activities', 256 'reportfolder'=>'Activity Reports', 257 'description'=>'This Month Activities', 258 'reporttype'=>'tabular', 259 'sortid'=>'','stdfilterid'=>'1','advfilterid'=>''), 260 261 Array('reportname'=>'Tickets by Products', 262 'reportfolder'=>'HelpDesk Reports', 263 'description'=>'Tickets related to Products', 264 'reporttype'=>'tabular', 265 'sortid'=>'','stdfilterid'=>'','advfilterid'=>''), 266 267 Array('reportname'=>'Tickets by Priority', 268 'reportfolder'=>'HelpDesk Reports', 269 'description'=>'Tickets by Priority', 270 'reporttype'=>'summary', 271 'sortid'=>'3','stdfilterid'=>'','advfilterid'=>''), 272 273 Array('reportname'=>'Open Tickets', 274 'reportfolder'=>'HelpDesk Reports', 275 'description'=>'Tickets that are Open', 276 'reporttype'=>'tabular', 277 'sortid'=>'','stdfilterid'=>'','advfilterid'=>'4'), 278 279 Array('reportname'=>'Product Details', 280 'reportfolder'=>'Product Reports', 281 'description'=>'Product Detailed Report', 282 'reporttype'=>'tabular', 283 'sortid'=>'','stdfilterid'=>'','advfilterid'=>''), 284 285 Array('reportname'=>'Products by Contacts', 286 'reportfolder'=>'Product Reports', 287 'description'=>'Products related to Contacts', 288 'reporttype'=>'tabular', 289 'sortid'=>'','stdfilterid'=>'','advfilterid'=>''), 290 291 Array('reportname'=>'Open Quotes', 292 'reportfolder'=>'Quote Reports', 293 'description'=>'Quotes that are Open', 294 'reporttype'=>'tabular', 295 'sortid'=>'','stdfilterid'=>'','advfilterid'=>'5'), 296 297 Array('reportname'=>'Quotes Detailed Report', 298 'reportfolder'=>'Quote Reports', 299 'description'=>'Quotes Detailed Report', 300 'reporttype'=>'tabular', 301 'sortid'=>'','stdfilterid'=>'','advfilterid'=>''), 302 303 Array('reportname'=>'PurchaseOrder by Contacts', 304 'reportfolder'=>'PurchaseOrder Reports', 305 'description'=>'PurchaseOrder related to Contacts', 306 'reporttype'=>'tabular', 307 'sortid'=>'','stdfilterid'=>'','advfilterid'=>''), 308 309 Array('reportname'=>'PurchaseOrder Detailed Report', 310 'reportfolder'=>'PurchaseOrder Reports', 311 'description'=>'PurchaseOrder Detailed Report', 312 'reporttype'=>'tabular', 313 'sortid'=>'','stdfilterid'=>'','advfilterid'=>''), 314 315 Array('reportname'=>'Invoice Detailed Report', 316 'reportfolder'=>'Invoice Reports', 317 'description'=>'Invoice Detailed Report', 318 'reporttype'=>'tabular', 319 'sortid'=>'','stdfilterid'=>'','advfilterid'=>''), 320 321 Array('reportname'=>'SalesOrder Detailed Report', 322 'reportfolder'=>'SalesOrder Reports', 323 'description'=>'SalesOrder Detailed Report', 324 'reporttype'=>'tabular', 325 'sortid'=>'','stdfilterid'=>'','advfilterid'=>''), 326 327 Array('reportname'=>'Campaign Expectations and Actuals', 328 'reportfolder'=>'Campaign Reports', 329 'description'=>'Campaign Expectations and Actuals', 330 'reporttype'=>'tabular', 331 'sortid'=>'','stdfilterid'=>'','advfilterid'=>'') 332 333 ); 334 335 $sortorder = Array( 336 Array( 337 Array('columnname'=>'vtiger_leaddetails:leadsource:Leads_Lead_Source:leadsource:V', 338 'sortorder'=>'Ascending' 339 ) 340 ), 341 Array( 342 Array('columnname'=>'vtiger_leaddetails:leadstatus:Leads_Lead_Status:leadstatus:V', 343 'sortorder'=>'Ascending' 344 ) 345 ), 346 Array( 347 Array('columnname'=>'vtiger_potential:sales_stage:Potentials_Sales_Stage:sales_stage:V', 348 'sortorder'=>'Ascending' 349 ) 350 ), 351 Array( 352 Array('columnname'=>'vtiger_troubletickets:priority:HelpDesk_Priority:ticketpriorities:V', 353 'sortorder'=>'Ascending' 354 ) 355 ) 356 ); 357 358 $stdfilters = Array(Array('columnname'=>'vtiger_crmentity:modifiedtime:modifiedtime:Calendar_Modified_Time', 359 'datefilter'=>'lastmonth', 360 'startdate'=>'2005-05-01', 361 'enddate'=>'2005-05-31'), 362 363 Array('columnname'=>'vtiger_crmentity:modifiedtime:modifiedtime:Calendar_Modified_Time', 364 'datefilter'=>'thismonth', 365 'startdate'=>'2005-06-01', 366 'enddate'=>'2005-06-30') 367 ); 368 369 $advfilters = Array( 370 Array( 371 Array('columnname'=>'vtiger_contactdetails:accountid:Contacts_Account_Name:account_id:V', 372 'comparator'=>'n', 373 'value'=>'' 374 ) 375 ), 376 Array( 377 Array('columnname'=>'vtiger_contactdetails:accountid:Contacts_Account_Name:account_id:V', 378 'comparator'=>'e', 379 'value'=>'' 380 ) 381 ), 382 Array( 383 Array('columnname'=>'vtiger_potential:potentialname:Potentials_Potential_Name:potentialname:V', 384 'comparator'=>'n', 385 'value'=>'' 386 ) 387 ), 388 Array( 389 Array('columnname'=>'vtiger_potential:sales_stage:Potentials_Sales_Stage:sales_stage:V', 390 'comparator'=>'e', 391 'value'=>'Closed Won' 392 ) 393 ), 394 Array( 395 Array('columnname'=>'vtiger_troubletickets:status:HelpDesk_Status:ticketstatus:V', 396 'comparator'=>'n', 397 'value'=>'Closed' 398 ) 399 ), 400 Array( 401 Array('columnname'=>'vtiger_quotes:quotestage:Quotes_Quote_Stage:quotestage:V', 402 'comparator'=>'n', 403 'value'=>'Accepted' 404 ), 405 Array('columnname'=>'vtiger_quotes:quotestage:Quotes_Quote_Stage:quotestage:V', 406 'comparator'=>'n', 407 'value'=>'Rejected' 408 ) 409 ) 410 ); 411 //quotes:quotestage:Quotes_Quote_Stage:quotestage:V 412 foreach($rptfolder as $key=>$rptarray) 413 { 414 foreach($rptarray as $foldername=>$folderdescription) 415 { 416 PopulateReportFolder($foldername,$folderdescription); 417 $reportid[$foldername] = $key+1; 418 } 419 } 420 421 foreach($reports as $key=>$report) 422 { 423 $queryid = insertSelectQuery(); 424 insertReports($queryid,$reportid[$report['reportfolder']],$report['reportname'],$report['description'],$report['reporttype']); 425 insertSelectColumns($queryid,$selectcolumns[$key]); 426 insertReportModules($queryid,$reportmodules[$key]['primarymodule'],$reportmodules[$key]['secondarymodule']); 427 428 if(isset($stdfilters[$report['stdfilterid']])) 429 { 430 $i = $report['stdfilterid']; 431 insertStdFilter($queryid,$stdfilters[$i]['columnname'],$stdfilters[$i]['datefilter'],$stdfilters[$i]['startdate'],$stdfilters[$i]['enddate']); 432 } 433 434 if(isset($advfilters[$report['advfilterid']])) 435 { 436 insertAdvFilter($queryid,$advfilters[$report['advfilterid']]); 437 } 438 439 if($report['reporttype'] == "summary") 440 { 441 insertSortColumns($queryid,$sortorder[$report['sortid']]); 442 } 443 } 444 $adb->pquery("UPDATE vtiger_report SET sharingtype='Public'",array()); 445 /** Function to store the foldername and folderdescription to database 446 * This function accepts the given folder name and description 447 * ans store it in db as SAVED 448 */ 449 450 function PopulateReportFolder($fldrname,$fldrdescription) 451 { 452 global $adb; 453 $sql = "INSERT INTO vtiger_reportfolder (FOLDERNAME,DESCRIPTION,STATE) VALUES(?,?,?)"; 454 $params = array($fldrname, $fldrdescription, 'SAVED'); 455 $result = $adb->pquery($sql, $params); 456 } 457 458 /** Function to add an entry in selestquery vtiger_table 459 * 460 */ 461 462 function insertSelectQuery() 463 { 464 global $adb; 465 $genQueryId = $adb->getUniqueID("vtiger_selectquery"); 466 if($genQueryId != "") 467 { 468 $iquerysql = "insert into vtiger_selectquery (QUERYID,STARTINDEX,NUMOFOBJECTS) values (?,?,?)"; 469 $iquerysqlresult = $adb->pquery($iquerysql, array($genQueryId,0,0)); 470 } 471 472 return $genQueryId; 473 } 474 475 /** Function to store the vtiger_field names selected for a vtiger_report to a database 476 * 477 * 478 */ 479 480 function insertSelectColumns($queryid,$columnname) 481 { 482 global $adb; 483 if($queryid != "") 484 { 485 for($i=0;$i < count($columnname);$i++) 486 { 487 $icolumnsql = "insert into vtiger_selectcolumn (QUERYID,COLUMNINDEX,COLUMNNAME) values (?,?,?)"; 488 $icolumnsqlresult = $adb->pquery($icolumnsql, array($queryid, $i, $columnname[$i])); 489 } 490 } 491 } 492 493 494 /** Function to store the vtiger_report details to database 495 * This function accepts queryid,folderid,reportname,description,reporttype 496 * as arguments and store the informations in vtiger_report vtiger_table 497 */ 498 499 function insertReports($queryid,$folderid,$reportname,$description,$reporttype) 500 { 501 global $adb; 502 if($queryid != "") 503 { 504 $ireportsql = "insert into vtiger_report (REPORTID,FOLDERID,REPORTNAME,DESCRIPTION,REPORTTYPE,QUERYID,STATE) values (?,?,?,?,?,?,?)"; 505 $ireportparams = array($queryid, $folderid, $reportname, $description, $reporttype, $queryid, 'SAVED'); 506 $ireportresult = $adb->pquery($ireportsql, $ireportparams); 507 } 508 } 509 510 /** Function to store the vtiger_report modules to database 511 * This function accepts queryid,primary module and secondary module 512 * as arguments and store the informations in vtiger_reportmodules vtiger_table 513 */ 514 515 516 function insertReportModules($queryid,$primarymodule,$secondarymodule) 517 { 518 global $adb; 519 if($queryid != "") 520 { 521 $ireportmodulesql = "insert into vtiger_reportmodules (REPORTMODULESID,PRIMARYMODULE,SECONDARYMODULES) values (?,?,?)"; 522 $ireportmoduleresult = $adb->pquery($ireportmodulesql, array($queryid, $primarymodule, $secondarymodule)); 523 } 524 } 525 526 527 /** Function to store the vtiger_report sortorder to database 528 * This function accepts queryid,sortlists 529 * as arguments and store the informations sort columns and 530 * and sortorder in vtiger_reportsortcol vtiger_table 531 */ 532 533 534 function insertSortColumns($queryid,$sortlists) 535 { 536 global $adb; 537 if($queryid != "") 538 { 539 foreach($sortlists as $i=>$sort) 540 { 541 $sort_bysql = "insert into vtiger_reportsortcol (SORTCOLID,REPORTID,COLUMNNAME,SORTORDER) values (?,?,?,?)"; 542 $sort_byresult = $adb->pquery($sort_bysql, array(($i+1), $queryid, $sort['columnname'], $sort['sortorder'])); 543 } 544 } 545 546 } 547 548 549 /** Function to store the vtiger_report sort date details to database 550 * This function accepts queryid,filtercolumn,datefilter,startdate,enddate 551 * as arguments and store the informations in vtiger_reportdatefilter vtiger_table 552 */ 553 554 555 function insertStdFilter($queryid,$filtercolumn,$datefilter,$startdate,$enddate) 556 { 557 global $adb; 558 if($queryid != "") 559 { 560 $ireportmodulesql = "insert into vtiger_reportdatefilter (DATEFILTERID,DATECOLUMNNAME,DATEFILTER,STARTDATE,ENDDATE) values (?,?,?,?,?)"; 561 $ireportmoduleresult = $adb->pquery($ireportmodulesql, array($queryid, $filtercolumn, $datefilter, $startdate, $enddate)); 562 } 563 564 } 565 566 /** Function to store the vtiger_report conditions to database 567 * This function accepts queryid,filters 568 * as arguments and store the informations in vtiger_relcriteria vtiger_table 569 */ 570 571 572 function insertAdvFilter($queryid,$filters) 573 { 574 global $adb; 575 if($queryid != "") 576 { 577 $columnIndexArray = array(); 578 foreach($filters as $i=>$filter) 579 { 580 $irelcriteriasql = "insert into vtiger_relcriteria(QUERYID,COLUMNINDEX,COLUMNNAME,COMPARATOR,VALUE) values (?,?,?,?,?)"; 581 $irelcriteriaresult = $adb->pquery($irelcriteriasql, array($queryid,$i,$filter['columnname'],$filter['comparator'],$filter['value'])); 582 $columnIndexArray[] = $i; 583 } 584 $conditionExpression = implode(' and ', $columnIndexArray); 585 $adb->pquery('INSERT INTO vtiger_relcriteria_grouping VALUES(?,?,?,?)', array(1, $queryid, '', $conditionExpression)); 586 } 587 } 588 ?>
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
| Generated: Fri Nov 28 20:08:37 2014 | Cross-referenced by PHPXref 0.7.1 |