2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
3 /*********************************************************************************
4 * SugarCRM is a customer relationship management program developed by
5 * SugarCRM, Inc. Copyright (C) 2004-2011 SugarCRM Inc.
7 * This program is free software; you can redistribute it and/or modify it under
8 * the terms of the GNU Affero General Public License version 3 as published by the
9 * Free Software Foundation with the addition of the following permission added
10 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
11 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
12 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
14 * This program is distributed in the hope that it will be useful, but WITHOUT
15 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
16 * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
19 * You should have received a copy of the GNU Affero General Public License along with
20 * this program; if not, see http://www.gnu.org/licenses or write to the Free
21 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
24 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
25 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
27 * The interactive user interfaces in modified source and object code versions
28 * of this program must display Appropriate Legal Notices, as required under
29 * Section 5 of the GNU Affero General Public License version 3.
31 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
32 * these Appropriate Legal Notices must retain the display of the "Powered by
33 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
34 * technical reasons, the Appropriate Legal Notices must display the words
35 * "Powered by SugarCRM".
36 ********************************************************************************/
43 global $sugar_demodata;
44 $sugar_demodata['users'][0] = array(
45 'id' => 'seed_jim_id',
46 'last_name' => 'Brennan',
47 'first_name' => 'Jim',
49 'title' => 'VP Sales',
52 'reports_to_name' => null,
53 'email' => 'jim@example.com'
57 $sugar_demodata['users'][] = array(
58 'id' => 'seed_sarah_id',
59 'last_name' => 'Smith',
60 'first_name' => 'Sarah',
61 'user_name' => 'sarah',
62 'title' => 'Sales Manager West',
64 'reports_to' => 'seed_jim_id',
65 'reports_to_name' => 'Brennan, Jim',
66 'email' => 'sarah@example.com'
69 $sugar_demodata['users'][] = array(
70 'id' => 'seed_sally_id',
71 'last_name' => 'Bronsen',
72 'first_name' => 'Sally',
73 'user_name' => 'sally',
74 'title' => 'Senior Account Rep',
76 'reports_to' => 'seed_sarah_id',
77 'reports_to_name' => 'Smith, Sarah',
78 'email' => 'sally@example.com'
81 $sugar_demodata['users'][] = array(
82 'id' => 'seed_max_id',
83 'last_name' => 'Jensen',
84 'first_name' => 'Max',
86 'title' => 'Account Rep',
88 'reports_to' => 'seed_sarah_id',
89 'reports_to_name' => 'Smith, Sarah',
90 'email' => 'tom@example.com'
94 $sugar_demodata['users'][] = array(
95 'id' => 'seed_will_id',
96 'last_name' => 'Westin',
97 'first_name' => 'Will',
98 'user_name' => 'will',
99 'title' => 'Sales Manager East',
101 'reports_to' => 'seed_jim_id',
102 'reports_to_name' => 'Brennan, Jim',
103 'email' => 'will@example.com'
106 $sugar_demodata['users'][] = array(
107 'id' => 'seed_chris_id',
108 'last_name' => 'Olliver',
109 'first_name' => 'Chris',
110 'user_name' => 'chris',
111 'title' => 'Senior Account Rep',
113 'reports_to' => 'seed_will_id',
114 'reports_to_name' => 'Westin, Will',
115 'email' => 'chris@example.com'
119 $sugar_demodata['teams'][] = array(
121 'description' => 'This is the team for the East',
125 $sugar_demodata['teams'][] = array(
127 'description' => 'This is the team for the West',
132 $sugar_demodata['last_name_array'] = array(
18974 $sugar_demodata['first_name_array'] = array(
21251 $sugar_demodata['company_name_array'] = array(
21253 "Sandeon Consolidation Corp",
21258 "AB Drivers Limited",
21259 "Hammer Group Inc",
21260 "Arts & Crafts Inc",
21261 "A.D. Importing Company Inc",
21264 "Avery Software Co",
21265 "Airline Maintenance Co",
21267 "Anytime Air Support Inc",
21268 "Coolview Net Ltd",
21269 "Rubble Group Inc",
21270 "B.C. Investing International",
21271 "Sunyvale Reporting Ltd",
21272 "B.H. Edwards Inc",
21273 "Insight Marketing Inc",
21276 "Calm Sailing Inc",
21277 "Chandler Logistics Inc",
21278 "Cloud Cover Trust",
21279 "Complete Holding",
21280 "Constrata Trust LLC",
21281 "Cumberland Trails Inc",
21282 "DD Furniture Inc",
21284 "Hollywood Diner Ltd",
21285 "Davenport Investing",
21286 "Draft Diversified Energy Inc",
21287 "First National S/B",
21288 "Gifted Holdings AG",
21289 "Green Tractor Group Limited",
21291 "Income Free Investing LP",
21292 "International Art Inc",
21293 "Ink Conglomerate Inc",
21294 "J.K.M. Corp (HA)",
21297 "JJ Resources Inc",
21298 "Jungle Systems Inc",
21299 "Kringle Bell Inc".
21301 "Kaos Trading Ltd",
21302 "Kings Royalty Trust",
21303 "King Software Inc",
21305 "Lexington Shores Corp",
21306 "Max Holdings Ltd",
21307 "Mississippi Bank Group",
21308 "MMM Mortuary Corp",
21309 "MTM Investment Bank F S B",
21310 "Nimble Technologies Inc",
21311 "NW Bridge Construction",
21314 "Overhead & Underfoot Ltd.",
21316 "Powder Suppliers",
21317 "Pullman Cart Company",
21320 "Rhyme & Reason Inc",
21323 "RRR Advertising Inc.",
21324 "S Cane Sweeteners Ltd",
21326 "Slender Broadband Inc",
21327 "Smallville Resources Inc",
21328 "South Sea Plumbing Products",
21330 "Spend Thrift Inc",
21331 "Spindle Broadcast Corp.",
21332 "Start Over Trust",
21333 "Super Star Holdings Inc",
21335 "T-Cat Media Group Inc",
21339 "Trait Institute Inc",
21340 "Tri-State Medical Corp",
21342 "EEE Endowments LTD",
21343 "Underwater Mining Inc.",
21345 "Waverly Trading House",
21348 "XY&Z Funding Inc",
21351 $sugar_demodata['street_address_array'] = array(
21352 "123 Anywhere Street",
21356 "67321 West Siam St.",
21357 "48920 San Carlos Ave",
21358 "777 West Filmore Ln",
21360 "111 Silicon Valley Road",
21361 "321 University Ave.",
21364 $sugar_demodata['city_array'] = array(
21384 $sugar_demodata['case_seed_names'] = array(
21385 'Having trouble adding new items',
21386 'System not responding',
21387 'Need assistance with large customization',
21388 'Need to purchase additional licenses',
21389 'Warning message when using the wrong browser'
21393 $sugar_demodata['bug_seed_names'] = array(
21394 'Error occurs while running count query',
21395 'Warning is displayed in file after exporting',
21396 'Fatal error during installation',
21397 'Broken image appears in home page',
21398 'Syntax error appears when running old reports'
21401 $sugar_demodata['note_seed_names_and_Descriptions'] = array(
21402 array('More Account Information','This account could turn into a 3,000-user opportunity.'),
21403 array('Call Information','The initial sales call went well. Will follow up with contact in 3 days.'),
21404 array('Met at SugarCon 2010','Contact expressed interest in becoming a partner.'),
21405 array('Attended CRM Exceleration Event in Asia','Contact\'s event registration fee was comped.')
21408 $sugar_demodata['call_seed_data_names'] = array(
21409 'Get more information on the proposed deal',
21411 'Bad time, will call back',
21412 'Discuss review process'
21416 $sugar_demodata['titles'] = array(
21420 "Director Operations",
21424 "Senior Product Manager"
21429 $sugar_demodata['task_seed_data_names'] = array(
21430 'Assemble catalogs',
21431 'Make travel arrangements',
21435 'Send a follow-up letter',
21439 'Call to schedule meeting',
21440 'Setup evaluation',
21441 'Get demo feedback',
21442 'Arrange introduction',
21443 'Escalate support request',
21444 'Close out support request',
21446 'Arrange reference call',
21447 'Schedule training',
21448 'Send local user group information',
21449 'Add to mailing list',
21451 $sugar_demodata['meeting_seed_data_descriptions'] = 'Meeting to discuss project plan and hash out the details of implementation';
21454 $sugar_demodata['meeting_seed_data_names'] = array(
21455 'Follow-up on proposal',
21456 'Initial discussion',
21460 'Introduce all players',
21462 $sugar_demodata['meeting_seed_data_descriptions'] = '';
21465 $sugar_demodata['email_seed_data_subjects'] = array(
21466 'Follow-up on proposal',
21467 'Initial discussion',
21471 'Introduce all players',
21473 $sugar_demodata['email_seed_data_descriptions'] = 'Meeting to discuss project plan and hash out the details of implementation';
21476 $sugar_demodata['primary_address_state'] = 'CA';
21477 $sugar_demodata['billing_address_state']['east'] = 'NY';
21478 $sugar_demodata['billing_address_state']['west'] = 'CA';
21479 $sugar_demodata['primary_address_country'] = 'USA';
21483 $sugar_demodata['manufacturer_seed_data_names'] = array(
21489 $sugar_demodata['shipper_seed_data_names'] = array(
21494 //productcategories
21495 $sugar_demodata['category_ext_name'] = ' Widgets';
21496 $sugar_demodata['product_ext_name'] = ' Gadget';
21498 $sugar_demodata['productcategory_seed_data_names'] = array(
21501 'Stationary Device',
21506 $sugar_demodata['producttype_seed_data_names']= array(
21513 $sugar_demodata['taxrate_seed_data'][] = array(
21514 'name' => '8.25 - Cupertino, CA',
21518 $sugar_demodata['currency_seed_data'][] = array(
21520 'conversion_rate' => 0.9,
21521 'iso4217' => 'EUR',
21526 $sugar_demodata['producttemplate_seed_data'][] = array(
21527 'name' => 'TK 1000 Desktop',
21528 'tax_class' => 'Taxable',
21529 'cost_price' => 500.00,
21530 'cost_usdollar' => 500.00,
21531 'list_price' => 800.00,
21532 'list_usdollar' => 800.00,
21533 'discount_price' => 800.00,
21534 'discount_usdollar' => 800.00,
21535 'pricing_formula' => 'IsList',
21536 'mft_part_num' => 'XYZ7890122222',
21537 'pricing_factor' => '1',
21538 'status' => 'Available',
21540 'date_available' => '2009-10-15',
21541 'qty_in_stock' => '72',
21544 $sugar_demodata['producttemplate_seed_data'][] = array(
21545 'name' => 'TK 1000 Desktop',
21546 'tax_class' => 'Taxable',
21547 'cost_price' => 600.00,
21548 'cost_usdollar' => 600.00,
21549 'list_price' => 900.00,
21550 'list_usdollar' => 900.00,
21551 'discount_price' => 900.00,
21552 'discount_usdollar' => 900.00,
21553 'pricing_formula' => 'IsList',
21554 'mft_part_num' => 'XYZ7890123456',
21555 'pricing_factor' => '1',
21556 'status' => 'Available',
21558 'date_available' => '2009-10-15',
21559 'qty_in_stock' => '65',
21562 $sugar_demodata['producttemplate_seed_data'][] = array(
21563 'name' => 'TK m30 Desktop',
21564 'tax_class' => 'Taxable',
21565 'cost_price' => 1300.00,
21566 'cost_usdollar' => 1300.00,
21567 'list_price' => 1700.00,
21568 'list_usdollar' => 1700.00,
21569 'discount_price' => 1625.00,
21570 'discount_usdollar' => 1625.00,
21571 'pricing_formula' => 'ProfitMargin',
21572 'mft_part_num' => 'ABCD123456890',
21573 'pricing_factor' => '20',
21574 'status' => 'Available',
21576 'date_available' => '2009-10-15',
21577 'qty_in_stock' => '12',
21580 $sugar_demodata['producttemplate_seed_data'][] = array(
21581 'name' => 'Reflective Mirror Widget',
21582 'tax_class' => 'Taxable',
21583 'cost_price' => 200.00,
21584 'cost_usdollar' => 200.00,
21585 'list_price' => 325.00,
21586 'list_usdollar' => 325.00,
21587 'discount_price' => 266.50,
21588 'discount_usdollar' => 266.50,
21589 'pricing_formula' => 'PercentageDiscount',
21590 'mft_part_num' => '2.0',
21591 'pricing_factor' => '20',
21592 'status' => 'Available',
21594 'date_available' => '2009-10-15',
21595 'qty_in_stock' => '65',
21599 $sugar_demodata['emailtemplates_seed_data'][] = array(
21600 'name' => 'Demo data email',
21601 'subject' => 'New demo data information',
21602 'description' => 'This template is used when the System Administrator sends a new password to a user.',
21603 'body' => '<div><table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width="550" align=\"\"\"center\"\"\"><tbody><tr><td colspan=\"2\"><p>Here is your account username and temporary password:</p><p>Username : $contact_user_user_name </p><p>Password : $contact_user_user_hash </p><br><p>'.$GLOBALS['sugar_config']['site_url'].'/index.php</p><br><p>After you log in using the above password, you may be required to reset the password to one of your own choice.</p> </td> </tr><tr><td colspan=\"2\"></td> </tr> </tbody></table> </div>',
21606 Here is your account username and temporary password:
21607 Username : $contact_user_user_name
21608 Password : $contact_user_user_hash
21610 '.$GLOBALS['sugar_config']['site_url'].'/index.php
21612 After you log in using the above password, you may be required to reset the password to one of your own choice.',
21616 $sugar_demodata['contract_seed_data'][] = array(
21617 'name' => 'IT Tech Support for UK Datacenter',
21618 'reference_code' => 'EMP-9802',
21619 'total_contract_value' => '500600.01',
21620 'start_date' => '2010-05-15',
21621 'end_date' => '2020-05-15',
21622 'company_signed_date' => '2010-03-15',
21623 'customer_signed_date' => '2010-03-16',
21624 'description' => 'This is a sub-contract for a very large project.',
21627 $sugar_demodata['contract_seed_data'][] = array(
21628 'name' => 'Ion Engines for Auto Plant',
21629 'reference_code' => 'EMP-7277',
21630 'total_contract_value' => '333444.34',
21631 'start_date' => '2010-05-15',
21632 'end_date' => '2020-05-15',
21633 'company_signed_date' => '2010-03-15',
21634 'customer_signed_date' => '2010-03-16',
21635 'description' => 'In competition with Sienar Fleet Systems for this one.',
21638 $sugar_demodata['project_seed_data']['audit'] = array(
21639 'name' => 'Create new plan for the annual audit',
21640 'description' => 'The annual audit is coming up next month.',
21641 'estimated_start_date' => '2010-11-01',
21642 'estimated_end_date' => '2010-12-31',
21643 'status' => 'Draft',
21644 'priority' => 'medium',
21647 $sugar_demodata['project_seed_data']['audit']['project_tasks'][] = array(
21648 'name' => 'Communicate with internal stakeholders',
21649 'date_start' => '2010/11/1',
21650 'date_finish' => '2010/11/8',
21651 'description' => 'Schedule individual meetings with Will, Max, and Sarah.',
21653 'duration_unit' => 'Days',
21654 'percent_complete' => 100,
21657 $sugar_demodata['project_seed_data']['audit']['project_tasks'][] = array(
21658 'name' => 'Create draft of the plan',
21659 'date_start' => '2010/11/5',
21660 'date_finish' => '2010/11/20',
21661 'description' => 'Start new plan document, including all of the information from the initial discussion meetings.',
21662 'duration' => '12',
21663 'duration_unit' => 'Days',
21664 'percent_complete' => 38,
21667 $sugar_demodata['project_seed_data']['audit']['project_tasks'][] = array(
21668 'name' => 'Perform field studies to collect data',
21669 'date_start' => '2010/11/5',
21670 'date_finish' => '2010/11/13',
21671 'description' => 'Obtain approval from all stakeholders of the plan.',
21672 'duration' => '17',
21673 'duration_unit' => 'Days',
21674 'percent_complete' => 75,
21677 $sugar_demodata['project_seed_data']['audit']['project_tasks'][] = array(
21678 'name' => 'Update draft of the plan',
21679 'date_start' => '2010/11/12',
21680 'date_finish' => '2010/11/19',
21681 'description' => 'Schedule a meeting with the heads of the business units to review the plan.',
21683 'duration_unit' => 'Days',
21684 'percent_complete' => 0,
21687 $sugar_demodata['project_seed_data']['audit']['project_tasks'][] = array(
21688 'name' => 'Gather data from meetings',
21689 'date_start' => '2010/11/20',
21690 'date_finish' => '2010/11/20',
21691 'description' => 'Need to organize the data and create charts to represent the data.',
21693 'duration_unit' => 'Days',
21694 'percent_complete' => 0,
21697 //BEGIN Quotes demo data
21698 $sugar_demodata['quotes_seed_data']['quotes'][0] = array(
21699 'name' => 'Computers for [account name]',
21700 'quote_stage' => 'Draft',
21701 'date_quote_expected_closed' => '04/30/2012',
21702 'description' => '',
21703 'purcahse_order_num' => '6011842',
21704 'payment_terms' => 'Net 30',
21706 'bundle_data' => array(
21708 'bundle_name' => 'Computers',
21709 'bundle_stage' => 'Draft',
21710 'comment' => 'TK Desktop Computers',
21711 'products' => array (
21712 1 => array('name'=>'TK 1000 Desktop', 'quantity'=>'1'),
21713 2 => array('name'=>'TK m30 Desktop', 'quantity'=>'2'),
21720 $sugar_demodata['quotes_seed_data']['quotes'][1] = array(
21721 'name' => 'Mirrors for [account name]',
21722 'quote_stage' => 'Negotiation',
21723 'date_quote_expected_closed' => '04/30/2012',
21724 'description' => '',
21725 'purcahse_order_num' => '3940021',
21726 'payment_terms' => 'Net 15',
21729 'bundle_data' => array(
21731 'bundle_name' => 'Mirrors',
21732 'bundle_stage' => 'Draft',
21733 'comment' => 'Reflective Mirrors',
21734 'products' => array (
21735 1 => array('name'=>'Reflective Mirror Widget', 'quantity'=>'2'),
21740 //END Quotes demo data