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