34 lines
1.2 KiB
PHP
34 lines
1.2 KiB
PHP
<?php
|
|
/*********************************************************************************
|
|
** The contents of this file are subject to the vtiger CRM Public License Version 1.0
|
|
* ("License"); You may not use this file except in compliance with the License
|
|
* The Original Code is: vtiger CRM Open Source
|
|
* The Initial Developer of the Original Code is vtiger.
|
|
* Portions created by vtiger are Copyright (C) vtiger.
|
|
* All Rights Reserved.
|
|
*
|
|
********************************************************************************/
|
|
require_once('include/utils/utils.php');
|
|
|
|
$inv_type='Inventory';
|
|
$inv_tandc=from_html($_REQUEST['inventory_tandc']);
|
|
|
|
$sql="select * from vtiger_inventory_tandc where type=?";
|
|
$result = $adb->pquery($sql, array($inv_type));
|
|
$inv_id = $adb->query_result($result,0,'id');
|
|
if($inv_id == '')
|
|
{
|
|
$inv_id=$adb->getUniqueID('vtiger_inventory_tandc');
|
|
$sql="insert into vtiger_inventory_tandc values(?,?,?)";
|
|
$params = array($inv_id, $inv_type, $inv_tandc);
|
|
}
|
|
else
|
|
{
|
|
$sql="update vtiger_inventory_tandc set type = ?, tandc = ? where id = ?";
|
|
$params = array($inv_type, $inv_tandc, $inv_id);
|
|
}
|
|
$adb->pquery($sql, $params);
|
|
|
|
header("Location: index.php?module=Settings&action=OrganizationTermsandConditions&parenttab=Settings");
|
|
?>
|