411 lines
19 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: Defines the Account SugarBean Account entity with the necessary
* methods and variables.
* Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
* All Rights Reserved.
* Contributor(s): ______________________________________..
********************************************************************************/
include_once('config.php');
require_once('include/logging.php');
require_once('include/utils/utils.php');
require_once('include/RelatedListView.php');
require_once('user_privileges/default_module_view.php');
// Account is used to store vtiger_account information.
class Quotes extends CRMEntity {
var $log;
var $db;
var $table_name = "vtiger_quotes";
var $table_index= 'quoteid';
var $tab_name = Array('vtiger_crmentity','vtiger_quotes','vtiger_quotesbillads','vtiger_quotesshipads','vtiger_quotescf');
var $tab_name_index = Array('vtiger_crmentity'=>'crmid','vtiger_quotes'=>'quoteid','vtiger_quotesbillads'=>'quotebilladdressid','vtiger_quotesshipads'=>'quoteshipaddressid','vtiger_quotescf'=>'quoteid');
/**
* Mandatory table for supporting custom fields.
*/
var $customFieldTable = Array('vtiger_quotescf', 'quoteid');
var $entity_table = "vtiger_crmentity";
var $billadr_table = "vtiger_quotesbillads";
var $object_name = "Quote";
var $new_schema = true;
var $column_fields = Array();
var $sortby_fields = Array('subject','crmid','smownerid','accountname','lastname');
// This is used to retrieve related vtiger_fields from form posts.
var $additional_column_fields = Array('assigned_user_name', 'smownerid', 'opportunity_id', 'case_id', 'contact_id', 'task_id', 'note_id', 'meeting_id', 'call_id', 'email_id', 'parent_name', 'member_id' );
// This is the list of vtiger_fields that are in the lists.
var $list_fields = Array(
//'Quote No'=>Array('crmentity'=>'crmid'),
// Module Sequence Numbering
'Quote No'=>Array('quotes'=>'quote_no'),
// END
'Subject'=>Array('quotes'=>'subject'),
'Quote Stage'=>Array('quotes'=>'quotestage'),
'Potential Name'=>Array('quotes'=>'potentialid'),
'Account Name'=>Array('account'=> 'accountid'),
'Total'=>Array('quotes'=> 'total'),
'Assigned To'=>Array('crmentity'=>'smownerid')
);
var $list_fields_name = Array(
'Quote No'=>'quote_no',
'Subject'=>'subject',
'Quote Stage'=>'quotestage',
'Potential Name'=>'potential_id',
'Account Name'=>'account_id',
'Total'=>'hdnGrandTotal',
'Assigned To'=>'assigned_user_id'
);
var $list_link_field= 'subject';
var $search_fields = Array(
'Quote No'=>Array('quotes'=>'quote_no'),
'Subject'=>Array('quotes'=>'subject'),
'Account Name'=>Array('quotes'=>'accountid'),
'Quote Stage'=>Array('quotes'=>'quotestage'),
);
var $search_fields_name = Array(
'Quote No'=>'quote_no',
'Subject'=>'subject',
'Account Name'=>'account_id',
'Quote Stage'=>'quotestage',
);
// This is the list of vtiger_fields that are required.
var $required_fields = array("accountname"=>1);
//Added these variables which are used as default order by and sortorder in ListView
var $default_order_by = 'crmid';
var $default_sort_order = 'ASC';
//var $groupTable = Array('vtiger_quotegrouprelation','quoteid');
var $mandatory_fields = Array('subject','createdtime' ,'modifiedtime');
// For Alphabetical search
var $def_basicsearch_col = 'subject';
/** Constructor which will set the column_fields in this object
*/
function Quotes() {
$this->log =LoggerManager::getLogger('quote');
$this->db = PearDatabase::getInstance();
$this->column_fields = getColumnFields('Quotes');
}
function save_module()
{
global $adb;
//in ajax save we should not call this function, because this will delete all the existing product values
if($_REQUEST['action'] != 'QuotesAjax' && $_REQUEST['ajxaction'] != 'DETAILVIEW'
&& $_REQUEST['action'] != 'MassEditSave' && $_REQUEST['action'] != 'ProcessDuplicates')
{
//Based on the total Number of rows we will save the product relationship with this entity
saveInventoryProductDetails($this, 'Quotes');
}
// Update the currency id and the conversion rate for the quotes
$update_query = "update vtiger_quotes set currency_id=?, conversion_rate=? where quoteid=?";
$update_params = array($this->column_fields['currency_id'], $this->column_fields['conversion_rate'], $this->id);
$adb->pquery($update_query, $update_params);
}
/** function used to get the list of sales orders which are related to the Quotes
* @param int $id - quote id
* @return array - return an array which will be returned from the function GetRelatedList
*/
function get_salesorder($id)
{
global $log,$singlepane_view;
$log->debug("Entering get_salesorder(".$id.") method ...");
require_once('modules/SalesOrder/SalesOrder.php');
$focus = new SalesOrder();
$button = '';
if($singlepane_view == 'true')
$returnset = '&return_module=Quotes&return_action=DetailView&return_id='.$id;
else
$returnset = '&return_module=Quotes&return_action=CallRelatedList&return_id='.$id;
$userNameSql = getSqlForNameInDisplayFormat(array('first_name'=>
'vtiger_users.first_name', 'last_name' => 'vtiger_users.last_name'), 'Users');
$query = "select vtiger_crmentity.*, vtiger_salesorder.*, vtiger_quotes.subject as quotename
, vtiger_account.accountname,case when (vtiger_users.user_name not like '') then
$userNameSql else vtiger_groups.groupname end as user_name
from vtiger_salesorder
inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_salesorder.salesorderid
left outer join vtiger_quotes on vtiger_quotes.quoteid=vtiger_salesorder.quoteid
left outer join vtiger_account on vtiger_account.accountid=vtiger_salesorder.accountid
left join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid
left join vtiger_users on vtiger_users.id=vtiger_crmentity.smownerid
where vtiger_crmentity.deleted=0 and vtiger_salesorder.quoteid = ".$id;
$log->debug("Exiting get_salesorder method ...");
return GetRelatedList('Quotes','SalesOrder',$focus,$query,$button,$returnset);
}
/** function used to get the list of activities which are related to the Quotes
* @param int $id - quote id
* @return array - return an array which will be returned from the function GetRelatedList
*/
function get_activities($id, $cur_tab_id, $rel_tab_id, $actions=false) {
global $log, $singlepane_view,$currentModule,$current_user;
$log->debug("Entering get_activities(".$id.") method ...");
$this_module = $currentModule;
$related_module = vtlib_getModuleNameById($rel_tab_id);
require_once("modules/$related_module/Activity.php");
$other = new Activity();
vtlib_setup_modulevars($related_module, $other);
$singular_modname = vtlib_toSingular($related_module);
$parenttab = getParentTab();
if($singlepane_view == 'true')
$returnset = '&return_module='.$this_module.'&return_action=DetailView&return_id='.$id;
else
$returnset = '&return_module='.$this_module.'&return_action=CallRelatedList&return_id='.$id;
$button = '';
$button .= '<input type="hidden" name="activity_mode">';
if($actions) {
if(is_string($actions)) $actions = explode(',', strtoupper($actions));
if(in_array('ADD', $actions) && isPermitted($related_module,1, '') == 'yes') {
if(getFieldVisibilityPermission('Calendar',$current_user->id,'parent_id', 'readwrite') == '0') {
$button .= "<input title='".getTranslatedString('LBL_NEW'). " ". getTranslatedString('LBL_TODO', $related_module) ."' class='crmbutton small create'" .
" onclick='this.form.action.value=\"EditView\";this.form.module.value=\"$related_module\";this.form.return_module.value=\"$this_module\";this.form.activity_mode.value=\"Task\";' type='submit' name='button'" .
" value='". getTranslatedString('LBL_ADD_NEW'). " " . getTranslatedString('LBL_TODO', $related_module) ."'>&nbsp;";
}
}
}
$userNameSql = getSqlForNameInDisplayFormat(array('first_name'=>
'vtiger_users.first_name', 'last_name' => 'vtiger_users.last_name'), 'Users');
$query = "SELECT case when (vtiger_users.user_name not like '') then $userNameSql else
vtiger_groups.groupname end as user_name, vtiger_contactdetails.contactid,
vtiger_contactdetails.lastname, vtiger_contactdetails.firstname, vtiger_activity.*,
vtiger_seactivityrel.*,vtiger_crmentity.crmid, vtiger_crmentity.smownerid,
vtiger_crmentity.modifiedtime,vtiger_recurringevents.recurringtype
from vtiger_activity
inner join vtiger_seactivityrel on vtiger_seactivityrel.activityid=
vtiger_activity.activityid
inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_activity.activityid
left join vtiger_cntactivityrel on vtiger_cntactivityrel.activityid=
vtiger_activity.activityid
left join vtiger_contactdetails on vtiger_contactdetails.contactid =
vtiger_cntactivityrel.contactid
left join vtiger_users on vtiger_users.id=vtiger_crmentity.smownerid
left outer join vtiger_recurringevents on vtiger_recurringevents.activityid=
vtiger_activity.activityid
left join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid
where vtiger_seactivityrel.crmid=".$id." and vtiger_crmentity.deleted=0 and
activitytype='Task' and (vtiger_activity.status is not NULL and
vtiger_activity.status != 'Completed') and (vtiger_activity.status is not NULL and
vtiger_activity.status != 'Deferred')";
$return_value = GetRelatedList($this_module, $related_module, $other, $query, $button, $returnset);
if($return_value == null) $return_value = Array();
$return_value['CUSTOM_BUTTON'] = $button;
$log->debug("Exiting get_activities method ...");
return $return_value;
}
/** function used to get the the activity history related to the quote
* @param int $id - quote id
* @return array - return an array which will be returned from the function GetHistory
*/
function get_history($id)
{
global $log;
$log->debug("Entering get_history(".$id.") method ...");
$userNameSql = getSqlForNameInDisplayFormat(array('first_name'=>
'vtiger_users.first_name', 'last_name' => 'vtiger_users.last_name'), 'Users');
$query = "SELECT vtiger_activity.activityid, vtiger_activity.subject, vtiger_activity.status,
vtiger_activity.eventstatus, vtiger_activity.activitytype,vtiger_activity.date_start,
vtiger_activity.due_date,vtiger_activity.time_start, vtiger_activity.time_end,
vtiger_contactdetails.contactid,
vtiger_contactdetails.firstname,vtiger_contactdetails.lastname, vtiger_crmentity.modifiedtime,
vtiger_crmentity.createdtime, vtiger_crmentity.description, case when (vtiger_users.user_name not like '') then $userNameSql else vtiger_groups.groupname end as user_name
from vtiger_activity
inner join vtiger_seactivityrel on vtiger_seactivityrel.activityid=vtiger_activity.activityid
inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_activity.activityid
left join vtiger_cntactivityrel on vtiger_cntactivityrel.activityid= vtiger_activity.activityid
left join vtiger_contactdetails on vtiger_contactdetails.contactid= vtiger_cntactivityrel.contactid
left join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid
left join vtiger_users on vtiger_users.id=vtiger_crmentity.smownerid
where vtiger_activity.activitytype='Task'
and (vtiger_activity.status = 'Completed' or vtiger_activity.status = 'Deferred')
and vtiger_seactivityrel.crmid=".$id."
and vtiger_crmentity.deleted = 0";
//Don't add order by, because, for security, one more condition will be added with this query in include/RelatedListView.php
$log->debug("Exiting get_history method ...");
return getHistory('Quotes',$query,$id);
}
/** Function used to get the Quote Stage history of the Quotes
* @param $id - quote id
* @return $return_data - array with header and the entries in format Array('header'=>$header,'entries'=>$entries_list) where as $header and $entries_list are arrays which contains header values and all column values of all entries
*/
function get_quotestagehistory($id)
{
global $log;
$log->debug("Entering get_quotestagehistory(".$id.") method ...");
global $adb;
global $mod_strings;
global $app_strings;
$query = 'select vtiger_quotestagehistory.*, vtiger_quotes.quote_no from vtiger_quotestagehistory inner join vtiger_quotes on vtiger_quotes.quoteid = vtiger_quotestagehistory.quoteid inner join vtiger_crmentity on vtiger_crmentity.crmid = vtiger_quotes.quoteid where vtiger_crmentity.deleted = 0 and vtiger_quotes.quoteid = ?';
$result=$adb->pquery($query, array($id));
$noofrows = $adb->num_rows($result);
$header[] = $app_strings['Quote No'];
$header[] = $app_strings['LBL_ACCOUNT_NAME'];
$header[] = $app_strings['LBL_AMOUNT'];
$header[] = $app_strings['Quote Stage'];
$header[] = $app_strings['LBL_LAST_MODIFIED'];
//Getting the field permission for the current user. 1 - Not Accessible, 0 - Accessible
//Account Name , Total are mandatory fields. So no need to do security check to these fields.
global $current_user;
//If field is accessible then getFieldVisibilityPermission function will return 0 else return 1
$quotestage_access = (getFieldVisibilityPermission('Quotes', $current_user->id, 'quotestage') != '0')? 1 : 0;
$picklistarray = getAccessPickListValues('Quotes');
$quotestage_array = ($quotestage_access != 1)? $picklistarray['quotestage']: array();
//- ==> picklist field is not permitted in profile
//Not Accessible - picklist is permitted in profile but picklist value is not permitted
$error_msg = ($quotestage_access != 1)? 'Not Accessible': '-';
while($row = $adb->fetch_array($result))
{
$entries = Array();
// Module Sequence Numbering
//$entries[] = $row['quoteid'];
$entries[] = $row['quote_no'];
// END
$entries[] = $row['accountname'];
$entries[] = $row['total'];
$entries[] = (in_array($row['quotestage'], $quotestage_array))? $row['quotestage']: $error_msg;
$date = new DateTimeField($row['lastmodified']);
$entries[] = $date->getDisplayDateTimeValue();
$entries_list[] = $entries;
}
$return_data = Array('header'=>$header,'entries'=>$entries_list);
$log->debug("Exiting get_quotestagehistory method ...");
return $return_data;
}
// Function to get column name - Overriding function of base class
function get_column_value($columname, $fldvalue, $fieldname, $uitype, $datatype='') {
if ($columname == 'potentialid' || $columname == 'contactid') {
if ($fldvalue == '') return null;
}
return parent::get_column_value($columname, $fldvalue, $fieldname, $uitype, $datatype);
}
/*
* Function to get the secondary query part of a report
* @param - $module primary module name
* @param - $secmodule secondary module name
* returns the query string formed on fetching the related data for report for secondary module
*/
function generateReportsSecQuery($module,$secmodule){
$query = $this->getRelationQuery($module,$secmodule,"vtiger_quotes","quoteid");
$query .= " left join vtiger_crmentity as vtiger_crmentityQuotes on vtiger_crmentityQuotes.crmid=vtiger_quotes.quoteid and vtiger_crmentityQuotes.deleted=0
left join vtiger_quotescf on vtiger_quotes.quoteid = vtiger_quotescf.quoteid
left join vtiger_quotesbillads on vtiger_quotes.quoteid=vtiger_quotesbillads.quotebilladdressid
left join vtiger_quotesshipads on vtiger_quotes.quoteid=vtiger_quotesshipads.quoteshipaddressid
left join vtiger_currency_info as vtiger_currency_info$secmodule on vtiger_currency_info$secmodule.id = vtiger_quotes.currency_id
left join vtiger_inventoryproductrel as vtiger_inventoryproductrelQuotes on vtiger_quotes.quoteid = vtiger_inventoryproductrelQuotes.id
left join vtiger_products as vtiger_productsQuotes on vtiger_productsQuotes.productid = vtiger_inventoryproductrelQuotes.productid
left join vtiger_service as vtiger_serviceQuotes on vtiger_serviceQuotes.serviceid = vtiger_inventoryproductrelQuotes.productid
left join vtiger_groups as vtiger_groupsQuotes on vtiger_groupsQuotes.groupid = vtiger_crmentityQuotes.smownerid
left join vtiger_users as vtiger_usersQuotes on vtiger_usersQuotes.id = vtiger_crmentityQuotes.smownerid
left join vtiger_users as vtiger_usersRel1 on vtiger_usersRel1.id = vtiger_quotes.inventorymanager
left join vtiger_potential as vtiger_potentialRelQuotes on vtiger_potentialRelQuotes.potentialid = vtiger_quotes.potentialid
left join vtiger_contactdetails as vtiger_contactdetailsQuotes on vtiger_contactdetailsQuotes.contactid = vtiger_quotes.contactid
left join vtiger_account as vtiger_accountQuotes on vtiger_accountQuotes.accountid = vtiger_quotes.accountid
left join vtiger_users as vtiger_lastModifiedByQuotes on vtiger_lastModifiedByQuotes.id = vtiger_crmentityQuotes.modifiedby ";
return $query;
}
/*
* Function to get the relation tables for related modules
* @param - $secmodule secondary module name
* returns the array with table names and fieldnames storing relations between module and this module
*/
function setRelationTables($secmodule){
$rel_tables = array (
"SalesOrder" =>array("vtiger_salesorder"=>array("quoteid","salesorderid"),"vtiger_quotes"=>"quoteid"),
"Calendar" =>array("vtiger_seactivityrel"=>array("crmid","activityid"),"vtiger_quotes"=>"quoteid"),
"Documents" => array("vtiger_senotesrel"=>array("crmid","notesid"),"vtiger_quotes"=>"quoteid"),
"Accounts" => array("vtiger_quotes"=>array("quoteid","accountid")),
"Contacts" => array("vtiger_quotes"=>array("quoteid","contactid")),
"Potentials" => array("vtiger_quotes"=>array("quoteid","potentialid")),
);
return $rel_tables[$secmodule];
}
// Function to unlink an entity with given Id from another entity
function unlinkRelationship($id, $return_module, $return_id) {
global $log;
if(empty($return_module) || empty($return_id)) return;
if($return_module == 'Accounts' ) {
$this->trash('Quotes',$id);
} elseif($return_module == 'Potentials') {
$relation_query = 'UPDATE vtiger_quotes SET potentialid=? WHERE quoteid=?';
$this->db->pquery($relation_query, array(null, $id));
} elseif($return_module == 'Contacts') {
$relation_query = 'UPDATE vtiger_quotes SET contactid=? WHERE quoteid=?';
$this->db->pquery($relation_query, array(null, $id));
} else {
$sql = 'DELETE FROM vtiger_crmentityrel WHERE (crmid=? AND relmodule=? AND relcrmid=?) OR (relcrmid=? AND module=? AND crmid=?)';
$params = array($id, $return_module, $return_id, $id, $return_module, $return_id);
$this->db->pquery($sql, $params);
}
}
}
?>