253 lines
11 KiB
PHP
253 lines
11 KiB
PHP
<?php
|
|
/*********************************************************************************
|
|
* The contents of this file are subject to the SugarCRM Public License Version 1.1.2
|
|
* ("License"); You may not use this file except in compliance with the
|
|
* License. You may obtain a copy of the License at http://www.sugarcrm.com/SPL
|
|
* Software distributed under the License is distributed on an "AS IS" basis,
|
|
* WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
|
|
* the specific language governing rights and limitations under the License.
|
|
* The Original Code is: SugarCRM Open Source
|
|
* The Initial Developer of the Original Code is SugarCRM, Inc.
|
|
* Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.;
|
|
* All Rights Reserved.
|
|
* Contributor(s): ______________________________________.
|
|
********************************************************************************/
|
|
/*********************************************************************************
|
|
* $Header$
|
|
* Description: TODO To be written.
|
|
* Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
|
|
* All Rights Reserved.
|
|
* Contributor(s): ______________________________________..
|
|
********************************************************************************/
|
|
|
|
require_once('Smarty_setup.php');
|
|
require_once('data/Tracker.php');
|
|
require_once('include/CustomFieldUtil.php');
|
|
require_once('include/utils/utils.php');
|
|
|
|
global $app_strings,$mod_strings,$log,$theme,$currentModule;
|
|
|
|
$focus = CRMEntity::getInstance($currentModule);
|
|
$smarty = new vtigerCRM_Smarty();
|
|
//added to fix the issue4600
|
|
$searchurl = getBasic_Advance_SearchURL();
|
|
$smarty->assign("SEARCH", $searchurl);
|
|
//4600 ends
|
|
|
|
global $current_user;
|
|
$currencyid=fetchCurrency($current_user->id);
|
|
$rate_symbol = getCurrencySymbolandCRate($currencyid);
|
|
$rate = $rate_symbol['rate'];
|
|
if(isset($_REQUEST['record']) && $_REQUEST['record'] != '')
|
|
{
|
|
$focus->id = $_REQUEST['record'];
|
|
$focus->mode = 'edit';
|
|
$focus->retrieve_entity_info($_REQUEST['record'],"PurchaseOrder");
|
|
$focus->name=$focus->column_fields['subject'];
|
|
}
|
|
if(isset($_REQUEST['isDuplicate']) && $_REQUEST['isDuplicate'] == 'true') {
|
|
$smarty->assign("DUPLICATE_FROM", $focus->id);
|
|
$PO_associated_prod = getAssociatedProducts($currentModule,$focus);
|
|
$inventory_cur_info = getInventoryCurrencyInfo($currentModule, $focus->id);
|
|
$currencyid = $inventory_cur_info['currency_id'];
|
|
$focus->id = "";
|
|
$focus->mode = '';
|
|
}
|
|
if(empty($_REQUEST['record']) && $focus->mode != 'edit'){
|
|
setObjectValuesFromRequest($focus);
|
|
}
|
|
if(isset($_REQUEST['product_id']) && $_REQUEST['product_id'] !='')
|
|
{
|
|
$focus->column_fields['product_id'] = $_REQUEST['product_id'];
|
|
$log->debug("Purchase Order EditView: Product Id from the request is ".$_REQUEST['product_id']);
|
|
$associated_prod = getAssociatedProducts("Products",$focus,$focus->column_fields['product_id']);
|
|
for ($i=1; $i<=count($associated_prod);$i++) {
|
|
$associated_prod_id = $associated_prod[$i]['hdnProductId'.$i];
|
|
$associated_prod_prices = getPricesForProducts($currencyid,array($associated_prod_id),'Products');
|
|
$associated_prod[$i]['listPrice'.$i] = $associated_prod_prices[$associated_prod_id];
|
|
}
|
|
$smarty->assign("ASSOCIATEDPRODUCTS", $associated_prod);
|
|
$smarty->assign("AVAILABLE_PRODUCTS", 'true');
|
|
}
|
|
if(!empty($_REQUEST['parent_id']) && !empty($_REQUEST['return_module']))
|
|
{
|
|
if ($_REQUEST['return_module'] == 'Services') {
|
|
$focus->column_fields['product_id'] = vtlib_purify($_REQUEST['parent_id']);
|
|
$log->debug("Service Id from the request is ". vtlib_purify($_REQUEST['parent_id']));
|
|
$associated_prod = getAssociatedProducts("Services",$focus,$focus->column_fields['product_id']);
|
|
for ($i=1; $i<=count($associated_prod);$i++) {
|
|
$associated_prod_id = $associated_prod[$i]['hdnProductId'.$i];
|
|
$associated_prod_prices = getPricesForProducts($currencyid,array($associated_prod_id),'Services');
|
|
$associated_prod[$i]['listPrice'.$i] = $associated_prod_prices[$associated_prod_id];
|
|
}
|
|
$smarty->assign("ASSOCIATEDPRODUCTS", $associated_prod);
|
|
$smarty->assign("AVAILABLE_PRODUCTS", 'true');
|
|
}
|
|
}
|
|
|
|
// Get vtiger_vendor address if vtiger_vendorid is given
|
|
if(isset($_REQUEST['vendor_id']) && $_REQUEST['vendor_id']!='' && $_REQUEST['record']==''){
|
|
require_once('modules/Vendors/Vendors.php');
|
|
$vend_focus = new Vendors();
|
|
|
|
$vend_focus->retrieve_entity_info($_REQUEST['vendor_id'],"Vendors");
|
|
$focus->column_fields['bill_city']=$vend_focus->column_fields['city'];
|
|
$focus->column_fields['ship_city']=$vend_focus->column_fields['city'];
|
|
$focus->column_fields['bill_street']=$vend_focus->column_fields['street'];
|
|
$focus->column_fields['ship_street']=$vend_focus->column_fields['street'];
|
|
$focus->column_fields['bill_state']=$vend_focus->column_fields['state'];
|
|
$focus->column_fields['ship_state']=$vend_focus->column_fields['state'];
|
|
$focus->column_fields['bill_code']=$vend_focus->column_fields['postalcode'];
|
|
$focus->column_fields['ship_code']=$vend_focus->column_fields['postalcode'];
|
|
$focus->column_fields['bill_country']=$vend_focus->column_fields['country'];
|
|
$focus->column_fields['ship_country']=$vend_focus->column_fields['country'];
|
|
$focus->column_fields['bill_pobox']=$vend_focus->column_fields['pobox'];
|
|
$focus->column_fields['ship_pobox']=$vend_focus->column_fields['pobox'];
|
|
}
|
|
$theme_path="themes/".$theme."/";
|
|
$image_path=$theme_path."images/";
|
|
|
|
$disp_view = getView($focus->mode);
|
|
$mode = $focus->mode;
|
|
$smarty->assign("BLOCKS",getBlocks($currentModule,$disp_view,$mode,$focus->column_fields));
|
|
|
|
$smarty->assign("OP_MODE",$disp_view);
|
|
|
|
$smarty->assign("MODULE",$currentModule);
|
|
$smarty->assign("SINGLE_MOD",'PurchaseOrder');
|
|
$category = getParentTab();
|
|
$smarty->assign("CATEGORY",$category);
|
|
|
|
|
|
$smarty->assign("MOD", $mod_strings);
|
|
$smarty->assign("APP", $app_strings);
|
|
|
|
$log->info("Order view");
|
|
|
|
if (isset($focus->name)) $smarty->assign("NAME", $focus->name);
|
|
else $smarty->assign("NAME", "");
|
|
|
|
if($focus->mode == 'edit')
|
|
{
|
|
$smarty->assign("UPDATEINFO",updateInfo($focus->id));
|
|
$associated_prod = getAssociatedProducts("PurchaseOrder",$focus);
|
|
$smarty->assign("ASSOCIATEDPRODUCTS", $associated_prod);
|
|
$smarty->assign("MODE", $focus->mode);
|
|
}
|
|
elseif(isset($_REQUEST['isDuplicate']) && $_REQUEST['isDuplicate'] == 'true')
|
|
{
|
|
$smarty->assign("ASSOCIATEDPRODUCTS", $PO_associated_prod);
|
|
$smarty->assign("AVAILABLE_PRODUCTS", 'true');
|
|
$smarty->assign("MODE", $focus->mode);
|
|
|
|
}
|
|
elseif((isset($_REQUEST['product_id']) && $_REQUEST['product_id'] != '')) {
|
|
$smarty->assign("ASSOCIATEDPRODUCTS", $associated_prod);
|
|
$InvTotal = getInventoryTotal($_REQUEST['return_module'],$_REQUEST['return_id']);
|
|
$smarty->assign("MODE", $focus->mode);
|
|
|
|
//this is to display the Product Details in first row when we create new PO from Product relatedlist
|
|
if($_REQUEST['return_module'] == 'Products')
|
|
{
|
|
$smarty->assign("PRODUCT_ID",vtlib_purify($_REQUEST['product_id']));
|
|
$smarty->assign("PRODUCT_NAME",getProductName($_REQUEST['product_id']));
|
|
$smarty->assign("UNIT_PRICE",vtlib_purify($_REQUEST['product_id']));
|
|
$smarty->assign("QTY_IN_STOCK",getPrdQtyInStck($_REQUEST['product_id']));
|
|
$smarty->assign("VAT_TAX",getProductTaxPercentage("VAT",$_REQUEST['product_id']));
|
|
$smarty->assign("SALES_TAX",getProductTaxPercentage("Sales",$_REQUEST['product_id']));
|
|
$smarty->assign("SERVICE_TAX",getProductTaxPercentage("Service",$_REQUEST['product_id']));
|
|
}
|
|
}
|
|
|
|
|
|
if(isset($cust_fld))
|
|
{
|
|
$smarty->assign("CUSTOMFIELD", $cust_fld);
|
|
}
|
|
|
|
|
|
|
|
if(isset($_REQUEST['return_module'])) $smarty->assign("RETURN_MODULE", vtlib_purify($_REQUEST['return_module']));
|
|
else $smarty->assign("RETURN_MODULE","PurchaseOrder");
|
|
if(isset($_REQUEST['return_action'])) $smarty->assign("RETURN_ACTION", vtlib_purify($_REQUEST['return_action']));
|
|
if(isset($_REQUEST['return_id'])) $smarty->assign("RETURN_ID", vtlib_purify($_REQUEST['return_id']));
|
|
if (isset($_REQUEST['return_viewname'])) $smarty->assign("RETURN_VIEWNAME", vtlib_purify($_REQUEST['return_viewname']));
|
|
$smarty->assign("THEME", $theme);
|
|
$smarty->assign("IMAGE_PATH", $image_path);
|
|
$smarty->assign("MODULE","PurchaseOrder");
|
|
$smarty->assign("PRINT_URL", "phprint.php?jt=".session_id().$GLOBALS['request_string']);
|
|
$smarty->assign("ID", $focus->id);
|
|
|
|
|
|
$smarty->assign("CALENDAR_LANG", $app_strings['LBL_JSCALENDAR_LANG']);
|
|
$smarty->assign("CALENDAR_DATEFORMAT", parse_calendardate($app_strings['NTC_DATE_FORMAT']));
|
|
|
|
//if create PO, get all available product taxes and shipping & Handling taxes
|
|
if($focus->mode != 'edit')
|
|
{
|
|
$tax_details = getAllTaxes('available');
|
|
$sh_tax_details = getAllTaxes('available','sh');
|
|
}
|
|
else
|
|
{
|
|
$tax_details = getAllTaxes('available','',$focus->mode,$focus->id);
|
|
$sh_tax_details = getAllTaxes('available','sh','edit',$focus->id);
|
|
}
|
|
$smarty->assign("GROUP_TAXES",$tax_details);
|
|
$smarty->assign("SH_TAXES",$sh_tax_details);
|
|
|
|
|
|
|
|
$tabid = getTabid("PurchaseOrder");
|
|
$validationData = getDBValidationData($focus->tab_name,$tabid);
|
|
$data = split_validationdataArray($validationData);
|
|
|
|
$smarty->assign("VALIDATION_DATA_FIELDNAME",$data['fieldname']);
|
|
$smarty->assign("VALIDATION_DATA_FIELDDATATYPE",$data['datatype']);
|
|
$smarty->assign("VALIDATION_DATA_FIELDLABEL",$data['fieldlabel']);
|
|
|
|
$check_button = Button_Check($module);
|
|
$smarty->assign("CHECK", $check_button);
|
|
$smarty->assign("DUPLICATE",vtlib_purify($_REQUEST['isDuplicate']));
|
|
|
|
global $adb;
|
|
// Module Sequence Numbering
|
|
$mod_seq_field = getModuleSequenceField($currentModule);
|
|
if($focus->mode != 'edit' && $mod_seq_field != null) {
|
|
$autostr = getTranslatedString('MSG_AUTO_GEN_ON_SAVE');
|
|
$mod_seq_string = $adb->pquery("SELECT prefix, cur_id from vtiger_modentity_num where semodule = ? and active=1",array($currentModule));
|
|
$mod_seq_prefix = $adb->query_result($mod_seq_string,0,'prefix');
|
|
$mod_seq_no = $adb->query_result($mod_seq_string,0,'cur_id');
|
|
if($adb->num_rows($mod_seq_string) == 0 || $focus->checkModuleSeqNumber($focus->table_name, $mod_seq_field['column'], $mod_seq_prefix.$mod_seq_no))
|
|
echo '<br><font color="#FF0000"><b>'. getTranslatedString('LBL_DUPLICATE'). ' '. getTranslatedString($mod_seq_field['label'])
|
|
.' - '. getTranslatedString('LBL_CLICK') .' <a href="index.php?module=Settings&action=CustomModEntityNo&parenttab=Settings&selmodule='.$currentModule.'">'.getTranslatedString('LBL_HERE').'</a> '
|
|
. getTranslatedString('LBL_TO_CONFIGURE'). ' '. getTranslatedString($mod_seq_field['label']) .'</b></font>';
|
|
else
|
|
$smarty->assign("MOD_SEQ_ID",$autostr);
|
|
} else {
|
|
$smarty->assign("MOD_SEQ_ID", $focus->column_fields[$mod_seq_field['name']]);
|
|
}
|
|
// END
|
|
|
|
$smarty->assign("CURRENCIES_LIST", getAllCurrencies());
|
|
if($focus->mode == 'edit') {
|
|
$inventory_cur_info = getInventoryCurrencyInfo('PurchaseOrder', $focus->id);
|
|
$smarty->assign("INV_CURRENCY_ID", $inventory_cur_info['currency_id']);
|
|
} else {
|
|
$smarty->assign("INV_CURRENCY_ID", $currencyid);
|
|
}
|
|
$smarty->assign('CREATEMODE', vtlib_purify($_REQUEST['createmode']));
|
|
|
|
$picklistDependencyDatasource = Vtiger_DependencyPicklist::getPicklistDependencyDatasource($currentModule);
|
|
$smarty->assign("PICKIST_DEPENDENCY_DATASOURCE", Zend_Json::encode($picklistDependencyDatasource));
|
|
|
|
// Gather the help information associated with fields
|
|
$smarty->assign('FIELDHELPINFO', vtlib_getFieldHelpInfo($currentModule));
|
|
// END
|
|
|
|
if($focus->mode == 'edit')
|
|
$smarty->display('Inventory/InventoryEditView.tpl');
|
|
else
|
|
$smarty->display('Inventory/InventoryCreateView.tpl');
|
|
|
|
?>
|