mirror of
https://github.com/SuiteCRM/SuiteCRM-Core.git
synced 2026-07-26 22:39:11 +08:00
131 lines
5.7 KiB
PHP
Executable file
131 lines
5.7 KiB
PHP
Executable file
<?php
|
|
/**
|
|
* SuiteCRM is a customer relationship management program developed by SuiteCRM Ltd.
|
|
* Copyright (C) 2011 - 2025 SuiteCRM 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 SUITECRM, SUITECRM 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/>.
|
|
*
|
|
* 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
|
|
* "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 "Supercharged by SuiteCRM".
|
|
*/
|
|
|
|
if (!(ACLController::checkAccess('AOS_Contracts', 'edit', true))) {
|
|
ACLController::displayNoAccess();
|
|
die;
|
|
}
|
|
|
|
require_once('modules/AOS_Quotes/AOS_Quotes.php');
|
|
require_once('modules/AOS_Contracts/AOS_Contracts.php');
|
|
|
|
//Setting values in Quotes
|
|
$quote = BeanFactory::newBean('AOS_Quotes');
|
|
$quote->retrieve($_REQUEST['record']);
|
|
|
|
//Setting Contract Values
|
|
$contract = BeanFactory::newBean('AOS_Contracts');
|
|
$contract->name = $quote->name;
|
|
$contract->assigned_user_id = $quote->assigned_user_id;
|
|
$contract->total_contract_value = format_number($quote->total_amount);
|
|
$contract->contract_account_id = $quote->billing_account_id;
|
|
$contract->contact_id = $quote->billing_contact_id;
|
|
$contract->opportunity_id = $quote->opportunity_id;
|
|
|
|
$contract->total_amt = $quote->total_amt;
|
|
$contract->subtotal_amount = $quote->subtotal_amount;
|
|
$contract->discount_amount = $quote->discount_amount;
|
|
$contract->tax_amount = $quote->tax_amount;
|
|
$contract->shipping_amount = $quote->shipping_amount;
|
|
$contract->shipping_tax = $quote->shipping_tax;
|
|
$contract->shipping_tax_amt = $quote->shipping_tax_amt;
|
|
$contract->total_amount = $quote->total_amount;
|
|
$contract->currency_id = $quote->currency_id;
|
|
|
|
$contract->save();
|
|
|
|
$group_id_map = array();
|
|
|
|
//Setting Group Line Items
|
|
$sql = "SELECT * FROM aos_line_item_groups WHERE parent_type = 'AOS_Quotes' AND parent_id = '".$quote->id."' AND deleted = 0";
|
|
|
|
$result = $this->bean->db->query($sql);
|
|
while ($row = $this->bean->db->fetchByAssoc($result)) {
|
|
$old_id = $row['id'];
|
|
$row['id'] = '';
|
|
$row['parent_id'] = $contract->id;
|
|
$row['parent_type'] = 'AOS_Contracts';
|
|
if ($row['total_amt'] != null) {
|
|
$row['total_amt'] = format_number($row['total_amt']);
|
|
}
|
|
if ($row['discount_amount'] != null) {
|
|
$row['discount_amount'] = format_number($row['discount_amount']);
|
|
}
|
|
if ($row['subtotal_amount'] != null) {
|
|
$row['subtotal_amount'] = format_number($row['subtotal_amount']);
|
|
}
|
|
if ($row['tax_amount'] != null) {
|
|
$row['tax_amount'] = format_number($row['tax_amount']);
|
|
}
|
|
if ($row['subtotal_tax_amount'] != null) {
|
|
$row['subtotal_tax_amount'] = format_number($row['subtotal_tax_amount']);
|
|
}
|
|
if ($row['total_amount'] != null) {
|
|
$row['total_amount'] = format_number($row['total_amount']);
|
|
}
|
|
$group_contract = BeanFactory::newBean('AOS_Line_Item_Groups');
|
|
$group_contract->populateFromRow($row);
|
|
$group_contract->save();
|
|
$group_id_map[$old_id] = $group_contract->id;
|
|
}
|
|
|
|
|
|
//Setting Line Items
|
|
$sql = "SELECT * FROM aos_products_quotes WHERE parent_type = 'AOS_Quotes' AND parent_id = '".$quote->id."' AND deleted = 0";
|
|
$result = $this->bean->db->query($sql);
|
|
while ($row = $this->bean->db->fetchByAssoc($result)) {
|
|
$row['id'] = '';
|
|
$row['parent_id'] = $contract->id;
|
|
$row['parent_type'] = 'AOS_Contracts';
|
|
if ($row['product_cost_price'] != null) {
|
|
$row['product_cost_price'] = format_number($row['product_cost_price']);
|
|
}
|
|
$row['product_list_price'] = format_number($row['product_list_price']);
|
|
if ($row['product_discount'] != null) {
|
|
$row['product_discount'] = format_number($row['product_discount']);
|
|
$row['product_discount_amount'] = format_number($row['product_discount_amount']);
|
|
}
|
|
$row['product_unit_price'] = format_number($row['product_unit_price']);
|
|
$row['vat_amt'] = format_number($row['vat_amt']);
|
|
$row['product_total_price'] = format_number($row['product_total_price']);
|
|
$row['product_qty'] = format_number($row['product_qty']);
|
|
$row['group_id'] = $group_id_map[$row['group_id']];
|
|
|
|
$prod_contract = BeanFactory::newBean('AOS_Products_Quotes');
|
|
$prod_contract->populateFromRow($row);
|
|
$prod_contract->save();
|
|
}
|
|
|
|
//Setting contract quote relationship
|
|
require_once('modules/Relationships/Relationship.php');
|
|
$key = Relationship::retrieve_by_modules('AOS_Quotes', 'AOS_Contracts', $GLOBALS['db']);
|
|
if (!empty($key)) {
|
|
$quote->load_relationship($key);
|
|
$quote->$key->add($contract->id);
|
|
}
|
|
ob_clean();
|
|
header('Location: index.php?module=AOS_Contracts&action=EditView&record='.$contract->id);
|
