'crmid', 'vtiger_project' => 'projectid', 'vtiger_projectcf' => 'projectid'); /** * Mandatory for Listing (Related listview) */ var $list_fields = Array ( /* Format: Field Label => Array(tablename, columnname) */ // tablename should not have prefix 'vtiger_' 'Project Name'=> Array('project', 'projectname'), 'Start Date'=> Array('project', 'startdate'), 'Status'=>Array('project','projectstatus'), 'Type'=>Array('project','projecttype'), 'Assigned To' => Array('crmentity','smownerid') ); var $list_fields_name = Array( /* Format: Field Label => fieldname */ 'Project Name'=> 'projectname', 'Start Date'=> 'startdate', 'Status'=>'projectstatus', 'Type'=>'projecttype', 'Assigned To' => 'assigned_user_id' ); // Make the field link to detail view from list view (Fieldname) var $list_link_field = 'projectname'; // For Popup listview and UI type support var $search_fields = Array( /* Format: Field Label => Array(tablename, columnname) */ // tablename should not have prefix 'vtiger_' 'Project Name'=> Array('project', 'projectname'), 'Start Date'=> Array('project', 'startdate'), 'Status'=>Array('project','projectstatus'), 'Type'=>Array('project','projecttype'), ); var $search_fields_name = Array( /* Format: Field Label => fieldname */ 'Project Name'=> 'projectname', 'Start Date'=> 'startdate', 'Status'=>'projectstatus', 'Type'=>'projecttype', ); // For Popup window record selection var $popup_fields = Array('projectname'); // Placeholder for sort fields - All the fields will be initialized for Sorting through initSortFields var $sortby_fields = Array(); // For Alphabetical search var $def_basicsearch_col = 'projectname'; // Column value to use on detail view record text display var $def_detailview_recname = 'projectname'; // Required Information for enabling Import feature var $required_fields = Array('projectname'=>1); // Callback function list during Importing var $special_functions = Array('set_import_assigned_user'); var $default_order_by = 'projectname'; var $default_sort_order='ASC'; // Used when enabling/disabling the mandatory fields for the module. // Refers to vtiger_field.fieldname values. var $mandatory_fields = Array('createdtime', 'modifiedtime', 'projectname'); function __construct() { global $log, $currentModule; $this->column_fields = getColumnFields($currentModule); $this->db = PearDatabase::getInstance(); $this->log = $log; } function save_module($module) { } /** * Return query to use based on given modulename, fieldname * Useful to handle specific case handling for Popup */ function getQueryByModuleField($module, $fieldname, $srcrecord) { // $srcrecord could be empty } /** * Get list view query (send more WHERE clause condition if required) */ function getListQuery($module, $usewhere='') { $query = "SELECT vtiger_crmentity.*, $this->table_name.*"; // Keep track of tables joined to avoid duplicates $joinedTables = array(); // Select Custom Field Table Columns if present if(!empty($this->customFieldTable)) $query .= ", " . $this->customFieldTable[0] . ".* "; $query .= " FROM $this->table_name"; $query .= " INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = $this->table_name.$this->table_index"; $joinedTables[] = $this->table_name; $joinedTables[] = 'vtiger_crmentity'; // Consider custom table join as well. if(!empty($this->customFieldTable)) { $query .= " INNER JOIN ".$this->customFieldTable[0]." ON ".$this->customFieldTable[0].'.'.$this->customFieldTable[1] . " = $this->table_name.$this->table_index"; $joinedTables[] = $this->customFieldTable[0]; } $query .= " LEFT JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid"; $query .= " LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid"; $joinedTables[] = 'vtiger_users'; $joinedTables[] = 'vtiger_groups'; $linkedModulesQuery = $this->db->pquery("SELECT distinct fieldname, columnname, relmodule FROM vtiger_field" . " INNER JOIN vtiger_fieldmodulerel ON vtiger_fieldmodulerel.fieldid = vtiger_field.fieldid" . " WHERE uitype='10' AND vtiger_fieldmodulerel.module=?", array($module)); $linkedFieldsCount = $this->db->num_rows($linkedModulesQuery); for($i=0; $i<$linkedFieldsCount; $i++) { $related_module = $this->db->query_result($linkedModulesQuery, $i, 'relmodule'); $fieldname = $this->db->query_result($linkedModulesQuery, $i, 'fieldname'); $columnname = $this->db->query_result($linkedModulesQuery, $i, 'columnname'); $other = CRMEntity::getInstance($related_module); vtlib_setup_modulevars($related_module, $other); if(!in_array($other->table_name, $joinedTables)) { $query .= " LEFT JOIN $other->table_name ON $other->table_name.$other->table_index = $this->table_name.$columnname"; $joinedTables[] = $other->table_name; } } global $current_user; $query .= $this->getNonAdminAccessControlQuery($module,$current_user); $query .= " WHERE vtiger_crmentity.deleted = 0 ".$usewhere; return $query; } /** * Apply security restriction (sharing privilege) query part for List view. */ function getListViewSecurityParameter($module) { global $current_user; require('user_privileges/user_privileges_'.$current_user->id.'.php'); require('user_privileges/sharing_privileges_'.$current_user->id.'.php'); $sec_query = ''; $tabid = getTabid($module); if($is_admin==false && $profileGlobalPermission[1] == 1 && $profileGlobalPermission[2] == 1 && $defaultOrgSharingPermission[$tabid] == 3) { $sec_query .= " AND (vtiger_crmentity.smownerid in($current_user->id) OR vtiger_crmentity.smownerid IN ( SELECT vtiger_user2role.userid FROM vtiger_user2role INNER JOIN vtiger_users ON vtiger_users.id=vtiger_user2role.userid INNER JOIN vtiger_role ON vtiger_role.roleid=vtiger_user2role.roleid WHERE vtiger_role.parentrole LIKE '".$current_user_parent_role_seq."::%' ) OR vtiger_crmentity.smownerid IN ( SELECT shareduserid FROM vtiger_tmp_read_user_sharing_per WHERE userid=".$current_user->id." AND tabid=".$tabid." ) OR ("; // Build the query based on the group association of current user. if(sizeof($current_user_groups) > 0) { $sec_query .= " vtiger_groups.groupid IN (". implode(",", $current_user_groups) .") OR "; } $sec_query .= " vtiger_groups.groupid IN ( SELECT vtiger_tmp_read_group_sharing_per.sharedgroupid FROM vtiger_tmp_read_group_sharing_per WHERE userid=".$current_user->id." and tabid=".$tabid." )"; $sec_query .= ") )"; } return $sec_query; } /** * Create query to export the records. */ function create_export_query($where) { global $current_user; $thismodule = $_REQUEST['module']; include("include/utils/ExportUtils.php"); //To get the Permitted fields query and the permitted fields list $sql = getPermittedFieldsQuery($thismodule, "detail_view"); $fields_list = getFieldsListFromQuery($sql); $query = "SELECT $fields_list, vtiger_users.user_name AS user_name FROM vtiger_crmentity INNER JOIN $this->table_name ON vtiger_crmentity.crmid=$this->table_name.$this->table_index"; if(!empty($this->customFieldTable)) { $query .= " INNER JOIN ".$this->customFieldTable[0]." ON ".$this->customFieldTable[0].'.'.$this->customFieldTable[1] . " = $this->table_name.$this->table_index"; } $query .= " LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid"; $query .= " LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id and vtiger_users.status='Active'"; $linkedModulesQuery = $this->db->pquery("SELECT distinct fieldname, columnname, relmodule FROM vtiger_field" . " INNER JOIN vtiger_fieldmodulerel ON vtiger_fieldmodulerel.fieldid = vtiger_field.fieldid" . " WHERE uitype='10' AND vtiger_fieldmodulerel.module=?", array($thismodule)); $linkedFieldsCount = $this->db->num_rows($linkedModulesQuery); for($i=0; $i<$linkedFieldsCount; $i++) { $related_module = $this->db->query_result($linkedModulesQuery, $i, 'relmodule'); $fieldname = $this->db->query_result($linkedModulesQuery, $i, 'fieldname'); $columnname = $this->db->query_result($linkedModulesQuery, $i, 'columnname'); $other = CRMEntity::getInstance($related_module); vtlib_setup_modulevars($related_module, $other); $query .= " LEFT JOIN $other->table_name ON $other->table_name.$other->table_index = $this->table_name.$columnname"; } $query .= $this->getNonAdminAccessControlQuery($thismodule,$current_user); $where_auto = " vtiger_crmentity.deleted=0"; if($where != '') $query .= " WHERE ($where) AND $where_auto"; else $query .= " WHERE $where_auto"; return $query; } /** * Transform the value while exporting */ function transform_export_value($key, $value) { return parent::transform_export_value($key, $value); } /** * Function which will give the basic query to find duplicates */ function getDuplicatesQuery($module,$table_cols,$field_values,$ui_type_arr,$select_cols='') { $select_clause = "SELECT ". $this->table_name .".".$this->table_index ." AS recordid, vtiger_users_last_import.deleted,".$table_cols; // Select Custom Field Table Columns if present if(isset($this->customFieldTable)) $query .= ", " . $this->customFieldTable[0] . ".* "; $from_clause = " FROM $this->table_name"; $from_clause .= " INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = $this->table_name.$this->table_index"; // Consider custom table join as well. if(isset($this->customFieldTable)) { $from_clause .= " INNER JOIN ".$this->customFieldTable[0]." ON ".$this->customFieldTable[0].'.'.$this->customFieldTable[1] . " = $this->table_name.$this->table_index"; } $from_clause .= " LEFT JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid"; $where_clause = " WHERE vtiger_crmentity.deleted = 0"; $where_clause .= $this->getListViewSecurityParameter($module); if (isset($select_cols) && trim($select_cols) != '') { $sub_query = "SELECT $select_cols FROM $this->table_name AS t " . " INNER JOIN vtiger_crmentity AS crm ON crm.crmid = t.".$this->table_index; // Consider custom table join as well. if(isset($this->customFieldTable)) { $sub_query .= " LEFT JOIN ".$this->customFieldTable[0]." tcf ON tcf.".$this->customFieldTable[1]." = t.$this->table_index"; } $sub_query .= " WHERE crm.deleted=0 GROUP BY $select_cols HAVING COUNT(*)>1"; } else { $sub_query = "SELECT $table_cols $from_clause $where_clause GROUP BY $table_cols HAVING COUNT(*)>1"; } $query = $select_clause . $from_clause . " LEFT JOIN vtiger_users_last_import ON vtiger_users_last_import.bean_id=" . $this->table_name .".".$this->table_index . " INNER JOIN (" . $sub_query . ") AS temp ON ".get_on_clause($field_values,$ui_type_arr,$module) . $where_clause . " ORDER BY $table_cols,". $this->table_name .".".$this->table_index ." ASC"; return $query; } /** * Invoked when special actions are performed on the module. * @param String Module name * @param String Event Type (module.postinstall, module.disabled, module.enabled, module.preuninstall) */ function vtlib_handler($modulename, $event_type) { if($event_type == 'module.postinstall') { global $adb; include_once('vtlib/Vtiger/Module.php'); $moduleInstance = Vtiger_Module::getInstance($modulename); $projectsResult = $adb->pquery('SELECT tabid FROM vtiger_tab WHERE name=?', array('Project')); $projectTabid = $adb->query_result($projectsResult, 0, 'tabid'); // Mark the module as Standard module $adb->pquery('UPDATE vtiger_tab SET customized=0 WHERE name=?', array($modulename)); // Add module to Customer portal if(getTabid('CustomerPortal') && $projectTabid) { $checkAlreadyExists = $adb->pquery('SELECT 1 FROM vtiger_customerportal_tabs WHERE tabid=?', array($projectTabid)); if($checkAlreadyExists && $adb->num_rows($checkAlreadyExists) < 1) { $maxSequenceQuery = $adb->query("SELECT max(sequence) as maxsequence FROM vtiger_customerportal_tabs"); $maxSequence = $adb->query_result($maxSequenceQuery, 0, 'maxsequence'); $nextSequence = $maxSequence+1; $adb->query("INSERT INTO vtiger_customerportal_tabs(tabid,visible,sequence) VALUES ($projectTabid,1,$nextSequence)"); $adb->query("INSERT INTO vtiger_customerportal_prefs(tabid,prefkey,prefvalue) VALUES ($projectTabid,'showrelatedinfo',1)"); } } // Add Gnatt chart to the related list of the module $relation_id = $adb->getUniqueID('vtiger_relatedlists'); $max_sequence = 0; $result = $adb->query("SELECT max(sequence) as maxsequence FROM vtiger_relatedlists WHERE tabid=$projectTabid"); if($adb->num_rows($result)) $max_sequence = $adb->query_result($result, 0, 'maxsequence'); $sequence = $max_sequence+1; $adb->pquery("INSERT INTO vtiger_relatedlists(relation_id,tabid,related_tabid,name,sequence,label,presence) VALUES(?,?,?,?,?,?,?)", array($relation_id,$projectTabid,0,'get_gantt_chart',$sequence,'Charts',0)); // Add Project module to the related list of Accounts module $accountsModuleInstance = Vtiger_Module::getInstance('Accounts'); $accountsModuleInstance->setRelatedList($moduleInstance, 'Projects', Array('ADD','SELECT'), 'get_dependents_list'); // Add Project module to the related list of Accounts module $contactsModuleInstance = Vtiger_Module::getInstance('Contacts'); $contactsModuleInstance->setRelatedList($moduleInstance, 'Projects', Array('ADD','SELECT'), 'get_dependents_list'); // Add Project module to the related list of HelpDesk module $helpDeskModuleInstance = Vtiger_Module::getInstance('HelpDesk'); $helpDeskModuleInstance->setRelatedList($moduleInstance, 'Projects', Array('SELECT'), 'get_related_list'); $modcommentsModuleInstance = Vtiger_Module::getInstance('ModComments'); if($modcommentsModuleInstance && file_exists('modules/ModComments/ModComments.php')) { include_once 'modules/ModComments/ModComments.php'; if(class_exists('ModComments')) ModComments::addWidgetTo(array('Project')); } } else if($event_type == 'module.disabled') { // TODO Handle actions when this module is disabled. } else if($event_type == 'module.enabled') { // TODO Handle actions when this module is enabled. } else if($event_type == 'module.preuninstall') { // TODO Handle actions when this module is about to be deleted. } else if($event_type == 'module.preupdate') { // TODO Handle actions before this module is updated. } else if($event_type == 'module.postupdate') { global $adb; $projectsResult = $adb->pquery('SELECT tabid FROM vtiger_tab WHERE name=?', array('Project')); $projectTabid = $adb->query_result($projectsResult, 0, 'tabid'); // Add Gnatt chart to the related list of the module $relation_id = $adb->getUniqueID('vtiger_relatedlists'); $max_sequence = 0; $result = $adb->query("SELECT max(sequence) as maxsequence FROM vtiger_relatedlists WHERE tabid=$projectTabid"); if($adb->num_rows($result)) $max_sequence = $adb->query_result($result, 0, 'maxsequence'); $sequence = $max_sequence+1; $adb->pquery("INSERT INTO vtiger_relatedlists(relation_id,tabid,related_tabid,name,sequence,label,presence) VALUES(?,?,?,?,?,?,?)", array($relation_id,$projectTabid,0,'get_gantt_chart',$sequence,'Charts',0)); // Add Comments widget to Project module $modcommentsModuleInstance = Vtiger_Module::getInstance('ModComments'); if($modcommentsModuleInstance && file_exists('modules/ModComments/ModComments.php')) { include_once 'modules/ModComments/ModComments.php'; if(class_exists('ModComments')) ModComments::addWidgetTo(array('Project')); } } } static function registerLinks() { } /** * Here we override the parent's method, * This is done because the related lists for this module use a custom query * that queries the child module's table (column of the uitype10 field) * * @see data/CRMEntity#save_related_module($module, $crmid, $with_module, $with_crmid) */ //function save_related_module($module, $crmid, $with_module, $with_crmid) { } /** * Here we override the parent's method * This is done because the related lists for this module use a custom query * that queries the child module's table (column of the uitype10 field) * * @see data/CRMEntity#delete_related_module($module, $crmid, $with_module, $with_crmid) */ function delete_related_module($module, $crmid, $with_module, $with_crmid) { if (!in_array($with_module, array('ProjectMilestone', 'ProjectTask'))) { parent::delete_related_module($module, $crmid, $with_module, $with_crmid); return; } $destinationModule = vtlib_purify($_REQUEST['destination_module']); if (!is_array($with_crmid)) $with_crmid = Array($with_crmid); foreach($with_crmid as $relcrmid) { $child = CRMEntity::getInstance($destinationModule); $child->retrieve_entity_info($relcrmid, $destinationModule); $child->mode='edit'; $child->column_fields['projectid']=''; $child->save($destinationModule,$relcrmid); } } /** * Handle getting related list information. * NOTE: This function has been added to CRMEntity (base class). * You can override the behavior by re-defining it here. */ //function get_related_list($id, $cur_tab_id, $rel_tab_id, $actions=false) { } /** * Handle getting dependents list information. * NOTE: This function has been added to CRMEntity (base class). * You can override the behavior by re-defining it here. */ //function get_dependents_list($id, $cur_tab_id, $rel_tab_id, $actions=false) { } function get_gantt_chart($id, $cur_tab_id, $rel_tab_id, $actions=false){ require_once("BURAK_Gantt.class.php"); $headers = array(); $headers[0] = getTranslatedString('LBL_PROGRESS_CHART'); $entries = array(); global $adb,$tmp_dir,$default_charset; $record = $id; $g = new BURAK_Gantt(); // set grid type $g->setGrid(1); // set Gantt colors $g->setColor("group","000000"); $g->setColor("progress","660000"); $related_projecttasks = $adb->pquery("SELECT pt.* FROM vtiger_projecttask AS pt INNER JOIN vtiger_crmentity AS crment ON pt.projecttaskid=crment.crmid WHERE projectid=? AND crment.deleted=0 AND pt.startdate IS NOT NULL AND pt.enddate IS NOT NULL", array($record)) or die("Please install the ProjectMilestone and ProjectTasks modules first."); while($rec_related_projecttasks = $adb->fetchByAssoc($related_projecttasks)){ if($rec_related_projecttasks['projecttaskprogress']=="--none--"){ $percentage = 0; } else { $percentage = str_replace("%","",$rec_related_projecttasks['projecttaskprogress']); } $rec_related_projecttasks['projecttaskname'] = iconv($default_charset, "UTF-8//TRANSLIT",$rec_related_projecttasks['projecttaskname']); $g->addTask($rec_related_projecttasks['projecttaskid'],$rec_related_projecttasks['startdate'],$rec_related_projecttasks['enddate'],$percentage,$rec_related_projecttasks['projecttaskname']); } $related_projectmilestones = $adb->pquery("SELECT pm.* FROM vtiger_projectmilestone AS pm INNER JOIN vtiger_crmentity AS crment on pm.projectmilestoneid=crment.crmid WHERE projectid=? and crment.deleted=0", array($record)) or die("Please install the ProjectMilestone and ProjectTasks modules first."); while($rec_related_projectmilestones = $adb->fetchByAssoc($related_projectmilestones)){ $rec_related_projectmilestones['projectmilestonename'] = iconv($default_charset, "UTF-8//TRANSLIT",$rec_related_projectmilestones['projectmilestonename']); $g->addMilestone($rec_related_projectmilestones['projectmilestoneid'],$rec_related_projectmilestones['projectmilestonedate'],$rec_related_projectmilestones['projectmilestonename']); } $g->outputGantt($tmp_dir."diagram_".$record.".jpg","100"); $origin = $tmp_dir."diagram_".$record.".jpg"; $destination = $tmp_dir."pic_diagram_".$record.".jpg"; $imagesize = getimagesize($origin); $actualWidth = $imagesize[0]; $actualHeight = $imagesize[1]; $size = 1000; if($actualWidth > $size){ $width = $size; $height = ($actualHeight * $size) / $actualWidth; copy($origin,$destination); $id_origin = imagecreatefromjpeg($destination); $id_destination = imagecreate($width, $height); imagecopyresized($id_destination, $id_origin, 0, 0, 0, 0, $width, $height, $actualWidth, $actualHeight); imagejpeg($id_destination,$destination); imagedestroy($id_origin); imagedestroy($id_destination); $image = $destination; } else { $image = $origin; } $fullGanttChartImageUrl = $tmp_dir."diagram_".$record.".jpg"; $thumbGanttChartImageUrl = $image; $entries[0] = array(""); return array('header'=> $headers, 'entries'=> $entries); } } ?>