salesagility_SuiteCRM/install/seed_data/quotes_SeedData.php

<?php
if (!defined('sugarEntry') || !sugarEntry) {
    die('Not A Valid Entry Point');
}
/**
 *
 * SugarCRM Community Edition is a customer relationship management program developed by
 * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
 *
 * SuiteCRM is an extension to SugarCRM Community Edition developed by SalesAgility Ltd.
 * Copyright (C) 2011 - 2018 SalesAgility Ltd.
 *
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU Affero General Public License version 3 as published by the
 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
 * details.
 *
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 *
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 *
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 *
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
 * reasonably feasible for technical reasons, the Appropriate Legal Notices must
 * display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
 */



require_once('modules/Quotes/Quote.php');
require_once('modules/ProductBundleNotes/ProductBundleNote.php');
require_once('modules/Products/Product.php');

global $current_user;
global $sugar_demodata;

if (!empty($sugar_demodata['quotes_seed_data']['quotes'])) {
    foreach ($sugar_demodata['quotes_seed_data']['quotes'] as $key=>$quote) {
        $focus = new Quote();
        $focus->id = create_guid();
        $focus->new_with_id = true;
        $focus->name = $quote['name'];
        $focus->description = !empty($quote['description']) ? $quote['description'] : '';
        $focus->quote_stage = !empty($quote['quote_stage']) ? $quote['quote_stage'] : '';
        $focus->date_quote_expected_closed = $quote['date_quote_expected_closed'];
        if (!empty($quote['purcahse_order_num'])) {
            $focus->purchase_order_num = $quote['purcahse_order_num'];
        }

        if (!empty($quote['original_po_date'])) {
            $focus->original_po_date = $quote['original_po_date'];
        }

        if (!empty($quote['payment_terms'])) {
            $focus->payment_terms = $quote['payment_terms'];
        }

        $focus->quote_type = 'Quotes';
        $focus->calc_grand_total = 1;
        $focus->show_line_nums = 1;
        $focus->team_id = $current_user->team_id;
        $focus->team_set_id = $current_user->team_set_id;

        //Set random account and contact ids
        $sql = 'SELECT * FROM accounts WHERE deleted = 0';
        $result = DBManagerFactory::getInstance()->limitQuery($sql, 0, 10, true, "Error retrieving Accounts");
        while ($row = DBManagerFactory::getInstance()->fetchByAssoc($result)) {
            $focus->billing_account_id = $row['id'];
            $focus->name = str_replace('[account name]', $row['name'], (string) $focus->name);
            $focus->billing_address_street = $row['billing_address_street'];
            $focus->billing_address_city = $row['billing_address_city'];
            $focus->billing_address_state = $row['billing_address_state'];
            $focus->billing_address_country = $row['billing_address_country'];
            $focus->billing_address_postalcode = $row['billing_address_postalcode'];
            $focus->shipping_address_street = $row['shipping_address_street'];
            $focus->shipping_address_city = $row['shipping_address_city'];
            $focus->shipping_address_state = $row['shipping_address_state'];
            $focus->shipping_address_country = $row['shipping_address_country'];
            $focus->shipping_address_postalcode = $row['shipping_address_postalcode'];
            break;
        }

        foreach ($quote['bundle_data'] as $bundle_key=>$bundle) {
            $pb = new ProductBundle();
            $pb->team_id = $focus->team_set_id;
            $pb->team_set_id = $focus->team_set_id;
            $pb->currency_id = $focus->currency_id;
            $pb->bundle_stage = $bundle['bundle_stage'];
            $pb->name = $bundle['bundle_name'];

            $product_bundle_id = $pb->save();

            //Save the products
            foreach ($bundle['products'] as $product_key=>$products) {
                $sql = 'SELECT * FROM product_templates WHERE name = \'' . $products['name'] . '\'';
                $result = DBManagerFactory::getInstance()->query($sql);
                while ($row = DBManagerFactory::getInstance()->fetchByAssoc($result)) {
                    $product = new Product();

                    foreach ($product->column_fields as $field) {
                        if (isset($row[$field])) {
                            $product->$field = $row[$field];
                        }
                    }

                    $product->name = $products['name'];
                    $product->id = create_guid();
                    $product->new_with_id = true;
                    $product->quantity = $products['quantity'];
                    $product->currency_id = $focus->currency_id;
                    $product->team_id = $focus->team_id;
                    $product->team_set_id = $focus->team_set_id;
                    $product->quote_id = $focus->id;
                    $product->account_id = $focus->billing_account_id;
                    $product->status = 'Quotes';

                    if ($focus->quote_stage == 'Closed Accepted') {
                        $product->status='Orders';
                    }

                    $pb->subtotal += ($product->list_price * $product->quantity);
                    $pb->deal_tot += ($product->list_price * $product->quantity);
                    $pb->new_sub += ($product->list_price * $product->quantity);
                    $pb->total += ($product->list_price * $product->quantity);

                    $product_id = $product->save();
                    $pb->set_productbundle_product_relationship($product_id, $product_key, $product_bundle_id);
                    break;
                } //while
            } //foreach

            $pb->tax = 0;
            $pb->shipping = 0;
            $pb->save();

            //Save any product bundle comment
            if (isset($bundle['comment'])) {
                $product_bundle_note = new ProductBundleNote();
                $product_bundle_note->description = $bundle['comment'];
                $product_bundle_note->save();
                $pb->set_product_bundle_note_relationship($bundle_key, $product_bundle_note->id, $product_bundle_id);
            }

            $pb->set_productbundle_quote_relationship($focus->id, $product_bundle_id, $bundle_key);

            $focus->tax += $pb->tax;
            $focus->shipping += $pb->shipping;
            $focus->subtotal += $pb->subtotal;
            $focus->deal_tot += $pb->deal_tot;
            $focus->new_sub += $pb->new_sub;
            $focus->total += $pb->total;
        } //foreach

        //Save the quote
        $focus->save();
    } //foreach
}