listview.php

开源的CRM,功能全面,国内最优秀的源码

<?php
include('modules/SimpleMod/NewEntryPoint.php');
/*****************************************************************************
 * The contents of this file are subject to the RECIPROCAL PUBLIC LICENSE
 * Version 1.1 ("License"); You may not use this file except in compliance
 * with the License. You may obtain a copy of the License at
 * http://opensource.org/licenses/rpl.php. Software distributed under the
 * License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND,
 * either express or implied.
 *
 * You may:
 * a) Use and distribute this code exactly as you received without payment or
 *    a royalty or other fee.
 * b) Create extensions for this code, provided that you make the extensions
 *    publicly available and document your modifications clearly.
 * c) Charge for a fee for warranty or support or for accepting liability
 *    obligations for your customers.
 *
 * You may NOT:
 * a) Charge for the use of the original code or extensions, including in
 *    electronic distribution models, such as ASP (Application Service
 *    Provider).
 * b) Charge for the original source code or your extensions other than a
 *    nominal fee to cover distribution costs where such distribution
 *    involves PHYSICAL media.
 * c) Modify or delete any pre-existing copyright notices, change notices,
 *    or License text in the Licensed Software
 * d) Assert any patent claims against the Licensor or Contributors, or
 *    which would in any way restrict the ability of any third party to use the
 *    Licensed Software.
 *
 * You must:
 * a) Document any modifications you make to this code including the nature of
 *    the change, the authors of the change, and the date of the change.
 * b) Make the source code for any extensions you deploy available via an
 *    Electronic Distribution Mechanism such as FTP or HTTP download.
 * c) Notify the licensor of the availability of source code to your extensions
 *    and include instructions on how to acquire the source code and updates.
 * d) Grant Licensor a world-wide, non-exclusive, royalty-free license to use,
 *    reproduce, perform, modify, sublicense, and distribute your extensions.
 *
 * The Original Code is: CommuniCore
 *                       Olavo Farias
 *                       2006-04-7 [e-mail]
 *
 * The Initial Developer of the Original Code is CommuniCore.
 * Portions created by CommuniCore are Copyright (C) 2005 CommuniCore Ltda
 * All Rights Reserved.
 ********************************************************************************/
/*******************************************************************************
 * Display of ListView for Simple module template
 *******************************************************************************/

  require_once('XTemplate/xtpl.php');
  require_once('themes/' . $theme . '/layout_utils.php');
  require_once('include/ListView/ListView.php');
  require_once('log4php/LoggerManager.php');
  require_once('include/modules.php');
  require_once('modules/SimpleMod/SimpleObj.php');
  
  global $current_language;
  global $app_strings;
  
  include('include/QuickSearchDefaults.php');
  echo $qsScripts;
  
  $mod_strings = return_module_language($current_language, 'SimpleMod');
  
  if (!isset($where)) $where = '';
  require_once('modules/MySettings/StoreQuery.php');
  $storeQuery = new StoreQuery();
  //$storeQuery->process_views($currentModule);
  if(isset($_REQUEST['query_id']) && !isset($_REQUEST['saveQuery']) && !isset($_REQUEST['deleteQuery']))
	$storeQuery->loadFromSavedQuery($currentModule, $_REQUEST['query_id']);

  $seedSimpleObj = new SimpleObj();
  $where_clauses = array();

//Query processing (START)
  if(isset($_REQUEST['query'])){
   // we have a query
   if (isset($_REQUEST['current_user_only'])) $current_user_only = $_REQUEST['current_user_only'];
 //BUILDER:START of query 
 //BUILDER:END of query 
  
  
   if(isset($current_user_only) && $current_user_only != "") array_push($where_clauses, "simple_table.assigned_user_id='$current_user->id'");
  
   //search by modified date.
	if (isset($_REQUEST['date_period'])) $date_period = $_REQUEST['date_period'];
	if($date_period == "cust"){
		if (isset($_REQUEST['date_from'])) $date_from = $_REQUEST['date_from'];
		if (isset($_REQUEST['date_to'])) $date_to = $_REQUEST['date_to'];
		
	}else{
		$date_from = get_date_from($date_period);
		$date_to = get_date_to($date_period);
	}
	if(isset($date_from) && $date_from != "") array_push($where_clauses, "simple_table.date_modified>='$date_from'");
	if(isset($date_to) && $date_to != "") array_push($where_clauses, "simple_table.date_modified<'$date_to'");
	//~~ end search by modified date.
   $seedSimpleObj->custom_fields->setWhereClauses($where_clauses);
  
   $where = '';
   foreach($where_clauses as $clause){
    if($where != '')
    $where .= ' AND ';
    $where .= $clause;
   }
   $GLOBALS['log']->info("Here is the where clause for the list view: $where");
  }
//Query processing (END)
  $_REQUEST['where'] = $where;
  $storeQuery->process_views($currentModule);
  if(!empty($storeQuery->curView->where_clause)) $where = $storeQuery->curView->where_clause;

////////////////////////////////////////////////////////////////////////////////
// Search Form Processing (START)
	if(empty($_REQUEST['search_form'])){
		$search_form = new XTemplate('modules/SimpleMod/SearchForm.html');
  //show saved queries.
	$storeQuery->process_views2($search_form, $currentModule);

	//when select a tag
	if(isset($storeQuery->curTag) && in_array($storeQuery->curTag, $storeQuery->tags))
	{
		$r_ids = get_records_by_tag($currentModule, $_REQUEST['query_id']);
		$id_in = "('".implode("','", $r_ids)."')";
		$where = ' simple_table.id in '.$id_in;
	}
  
// The title label and arrow pointing to the module search form
   $header_text = '';   
   if(is_admin($current_user)   
    && $_REQUEST['module'] != 'DynamicLayout'   
    && !empty($_SESSION['editinplace']))   
   {   
    $header_text = "<a href='index.php?action=index&module=DynamicLayout&from_action=SearchForm&from_module="   
     .$_REQUEST['module'] ."'>"   
     .get_image($image_path."EditLayout","border='0' alt='Edit Layout' align='bottom'")   
     ."</a>";   
   }   
       
   $header = get_form_header($mod_strings['LBL_SEARCH_FORM_TITLE'], $header_text, false);
  
   $search_form->assign('header',     $header);
   $search_form->assign('MOD',        $mod_strings);
   $search_form->assign('APP',        $app_strings);
	  $search_form->assign("IMAGE_PATH", $image_path);
	  $search_form->assign("ADVANCED_SEARCH_PNG", get_image($image_path.'advanced_search','alt="'.$app_strings['LNK_ADVANCED_SEARCH'].'"  border="0"'));
	  $search_form->assign("BASIC_SEARCH_PNG", get_image($image_path.'basic_search','alt="'.$app_strings['LNK_BASIC_SEARCH'].'"  border="0"'));
   $search_form->assign("JAVASCRIPT", get_clear_form_js());
// Needed if date field on SearchForm
   $search_form->assign("CALENDAR_DATEFORMAT", $timedate->get_cal_date_format());
   if(isset($current_user_only)){
    $search_form->assign('CURRENT_USER_ONLY', 'checked="checked"');
   }

 //BUILDER:START of request Bas 
 //BUILDER:END of request Bas 

////////////////////////////////////////////////////////////////////////////////
// Advanced Search Form Processing (START)
  	if (isset($_REQUEST['advanced']) && $_REQUEST['advanced'] == 'true') {
    echo get_form_header($mod_strings['LBL_SEARCH_FORM_TITLE']. $header_text, "", false);

    //BUILDER:START of request Adv 
    //BUILDER:END of request Adv 

		  // adding custom fields:
		  $seedSimpleObj->custom_fields->populateXTPL($search_form, 'search' );
		  $search_form->parse("advanced");
		  $search_form->out("advanced");
	  }
// Advanced Search Form Processing (END)
////////////////////////////////////////////////////////////////////////////////
	  else 
	  {
    // Adding custom fields:
    $seedSimpleObj->custom_fields->populateXTPL($search_form, 'search' );
    $search_form->parse('main');
    $search_form->out('main');
   }
  }
// Search Form Processing (END)
////////////////////////////////////////////////////////////////////////////////

  $theme_path = "themes/$theme";
  $img_path   = "$theme_path/images";
  
  $listview   = new ListView();
  $listview->initNewXTemplate('modules/SimpleMod/ListView.html', $mod_strings);
  $listview->setHeaderTitle($mod_strings['LBL_LIST_FORM_TITLE']);
  
  if(is_admin($current_user)   
   && $_REQUEST['module'] != 'DynamicLayout'   
   && !empty($_SESSION['editinplace']))   
  {   
   $listview->setHeaderText("<a href='index.php?action=index&module=DynamicLayout&from_action=ListView&from_module="   
    .$_REQUEST['module'] ."'>"   
    .get_image($image_path."EditLayout","border='0' alt='Edit Layout' align='bottom'")   
    ."</a>" );   
  }
  
  $listview->setQuery($where, '', 'name', 'SIMPLEOBJ');
  $listview->setAdditionalDetails();
  $listview->processListView($seedSimpleObj,  'main', 'SIMPLEOBJ');
  
?>