| [ 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 13 $customviews = Array(Array('viewname'=>'All', 14 'setdefault'=>'1','setmetrics'=>'0', 15 'cvmodule'=>'Leads','stdfilterid'=>'','advfilterid'=>''), 16 17 Array('viewname'=>'Hot Leads', 18 'setdefault'=>'0','setmetrics'=>'1', 19 'cvmodule'=>'Leads','stdfilterid'=>'','advfilterid'=>'0'), 20 21 Array('viewname'=>'This Month Leads', 22 'setdefault'=>'0','setmetrics'=>'0', 23 'cvmodule'=>'Leads','stdfilterid'=>'0','advfilterid'=>''), 24 25 Array('viewname'=>'All', 26 'setdefault'=>'1','setmetrics'=>'0', 27 'cvmodule'=>'Accounts','stdfilterid'=>'','advfilterid'=>''), 28 29 Array('viewname'=>'Prospect Accounts', 30 'setdefault'=>'0','setmetrics'=>'1', 31 'cvmodule'=>'Accounts','stdfilterid'=>'','advfilterid'=>'1'), 32 33 Array('viewname'=>'New This Week', 34 'setdefault'=>'0','setmetrics'=>'0', 35 'cvmodule'=>'Accounts','stdfilterid'=>'1','advfilterid'=>''), 36 37 Array('viewname'=>'All', 38 'setdefault'=>'1','setmetrics'=>'0', 39 'cvmodule'=>'Contacts','stdfilterid'=>'','advfilterid'=>''), 40 41 Array('viewname'=>'Contacts Address', 42 'setdefault'=>'0','setmetrics'=>'0', 43 'cvmodule'=>'Contacts','stdfilterid'=>'','advfilterid'=>''), 44 45 Array('viewname'=>'Todays Birthday', 46 'setdefault'=>'0','setmetrics'=>'0', 47 'cvmodule'=>'Contacts','stdfilterid'=>'2','advfilterid'=>''), 48 49 Array('viewname'=>'All', 50 'setdefault'=>'1','setmetrics'=>'0', 51 'cvmodule'=>'Potentials','stdfilterid'=>'','advfilterid'=>''), 52 53 Array('viewname'=>'Potentials Won', 54 'setdefault'=>'0','setmetrics'=>'1', 55 'cvmodule'=>'Potentials','stdfilterid'=>'','advfilterid'=>'2'), 56 57 Array('viewname'=>'Prospecting', 58 'setdefault'=>'0','setmetrics'=>'0', 59 'cvmodule'=>'Potentials','stdfilterid'=>'','advfilterid'=>'3'), 60 61 Array('viewname'=>'All', 62 'setdefault'=>'1','setmetrics'=>'0', 63 'cvmodule'=>'HelpDesk','stdfilterid'=>'','advfilterid'=>''), 64 65 Array('viewname'=>'Open Tickets', 66 'setdefault'=>'0','setmetrics'=>'1', 67 'cvmodule'=>'HelpDesk','stdfilterid'=>'','advfilterid'=>'4'), 68 69 Array('viewname'=>'High Prioriy Tickets', 70 'setdefault'=>'0','setmetrics'=>'0', 71 'cvmodule'=>'HelpDesk','stdfilterid'=>'','advfilterid'=>'5'), 72 73 Array('viewname'=>'All', 74 'setdefault'=>'1','setmetrics'=>'0', 75 'cvmodule'=>'Quotes','stdfilterid'=>'','advfilterid'=>''), 76 77 Array('viewname'=>'Open Quotes', 78 'setdefault'=>'0','setmetrics'=>'1', 79 'cvmodule'=>'Quotes','stdfilterid'=>'','advfilterid'=>'6'), 80 81 Array('viewname'=>'Rejected Quotes', 82 'setdefault'=>'0','setmetrics'=>'0', 83 'cvmodule'=>'Quotes','stdfilterid'=>'','advfilterid'=>'7'), 84 85 Array('viewname'=>'All', 86 'setdefault'=>'1','setmetrics'=>'0', 87 'cvmodule'=>'Calendar','stdfilterid'=>'','advfilterid'=>''), 88 89 Array('viewname'=>'All', 90 'setdefault'=>'1','setmetrics'=>'0', 91 'cvmodule'=>'Emails','stdfilterid'=>'','advfilterid'=>''), 92 93 Array('viewname'=>'All', 94 'setdefault'=>'1','setmetrics'=>'0', 95 'cvmodule'=>'Invoice','stdfilterid'=>'','advfilterid'=>''), 96 97 Array('viewname'=>'All', 98 'setdefault'=>'1','setmetrics'=>'0', 99 'cvmodule'=>'Notes','stdfilterid'=>'','advfilterid'=>''), 100 101 Array('viewname'=>'All', 102 'setdefault'=>'1','setmetrics'=>'0', 103 'cvmodule'=>'PriceBooks','stdfilterid'=>'','advfilterid'=>''), 104 105 Array('viewname'=>'All', 106 'setdefault'=>'1','setmetrics'=>'0', 107 'cvmodule'=>'Products','stdfilterid'=>'','advfilterid'=>''), 108 109 Array('viewname'=>'All', 110 'setdefault'=>'1','setmetrics'=>'0', 111 'cvmodule'=>'PurchaseOrder','stdfilterid'=>'','advfilterid'=>''), 112 113 Array('viewname'=>'All', 114 'setdefault'=>'1','setmetrics'=>'0', 115 'cvmodule'=>'SalesOrder','stdfilterid'=>'','advfilterid'=>''), 116 117 Array('viewname'=>'All', 118 'setdefault'=>'1','setmetrics'=>'0', 119 'cvmodule'=>'Vendors','stdfilterid'=>'','advfilterid'=>''), 120 121 Array('viewname'=>'All', 122 'setdefault'=>'1','setmetrics'=>'0', 123 'cvmodule'=>'Faq','stdfilterid'=>'','advfilterid'=>''), 124 125 Array('viewname'=>'All', 126 'setdefault'=>'1','setmetrics'=>'0', 127 'cvmodule'=>'Campaigns','stdfilterid'=>'','advfilterid'=>''), 128 129 Array('viewname'=>'All', 130 'setdefault'=>'1','setmetrics'=>'0', 131 'cvmodule'=>'Webmails','stdfilterid'=>'','advfilterid'=>''), 132 133 Array('viewname'=>'Drafted FAQ', 134 'setdefault'=>'0','setmetrics'=>'0', 135 'cvmodule'=>'Faq','stdfilterid'=>'','advfilterid'=>'8'), 136 137 Array('viewname'=>'Published FAQ', 138 'setdefault'=>'0','setmetrics'=>'0', 139 'cvmodule'=>'Faq','stdfilterid'=>'','advfilterid'=>'9'), 140 141 Array('viewname'=>'Open Purchase Orders', 142 'setdefault'=>'0','setmetrics'=>'0', 143 'cvmodule'=>'PurchaseOrder','stdfilterid'=>'','advfilterid'=>'10'), 144 145 Array('viewname'=>'Received Purchase Orders', 146 'setdefault'=>'0','setmetrics'=>'0', 147 'cvmodule'=>'PurchaseOrder','stdfilterid'=>'','advfilterid'=>'11'), 148 149 Array('viewname'=>'Open Invoices', 150 'setdefault'=>'0','setmetrics'=>'0', 151 'cvmodule'=>'Invoice','stdfilterid'=>'','advfilterid'=>'12'), 152 153 Array('viewname'=>'Paid Invoices', 154 'setdefault'=>'0','setmetrics'=>'0', 155 'cvmodule'=>'Invoice','stdfilterid'=>'','advfilterid'=>'13'), 156 157 Array('viewname'=>'Pending Sales Orders', 158 'setdefault'=>'0','setmetrics'=>'0', 159 'cvmodule'=>'SalesOrder','stdfilterid'=>'','advfilterid'=>'14'), 160 ); 161 162 163 $cvcolumns = Array(Array('vtiger_leaddetails:lastname:lastname:Leads_Last_Name:V', 164 'vtiger_leaddetails:firstname:firstname:Leads_First_Name:V', 165 'vtiger_leaddetails:company:company:Leads_Company:V', 166 'vtiger_leadaddress:phone:phone:Leads_Phone:V', 167 'vtiger_leadsubdetails:website:website:Leads_Website:V', 168 'vtiger_leaddetails:email:email:Leads_Email:E', 169 'vtiger_crmentity:smownerid:assigned_user_id:Leads_Assigned_To:V'), 170 171 Array('vtiger_leaddetails:firstname:firstname:Leads_First_Name:V', 172 'vtiger_leaddetails:lastname:lastname:Leads_Last_Name:V', 173 'vtiger_leaddetails:company:company:Leads_Company:V', 174 'vtiger_leaddetails:leadsource:leadsource:Leads_Lead_Source:V', 175 'vtiger_leadsubdetails:website:website:Leads_Website:V', 176 'vtiger_leaddetails:email:email:Leads_Email:E'), 177 178 Array('vtiger_leaddetails:firstname:firstname:Leads_First_Name:V', 179 'vtiger_leaddetails:lastname:lastname:Leads_Last_Name:V', 180 'vtiger_leaddetails:company:company:Leads_Company:V', 181 'vtiger_leaddetails:leadsource:leadsource:Leads_Lead_Source:V', 182 'vtiger_leadsubdetails:website:website:Leads_Website:V', 183 'vtiger_leaddetails:email:email:Leads_Email:E'), 184 185 Array('vtiger_account:accountname:accountname:Accounts_Account_Name:V', 186 'vtiger_accountbillads:city:bill_city:Accounts_City:V', 187 'vtiger_account:website:website:Accounts_Website:V', 188 'vtiger_account:phone:phone:Accounts_Phone:V', 189 'vtiger_crmentity:smownerid:assigned_user_id:Accounts_Assigned_To:V'), 190 191 Array('vtiger_account:accountname:accountname:Accounts_Account_Name:V', 192 'vtiger_account:phone:phone:Accounts_Phone:V', 193 'vtiger_account:website:website:Accounts_Website:V', 194 'vtiger_account:rating:rating:Accounts_Rating:V', 195 'vtiger_crmentity:smownerid:assigned_user_id:Accounts_Assigned_To:V'), 196 197 Array('vtiger_account:accountname:accountname:Accounts_Account_Name:V', 198 'vtiger_account:phone:phone:Accounts_Phone:V', 199 'vtiger_account:website:website:Accounts_Website:V', 200 'vtiger_accountbillads:city:bill_city:Accounts_City:V', 201 'vtiger_crmentity:smownerid:assigned_user_id:Accounts_Assigned_To:V'), 202 203 Array('vtiger_contactdetails:firstname:firstname:Contacts_First_Name:V', 204 'vtiger_contactdetails:lastname:lastname:Contacts_Last_Name:V', 205 'vtiger_contactdetails:title:title:Contacts_Title:V', 206 'vtiger_contactdetails:accountid:account_id:Contacts_Account_Name:I', 207 'vtiger_contactdetails:email:email:Contacts_Email:E', 208 'vtiger_contactdetails:phone:phone:Contacts_Office_Phone:V', 209 'vtiger_crmentity:smownerid:assigned_user_id:Contacts_Assigned_To:V'), 210 211 Array('vtiger_contactdetails:firstname:firstname:Contacts_First_Name:V', 212 'vtiger_contactdetails:lastname:lastname:Contacts_Last_Name:V', 213 'vtiger_contactaddress:mailingstreet:mailingstreet:Contacts_Mailing_Street:V', 214 'vtiger_contactaddress:mailingcity:mailingcity:Contacts_City:V', 215 'vtiger_contactaddress:mailingstate:mailingstate:Contacts_State:V', 216 'vtiger_contactaddress:mailingzip:mailingzip:Contacts_Zip:V', 217 'vtiger_contactaddress:mailingcountry:mailingcountry:Contacts_Country:V'), 218 219 Array('vtiger_contactdetails:firstname:firstname:Contacts_First_Name:V', 220 'vtiger_contactdetails:lastname:lastname:Contacts_Last_Name:V', 221 'vtiger_contactdetails:title:title:Contacts_Title:V', 222 'vtiger_contactdetails:accountid:account_id:Contacts_Account_Name:I', 223 'vtiger_contactdetails:email:email:Contacts_Email:E', 224 'vtiger_contactsubdetails:otherphone:otherphone:Contacts_Phone:V', 225 'vtiger_crmentity:smownerid:assigned_user_id:Contacts_Assigned_To:V'), 226 227 Array('vtiger_potential:potentialname:potentialname:Potentials_Potential_Name:V', 228 'vtiger_potential:accountid:account_id:Potentials_Account_Name:V', 229 'vtiger_potential:sales_stage:sales_stage:Potentials_Sales_Stage:V', 230 'vtiger_potential:leadsource:leadsource:Potentials_Lead_Source:V', 231 'vtiger_potential:closingdate:closingdate:Potentials_Expected_Close_Date:D', 232 'vtiger_crmentity:smownerid:assigned_user_id:Potentials_Assigned_To:V'), 233 234 Array('vtiger_potential:potentialname:potentialname:Potentials_Potential_Name:V', 235 'vtiger_potential:accountid:account_id:Potentials_Account_Name:V', 236 'vtiger_potential:amount:amount:Potentials_Amount:N', 237 'vtiger_potential:closingdate:closingdate:Potentials_Expected_Close_Date:D', 238 'vtiger_crmentity:smownerid:assigned_user_id:Potentials_Assigned_To:V'), 239 240 Array('vtiger_potential:potentialname:potentialname:Potentials_Potential_Name:V', 241 'vtiger_potential:accountid:account_id:Potentials_Account_Name:V', 242 'vtiger_potential:amount:amount:Potentials_Amount:N', 243 'vtiger_potential:leadsource:leadsource:Potentials_Lead_Source:V', 244 'vtiger_potential:closingdate:closingdate:Potentials_Expected_Close_Date:D', 245 'vtiger_crmentity:smownerid:assigned_user_id:Potentials_Assigned_To:V'), 246 247 Array('vtiger_crmentity:crmid::HelpDesk_Ticket_ID:I', 248 'vtiger_troubletickets:title:ticket_title:HelpDesk_Title:V', 249 'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_to:I', 250 'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V', 251 'vtiger_troubletickets:priority:ticketpriorities:HelpDesk_Priority:V', 252 'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'), 253 254 Array('vtiger_troubletickets:title:ticket_title:HelpDesk_Title:V', 255 'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_to:I', 256 'vtiger_troubletickets:priority:ticketpriorities:HelpDesk_Priority:V', 257 'vtiger_troubletickets:product_id:product_id:HelpDesk_Product_Name:I', 258 'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'), 259 260 Array('vtiger_troubletickets:title:ticket_title:HelpDesk_Title:V', 261 'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_to:I', 262 'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V', 263 'vtiger_troubletickets:product_id:product_id:HelpDesk_Product_Name:I', 264 'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'), 265 266 Array('vtiger_crmentity:crmid::Quotes_Quote_ID:I', 267 'vtiger_quotes:subject:subject:Quotes_Subject:V', 268 'vtiger_quotes:quotestage:quotestage:Quotes_Quote_Stage:V', 269 'vtiger_quotes:potentialid:potential_id:Quotes_Potential_Name:I', 270 'vtiger_quotes:accountid:account_id:Quotes_Account_Name:I', 271 'vtiger_quotes:total:hdnGrandTotal:Quotes_Total:I', 272 'vtiger_crmentity:smownerid:assigned_user_id:Quotes_Assigned_To:V'), 273 274 Array('vtiger_quotes:subject:subject:Quotes_Subject:V', 275 'vtiger_quotes:quotestage:quotestage:Quotes_Quote_Stage:V', 276 'vtiger_quotes:potentialid:potential_id:Quotes_Potential_Name:I', 277 'vtiger_quotes:accountid:account_id:Quotes_Account_Name:I', 278 'vtiger_quotes:validtill:validtill:Quotes_Valid_Till:D', 279 'vtiger_crmentity:smownerid:assigned_user_id:Quotes_Assigned_To:V'), 280 281 Array('vtiger_quotes:subject:subject:Quotes_Subject:V', 282 'vtiger_quotes:potentialid:potential_id:Quotes_Potential_Name:I', 283 'vtiger_quotes:accountid:account_id:Quotes_Account_Name:I', 284 'vtiger_quotes:validtill:validtill:Quotes_Valid_Till:D', 285 'vtiger_crmentity:smownerid:assigned_user_id:Quotes_Assigned_To:V'), 286 287 Array('vtiger_activity:status:taskstatus:Calendar_Status:V', 288 'vtiger_activity:activitytype:activitytype:Calendar_Type:V', 289 'vtiger_activity:subject:subject:Calendar_Subject:V', 290 'vtiger_seactivityrel:crmid:parent_id:Calendar_Related_to:V', 291 'vtiger_activity:date_start:date_start:Calendar_Start_Date:D', 292 'vtiger_activity:due_date:due_date:Calendar_End_Date:D', 293 'vtiger_crmentity:smownerid:assigned_user_id:Calendar_Assigned_To:V'), 294 295 Array('vtiger_activity:subject:subject:Emails_Subject:V', 296 'vtiger_crmentity:smownerid:assigned_user_id:Emails_Sender:V', 297 'vtiger_activity:date_start:date_start:Emails_Date_Sent:D'), 298 299 Array('vtiger_crmentity:crmid::Invoice_Invoice_Id:I', 300 'vtiger_invoice:subject:subject:Invoice_Subject:V', 301 'vtiger_invoice:salesorderid:salesorder_id:Invoice_Sales_Order:I', 302 'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V', 303 'vtiger_invoice:total:hdnGrandTotal:Invoice_Total:I', 304 'vtiger_crmentity:smownerid:assigned_user_id:Invoice_Assigned_To:V'), 305 306 Array('vtiger_notes:title:notes_title:Notes_Title:V', 307 'vtiger_notes:contact_id:contact_id:Notes_Contact_Name:I', 308 'vtiger_senotesrel:crmid:parent_id:Notes_Related_to:I', 309 'vtiger_notes:filename:filename:Notes_File:V', 310 'vtiger_crmentity:modifiedtime:modifiedtime:Notes_Modified_Time:V'), 311 312 Array('vtiger_pricebook:bookname:bookname:PriceBooks_Price_Book_Name:V', 313 'vtiger_pricebook:active:active:PriceBooks_Active:V'), 314 315 Array('vtiger_products:productname:productname:Products_Product_Name:V', 316 'vtiger_products:productcode:productcode:Products_Product_Code:V', 317 'vtiger_products:commissionrate:commissionrate:Products_Commission_Rate:V', 318 'vtiger_products:qtyinstock:qtyinstock:Products_Quantity_In_Stock:V', 319 'vtiger_products:qty_per_unit:qty_per_unit:Products_Qty/Unit:V', 320 'vtiger_products:unit_price:unit_price:Products_Unit_Price:V'), 321 322 Array('vtiger_crmentity:crmid::PurchaseOrder_Order_Id:I', 323 'vtiger_purchaseorder:subject:subject:PurchaseOrder_Subject:V', 324 'vtiger_purchaseorder:vendorid:vendor_id:PurchaseOrder_Vendor_Name:I', 325 'vtiger_purchaseorder:tracking_no:tracking_no:PurchaseOrder_Tracking_Number:V', 326 'vtiger_crmentity:smownerid:assigned_user_id:PurchaseOrder_Assigned_To:V'), 327 328 Array('vtiger_crmentity:crmid::SalesOrder_Order_Id:I', 329 'vtiger_salesorder:subject:subject:SalesOrder_Subject:V', 330 'vtiger_account:accountid:account_id:SalesOrder_Account_Name:V', 331 'vtiger_quotes:quoteid:quote_id:SalesOrder_Quote_Name:I', 332 'vtiger_salesorder:total:hdnGrandTotal:SalesOrder_Total:V', 333 'vtiger_crmentity:smownerid:assigned_user_id:SalesOrder_Assigned_To:V'), 334 335 Array('vtiger_vendor:vendorname:vendorname:Vendors_Vendor_Name:V', 336 'vtiger_vendor:phone:phone:Vendors_Phone:V', 337 'vtiger_vendor:email:email:Vendors_Email:E', 338 'vtiger_vendor:category:category:Vendors_Category:V'), 339 340 341 342 343 Array('vtiger_faq:id::Faq_FAQ_Id:I', 344 'vtiger_faq:question:question:Faq_Question:V', 345 'vtiger_faq:category:faqcategories:Faq_Category:V', 346 'vtiger_faq:product_id:product_id:Faq_Product_Name:I', 347 'vtiger_crmentity:createdtime:createdtime:Faq_Created_Time:D', 348 'vtiger_crmentity:modifiedtime:modifiedtime:Faq_Modified_Time:D'), 349 //this sequence has to be maintained 350 Array('vtiger_campaign:campaignname:campaignname:Campaigns_Campaign_Name:V', 351 'vtiger_campaign:campaigntype:campaigntype:Campaigns_Campaign_Type:N', 352 'vtiger_campaign:campaignstatus:campaignstatus:Campaigns_Campaign_Status:N', 353 'vtiger_campaign:expectedrevenue:expectedrevenue:Campaigns_Expected_Revenue:V', 354 'vtiger_campaign:closingdate:closingdate:Campaigns_Expected_Close_Date:D', 355 'vtiger_crmentity:smownerid:assigned_user_id:Campaigns_Assigned_To:V'), 356 357 358 Array('subject:subject:subject:Subject:V', 359 'from:fromname:fromname:From:N', 360 'to:tpname:toname:To:N', 361 'body:body:body:Body:V'), 362 363 Array ('vtiger_faq:question:question:Faq_Question:V', 364 'vtiger_faq:status:faqstatus:Faq_Status:V', 365 'vtiger_faq:product_id:product_id:Faq_Product_Name:I', 366 'vtiger_faq:category:faqcategories:Faq_Category:V', 367 'vtiger_crmentity:createdtime:createdtime:Faq_Created_Time:T'), 368 369 Array( 'vtiger_faq:question:question:Faq_Question:V', 370 'vtiger_faq:answer:faq_answer:Faq_Answer:V', 371 'vtiger_faq:status:faqstatus:Faq_Status:V', 372 'vtiger_faq:product_id:product_id:Faq_Product_Name:I', 373 'vtiger_faq:category:faqcategories:Faq_Category:V', 374 'vtiger_crmentity:createdtime:createdtime:Faq_Created_Time:T'), 375 376 Array( 'vtiger_purchaseorder:subject:subject:PurchaseOrder_Subject:V', 377 'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V', 378 'vtiger_purchaseorder:vendorid:vendor_id:PurchaseOrder_Vendor_Name:I', 379 'vtiger_crmentity:smownerid:assigned_user_id:PurchaseOrder_Assigned_To:V', 380 'vtiger_purchaseorder:duedate:duedate:PurchaseOrder_Due_Date:V'), 381 382 Array ('vtiger_purchaseorder:subject:subject:PurchaseOrder_Subject:V', 383 'vtiger_purchaseorder:vendorid:vendor_id:PurchaseOrder_Vendor_Name:I', 384 'vtiger_crmentity:smownerid:assigned_user_id:PurchaseOrder_Assigned_To:V', 385 'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V', 386 'vtiger_purchaseorder:carrier:carrier:PurchaseOrder_Carrier:V', 387 'vtiger_poshipads:ship_street:ship_street:PurchaseOrder_Shipping_Address:V'), 388 389 Array( 'vtiger_invoice:subject:subject:Invoice_Subject:V', 390 'vtiger_invoice:accountid:account_id:Invoice_Account_Name:I', 391 'vtiger_invoice:salesorderid:salesorder_id:Invoice_Sales_Order:I', 392 'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V', 393 'vtiger_crmentity:smownerid:assigned_user_id:Invoice_Assigned_To:V', 394 'vtiger_crmentity:createdtime:createdtime:Invoice_Created_Time:T'), 395 396 Array( 'vtiger_invoice:subject:subject:Invoice_Subject:V', 397 'vtiger_invoice:accountid:account_id:Invoice_Account_Name:I', 398 'vtiger_invoice:salesorderid:salesorder_id:Invoice_Sales_Order:I', 399 'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V', 400 'vtiger_invoiceshipads:ship_street:ship_street:Invoice_Shipping_Address:V', 401 'vtiger_crmentity:smownerid:assigned_user_id:Invoice_Assigned_To:V'), 402 403 Array( 'vtiger_salesorder:subject:subject:SalesOrder_Subject:V', 404 'vtiger_salesorder:accountid:account_id:SalesOrder_Account_Name:I', 405 'vtiger_salesorder:sostatus:sostatus:SalesOrder_Status:V', 406 'vtiger_crmentity:smownerid:assigned_user_id:SalesOrder_Assigned_To:V', 407 'vtiger_soshipads:ship_street:ship_street:SalesOrder_Shipping_Address:V', 408 'vtiger_salesorder:carrier:carrier:SalesOrder_Carrier:V'), 409 410 ); 411 412 413 414 $cvstdfilters = Array(Array('columnname'=>'vtiger_crmentity:modifiedtime:modifiedtime:Leads_Modified_Time', 415 'datefilter'=>'thismonth', 416 'startdate'=>'2005-06-01', 417 'enddate'=>'2005-06-30'), 418 419 Array('columnname'=>'vtiger_crmentity:createdtime:createdtime:Accounts_Created_Time', 420 'datefilter'=>'thisweek', 421 'startdate'=>'2005-06-19', 422 'enddate'=>'2005-06-25'), 423 424 Array('columnname'=>'vtiger_contactsubdetails:birthday:birthday:Contacts_Birthdate', 425 'datefilter'=>'today', 426 'startdate'=>'2005-06-25', 427 'enddate'=>'2005-06-25') 428 ); 429 430 $cvadvfilters = Array( 431 Array( 432 Array('columnname'=>'vtiger_leaddetails:leadstatus:leadstatus:Leads_Lead_Status:V', 433 'comparator'=>'e', 434 'value'=>'Hot' 435 ) 436 ), 437 Array( 438 Array('columnname'=>'vtiger_account:account_type:accounttype:Accounts_Type:V', 439 'comparator'=>'e', 440 'value'=>'Prospect' 441 ) 442 ), 443 Array( 444 Array('columnname'=>'vtiger_potential:sales_stage:sales_stage:Potentials_Sales_Stage:V', 445 'comparator'=>'e', 446 'value'=>'Closed Won' 447 ) 448 ), 449 Array( 450 Array('columnname'=>'vtiger_potential:sales_stage:sales_stage:Potentials_Sales_Stage:V', 451 'comparator'=>'e', 452 'value'=>'Prospecting' 453 ) 454 ), 455 Array( 456 Array('columnname'=>'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V', 457 'comparator'=>'n', 458 'value'=>'Closed' 459 ) 460 ), 461 Array( 462 Array('columnname'=>'vtiger_troubletickets:priority:ticketpriorities:HelpDesk_Priority:V', 463 'comparator'=>'e', 464 'value'=>'High' 465 ) 466 ), 467 Array( 468 Array('columnname'=>'vtiger_quotes:quotestage:quotestage:Quotes_Quote_Stage:V', 469 'comparator'=>'n', 470 'value'=>'Accepted' 471 ), 472 Array('columnname'=>'vtiger_quotes:quotestage:quotestage:Quotes_Quote_Stage:V', 473 'comparator'=>'n', 474 'value'=>'Rejected' 475 ) 476 ), 477 Array( 478 Array('columnname'=>'vtiger_quotes:quotestage:quotestage:Quotes_Quote_Stage:V', 479 'comparator'=>'e', 480 'value'=>'Rejected' 481 ) 482 ), 483 484 Array( 485 Array('columnname'=>'vtiger_faq:status:faqstatus:Faq_Status:V', 486 'comparator'=>'e', 487 'value'=>'Draft' 488 ) 489 ), 490 491 Array( 492 Array('columnname'=>'vtiger_faq:status:faqstatus:Faq_Status:V', 493 'comparator'=>'e', 494 'value'=>'Published' 495 ) 496 ), 497 498 Array( 499 Array('columnname'=>'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V', 500 'comparator'=>'e', 501 'value'=>'Created, Approved, Delivered' 502 ) 503 ), 504 505 Array( 506 Array('columnname'=>'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V', 507 'comparator'=>'e', 508 'value'=>'Recieved Shipment' 509 ) 510 ), 511 512 Array( 513 Array('columnname'=>'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V', 514 'comparator'=>'e', 515 'value'=>'Created, Approved, Sent' 516 ) 517 ), 518 519 Array( 520 Array('columnname'=>'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V', 521 'comparator'=>'e', 522 'value'=>'Paid' 523 ) 524 ), 525 526 Array( 527 Array('columnname'=>'vtiger_salesorder:sostatus:sostatus:SalesOrder_Status:V', 528 'comparator'=>'e', 529 'value'=>'Created, Approved' 530 ) 531 ) 532 533 ); 534 535 foreach($customviews as $key=>$customview) 536 { 537 $queryid = insertCustomView($customview['viewname'],$customview['setdefault'],$customview['setmetrics'],$customview['cvmodule']); 538 insertCvColumns($queryid,$cvcolumns[$key]); 539 540 if(isset($cvstdfilters[$customview['stdfilterid']])) 541 { 542 $i = $customview['stdfilterid']; 543 insertCvStdFilter($queryid,$cvstdfilters[$i]['columnname'],$cvstdfilters[$i]['datefilter'],$cvstdfilters[$i]['startdate'],$cvstdfilters[$i]['enddate']); 544 } 545 if(isset($cvadvfilters[$customview['advfilterid']])) 546 { 547 insertCvAdvFilter($queryid,$cvadvfilters[$customview['advfilterid']]); 548 } 549 } 550 551 /** to store the details of the customview in vtiger_customview table 552 * @param $viewname :: Type String 553 * @param $setdefault :: Type Integer 554 * @param $setmetrics :: Type Integer 555 * @param $cvmodule :: Type String 556 * @returns $customviewid of the stored custom view :: Type integer 557 */ 558 function insertCustomView($viewname,$setdefault,$setmetrics,$cvmodule) 559 { 560 global $adb; 561 562 $genCVid = $adb->getUniqueID("vtiger_customview"); 563 564 if($genCVid != "") 565 { 566 567 $customviewsql = "insert into vtiger_customview(cvid,viewname,setdefault,setmetrics,entitytype)"; 568 $customviewsql .= " values(".$genCVid.",'".$viewname."',".$setdefault.",".$setmetrics.",'".$cvmodule."')"; 569 $customviewresult = $adb->query($customviewsql); 570 } 571 return $genCVid; 572 } 573 574 /** to store the custom view columns of the customview in vtiger_cvcolumnlist table 575 * @param $cvid :: Type Integer 576 * @param $columnlist :: Type Array of columnlists 577 */ 578 function insertCvColumns($CVid,$columnslist) 579 { 580 global $adb; 581 if($CVid != "") 582 { 583 for($i=0;$i<count($columnslist);$i++) 584 { 585 $columnsql = "insert into vtiger_cvcolumnlist (cvid,columnindex,columnname)"; 586 $columnsql .= " values (".$CVid.",".$i.",'".$columnslist[$i]."')"; 587 $columnresult = $adb->query($columnsql); 588 } 589 } 590 } 591 592 /** to store the custom view stdfilter of the customview in vtiger_cvstdfilter table 593 * @param $cvid :: Type Integer 594 * @param $filtercolumn($tablename:$columnname:$fieldname:$fieldlabel) :: Type String 595 * @param $filtercriteria(filter name) :: Type String 596 * @param $startdate :: Type String 597 * @param $enddate :: Type String 598 * returns nothing 599 */ 600 function insertCvStdFilter($CVid,$filtercolumn,$filtercriteria,$startdate,$enddate) 601 { 602 global $adb; 603 if($CVid != "") 604 { 605 $stdfiltersql = "insert into vtiger_cvstdfilter(cvid,columnname,stdfilter,startdate,enddate)"; 606 $stdfiltersql .= " values (".$CVid.",'".$filtercolumn."',"; 607 $stdfiltersql .= "'".$filtercriteria."',"; 608 $stdfiltersql .= "'".$startdate."',"; 609 $stdfiltersql .= "'".$enddate."')"; 610 $stdfilterresult = $adb->query($stdfiltersql); 611 } 612 } 613 614 /** to store the custom view advfilter of the customview in vtiger_cvadvfilter table 615 * @param $cvid :: Type Integer 616 * @param $filters :: Type Array('columnname'=>$tablename:$columnname:$fieldname:$fieldlabel,'comparator'=>$comparator,'value'=>$value) 617 * returns nothing 618 */ 619 620 function insertCvAdvFilter($CVid,$filters) 621 { 622 global $adb; 623 if($CVid != "") 624 { 625 foreach($filters as $i=>$filter) 626 { 627 $advfiltersql = "insert into vtiger_cvadvfilter(cvid,columnindex,columnname,comparator,value)"; 628 $advfiltersql .= " values (".$CVid.",".$i.",'".$filter['columnname']."',"; 629 $advfiltersql .= "'".$filter['comparator']."',"; 630 $advfiltersql .= "'".$filter['value']."')"; 631 $advfilterresult = $adb->query($advfiltersql); 632 } 633 } 634 } 635 ?>
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 |