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