Logiciel Open Source pour la gestion d'entreprise :
CRM, GED, Comptabilité, Groupware, Projets, DRH

Présentation Fonctionnalités Architecture GED

www.dg-server.com >> Présentation >> Architecture

Une conception moderne, facilement maintenable et personnalisable

DG-Server a été développé en PHP/mySQL avec une architecture MVC :

PHP 5
MySQL 5
Abstraction des bases de données
Développement objet
Scaffolding
AJAX

A propos du scaffolding

DG-Server a été conçu sur le principe du scaffolding. Une classe mère détermine comment la base de données sera utilisée de façon générale : affichage d'un individu, liste, enregistrement de données, modification de données, suppression, etc.

Les concepteurs peuvent ensuite créer des tables dans la base de données et les manipuler directement dans DG-Server à partir d'URL normalisées sans avoir eu à coder quoi que ce soit. S'ils veulent préciser des fonctionnements particuliers pour l'enregistrement, la modification ou l'affichage, il leur suffit alors de créer une classe héritée de la classe principale et de surcharger les comportements qu'ils souhaitent personnaliser.

Cette méthode de conception permet un gain de productivité considérable et une parfaite organisation du code.

Code source de la classe mère :

/* 
Copyright 2010 Dawan (http://www.dawan.fr).
This file is part of DG-Server.
DG-Server is free software: you can redistribute it and/or modify it under the terms of the 
GNU Lesser General Public License as published by the Free Software Foundation, either 
version 3 of the License, or (at your option) any later version.
DG-Server is distributed WITHOUT ANY WARRANTY; without even the implied warranty of 
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU LGPL for more details.
You should have received a copy of the GNU LGPL along with DG-Server. If not, see 
http://www.gnu.org/licenses/.
*/

if(substr($_SERVER['SERVER_NAME'],0,7)=='192.168' || 
		substr($_SERVER['SERVER_NAME'],0,7)=='127.0.0'){
	//your test server
	define("DEFAULT_DB_DB","dgserver");
	define("DEFAULT_DB_SERVEUR","localhost");
	define("DEFAULT_DB_LOGIN","root");
	define("DEFAULT_DB_PWD","");
} else {
	//your production server 
	define("DEFAULT_DB_DB","dgserver");
	define("DEFAULT_DB_SERVEUR","localhost");
	define("DEFAULT_DB_LOGIN","dgserver");
	define("DEFAULT_DB_PWD","dgserver");
}

//TODO transforms some constant to class consts

//display type
define("INSERT","insert");
define("I_MASSIVE","insert_massive");
define("SEARCH","search");
define("UPDATE","update");
define("SEE","see"); //see only one record
define("SEE_LIST","see_list"); //see in a list of records
define("QUICK_SHOW",SEE); //after update, before delete, ..

define("DATAOBJECT_NBITEM_SHOW_SEE_LIST",5);
define("DATAOBJECT_SIZE_CONTENT_SHOW_SEE_LIST",64);
define("DATAOBJECT_NBRECORDS_SEE_LIST",20);
define("DATAOBJECT_NBPOINTS_SEE_LIST",50);
define("DATAOBJECT_NBPAGES_SEE_LIST",20);
define("FILES_DIRECTORY","./files/");
define("TMP_DIRECTORY","./tmp/");
define("LOGS_DIRECTORY","./logs/");
define("LOGS_ROTATION_PATTERN","Y-m");
define("LOGS_INTERVAL_ARCHIVE","100");
//define("EMAIL_HEADER_NL","\r\n");
define("EMAIL_HEADER_NL","\n"); //RFC 2822 : CRLF 
define("EMAIL_TEXT_NL","\n"); //RFC 2822 : LF
define("DEFAULT_TEXTAREA_COLS",60);
define("DEFAULT_TEXTAREA_ROWS",6);
define("DATAOBJECT_NBINSERT_MASSIVE",20);
define("DEFAULT_MAIL","noreply@example.org");

class DataObject {

const RELEASE_NUMBER = "0.9";
	const DOCUMENTS_PROTOCOL = "http";

private static $DATAOBJECT_LIMIT_NBRECORDS_SEE_LIST = array(20,50,100);

public $action;
	public $table;
	public $params;
	public $html_page;
	public $html_response;
	public $db; // full object
	public $query_string;
	
	protected $current_object; //used by subclasses if needed, during page generation
	protected static $table_prefixes = array();
	protected $next_id;

//must be light !
	public function __construct($html_page,$action = "",$table = "",$params=array()) {
		if($table=="")
			$table = strtolower(get_class($this));
		$this->html_page = $html_page;
		$this->action = $action;
		$this->table = $table;
		$this->params = $params;
		$this->query_string = "?".$_SERVER['QUERY_STRING']; //use other_params instead ?
		if($this->html_page->data_object!=null) //do not reconnect
			$this->db = $this->html_page->data_object->db; //this is not an error
		else
			$this->db = self::connect();
		$this->current_object = null;
		$this->next_id = null;
	}

//Part 1 : CONTROL
	public function doAction() {

$start_time = microtime(true);

if($this->db->db_connect_id==false) {
			$this->html_page->displayError($this->action,t('Failed_db_connection','DataObject'));
			return;
		}
 
		if(!Policy::isActionAllowed($this->db,$this->action,$this->table,$this->params['id'])) {
			$this->html_page->displayError($this->action,t('Unauthorized','DataObject'));
			return;
		}

if(strpos($this->action,'ajax')!==false ||
				strpos($this->action,'target')!==false || 
				strpos($this->action,'service')!==false || 
				strpos($this->action,'public')!==false)
			$this->html_page->layout_name = "void";
		if(strpos($this->action,'service')!==false)
			ini_set("max_execution_time", "3600");
		$this->html_page->changeTitle($this->action);
		$this->stopOldWorkflows();		
		$this->doObjectAction();
		
		$end_time = microtime(true);
		$action_time = round($end_time - $start_time,4);
		$this->html_page->debug_txt .= sprintf('doAction() : %.3fs, ',$total_time);
		//visits
		Visit::add($this,$this->action,
			$this->table,$this->params,$this->query_string, $action_time);

}
	
	/* do the action, without verifying allowance */
	protected function doObjectAction() {
		switch($this->action){
		case 'see_list':			
			$this->displayList();
			$this->html_page->changeTitle("see_list");
			break;
		case 'see_list_by':
			$this->displayListBy($this->params['previous_table'],$this->params['id']);
			break;
		case "insert":
			$this->html_response .= $this->getDataFormHtml(INSERT);
			break;
		case "insert_by":
			$this->html_response .= $this->getDataFormHtml(INSERT,$this->params['id'],
				$this->params['previous_table']);
			break;
		case "validate_insert":
			$this->validateInsert();
			$this->html_page->changeTitle("insert");
			break;
		case "insert_massive":
			$this->displayInsertMassiveForm();
			break;
		case "validate_insert_massive":
			$this->validateInsertMassive();
			$this->html_page->changeTitle("insert");
			break;
		case "display_massive_csv":
			$this->displayMassiveCsv();
			break;
		case "update":
			$this->html_response .= $this->getDataFormHtml(UPDATE,$this->params['id']);
			break;
		case "validate_update":
			$this->validateUpdate();
			$this->html_page->changeTitle("update");
			break;
		case "clone":
			$id = $this->duplicate($this->params['id']);
			$this->html_response .= $this->getDataFormHtml(UPDATE,$id);
			break;
		case "delete":
			$this->delete($this->params['id']);
			break;
		case "validate_delete":
			$this->validateDelete($this->params['id']);
			$this->html_page->changeTitle("delete");
			break;
		case "see":
			$this->html_response .= $this->getDataFormHtml(SEE,$this->params['id']);
			break;
		case "search":
			$this->html_response .= $this->getDataFormHtml(SEARCH);
			break;
		case "validate_search":
			$this->validateSearch();
			$this->html_page->changeTitle("search");
			break;
		case "print":
			$this->html_page->doPrint($this->params['id']);
			//$this->displayList();
			$this->html_response .= $this->getDataFormHtml(SEE,$this->params['id']);
			$this->html_page->changeTitle("see");
			break;
		case "send":
			$this->displaySendForm($this->params['id']);
			break;
		case "validate_send":
			$this->validateSend();
			$this->html_page->changeTitle("send");
			break;
		case 'regen':
			$this->generateFile();
			$this->html_response .= $this->getDataFormHtml(SEE,$this->params['id']);
			$this->html_page->changeTitle("see");
			break;
		case 'receipt':
			$this->receipt($this->params['id']);
			$this->html_page->changeTitle("update");
			break;
		case 'stop_workflow':
			$this->stopWorkflow($this->params['key']);
			$this->displayList();
			break;				
		case 'ajax_see_list':
			$this->displayListAjax();
			break;
		//see a sample of this in receipt
		case 'ajax_get_object_map':
			$this->displayObjectMapAjax($this->params['table'],$this->params['id']);
			break;				
		case 'ajax_get_object_map_list':
			$this->displayObjectMapListAjax($this->params['table']);
			break;						 
		default : //error
			$this->html_page->displayError($this->action,"fonction inconnue : ".$this->action);
		}
	}

//Part 2 : VIEW

/*
	 */
	public function displayList($args = array(),$current_id=0) {
		if(count($args)==0)
			$args = $this->getDisplayArgs();
		$records = $this->getList($args);

$mlt_pages_HTML = "";
		
		//google style numbers
		if (isset($args['limit_nb']))
			$nb_records = $args['limit_nb'];
		else
			$nb_records = DATAOBJECT_NBRECORDS_SEE_LIST;
		
		$count = $this->getCount($args);
		if($count>DATAOBJECT_NBRECORDS_SEE_LIST) {
			//if(count($records) == $nb_records || $args['limit_start']>0) {
			$mlt_pages_HTML.= '<tr><td colspan="'.(DATAOBJECT_NBITEM_SHOW_SEE_LIST-1).'">';		
			$nb_pages = floor(($count-1)/$nb_records)+1;
			$nb_records_max = $nb_records*DATAOBJECT_NBPAGES_SEE_LIST;
			for($n=0 ; $n<$nb_pages; $n++) {				
				$start = $n * $nb_records;				 
				if($start == $args['limit_start'])
					$mlt_pages_HTML.= ' <span style="font-size:120%">'.($n+1)."</span> |";
				else {					
					if($nb_pages>DATAOBJECT_NBPAGES_SEE_LIST &&
							($start<$args['limit_start']-$nb_records_max/4 ||
							$start>$args['limit_start']+$nb_records_max/4) &&
							$start<$count-$nb_records_max/4 &&
							$start>$nb_records_max/4)
						if(floor($start/$nb_records) % 
								floor(1+$nb_pages/DATAOBJECT_NBPOINTS_SEE_LIST)==0)
							$html_text = ".";
						else
							$html_text = ""; //invisible
					else
						$html_text = ' '.($n+1).' |';
					if($html_text!="")
						$mlt_pages_HTML.= '<a href="'.$this->html_page->getURL("see_list",$this->table,"",
							$this->mergeArgs($args,array('limit_start'=>$start))).'">'.$html_text.'</a>';
				}
			}
			$mlt_pages_HTML.= " (".$count." ";
			$mlt_pages_HTML.= t('Total','DataObject');
			$mlt_pages_HTML.= ")</td><td>";
			foreach (self::$DATAOBJECT_LIMIT_NBRECORDS_SEE_LIST as $i=>$limit_value) {
				$mlt_pages_HTML.= '<a href="'.$this->html_page->getURL("see_list",$this->table,"",
					$this->mergeArgs($args,array('limit_nb'=>$limit_value,'limit_start'=>""))).
					'">'.$limit_value.'</a>';
				if ($i != count(self::$DATAOBJECT_LIMIT_NBRECORDS_SEE_LIST)-1)
					$mlt_pages_HTML.= ' | ';
			}
			$mlt_pages_HTML.= "</td></tr>\n";
		}

$i = 0;
		$this->displayActions($this->action,$current_id);
		$this->html_response.= '<table cellspacing="0" class="mainTable">'."\n".$mlt_pages_HTML;

$shown_fields = array();
		$class="";
		foreach($records as $record) {
			$this->current_object = $record;
			$j = 0;

//header cells
			if ($i == 0) {
				$class = $this->html_page->altColor($class);
				$this->html_response.= "<tr ".$class.">\n";			
				foreach ($record as $index => $value) {
					if( ($j > 0) && ($j < DATAOBJECT_NBITEM_SHOW_SEE_LIST)) {
					 $field_name = $this->html_page->getTextHTML($this->getNameFromFieldname($index));
						if($field_name!='') {
							if(isset($args['order'])&&stripos($args['order'],$index)!==false &&
									stripos($args['order'],$index." DESC")===false &&
									stripos($args['order'],",".$index)===false)
								$key_order = $index." DESC";
							else
								$key_order = $index; 
							$this->html_response.= '<th><a href="'.
								$this->html_page->getURL("see_list",$this->table,"",
									$this->mergeArgs($args,array('order'=>$key_order))).'" style="display:block">'.
								$field_name."</a></th>";
							$shown_fields[$index] = true;
						}
					}
					$j++;
				}
				$class = $this->html_page->altColor($class);
				$this->html_response.= '<th>'.t('Actions','DataObject').'</th></tr>'."\n";
			}

$class = $this->html_page->altColor($class);
			$this->displayListLine($record,$shown_fields,$class);
			$i++;
		}
		if(count($records)==0)
			$this->html_response.= '<tr class="tr2"><td>'.t('No_document','DataObject').'</td></tr>';
		$this->html_response.= $mlt_pages_HTML.'</table>';
		//visits
		$this->query_string = html_entity_decode($this->html_page->getUrl(
			"see_list",$this->table,"",$args));
	}
	
	protected function displayListLine($record,$shown_fields,$class) {
		$this->html_response .= "<tr ".$class.">\n";
		$j = 0;
		$popup_html = "<table>";
		$class = "";
		foreach ($record as $index => $value) {
			if(isset($shown_fields[$index])) {
				$field_html = $this->getFieldHtml($index,SEE_LIST,$value);
				if($field_html!==null) {
					if($field_html=="")
						$field_html=" ";
					$this->html_response .= "<td>".$field_html."</td>";
				}
			}
			elseif ($j==0) {
				$id = $value;
			} 
			elseif(!(substr($index,2,3)=='_id') && (is_string($value) || is_numeric($value))) {
				$field_html = $this->getFieldHtml($index,SEE_LIST,$value);
				$field_name = $this->html_page->getTextHTML($this->getNameFromFieldname($index));
				$popup_html .= "<tr ".$class."><th>".$field_name."</th>".
					"<td>".$field_html."</td></tr>";
				$class = $this->html_page->altColor($class);
			}
			$j++;
		}
		$popup_html .= "</table>";
		$this->html_response.= "<td>".
			'<a href="'.$this->html_page->getUrl('see',$this->table,'&id='.$id).'" '.
			'style="cursor:pointer" '. 
			'onmouseover="$(\'content_div_'.$table_name.$id.'\').style.display=\'block\'" '.
			'onmouseout="$(\'content_div_'.$table_name.$id.'\').style.display=\'none\'">'.
			t('See','DataObject').'</a>'.
			'<div id="content_div_'.$table_name.$id.'" class="popup">'.
			$popup_html.'</div> | '.
			'<a href="'.$this->html_page->getUrl("update",$this->table,"&id=".$id).'">'.
			t('Update','DataObject').'</a> | '.
			'<a href="'.$this->html_page->getUrl("delete",$this->table,"&id=".$id).'">'.
			t('Delete','DataObject').'</a></td>'.
			"</tr>\n";
	}

public function displayListBy($previous_table, $previous_id = 0, $args = array(), $real_field = "") {
		if(!Policy::canDo("contact.see"))
			return;
		if($previous_id==0)
			return $this->displayList($args);
/*		$used_field = $this->getPrefix().'_'.$previous_table;
		if($real_field!="")
			$used_field = $real_field;
		$args = $this->mergeArgs($this->getDisplayArgs(),
			array('filter'=>' AND ('.$used_field.' = '.$previous_id.')')); */ 
	
		$args = $this->getByArgs($previous_table, $previous_id, $real_field);
		if($this->getCount($args)==1) {
			$list = $this->getList($args);
			$id = array_i($list[0],0); 
			$this->html_response .= $this->getDataFormHtml(SEE,$id);
		} else { // 0 or 2..oo		
			$this->displayList($args,$id);
			$record = $this->findOne($previous_table, $previous_id);
			$this->html_page->changeTitle(t("See_list_by_title","DataObject",false,
				ucfirst($this->html_page->getPlural(t($this->table."_record"))),
				$this->getDataObject($previous_table)->getDescForRecord($record))				
				,true);
		}
	}
	/*
	 similar to displayList, but return only a <select>...</select> tag
	 can contain "special" in args : current value (will put a "selected" atttribute) 
	 */
	public function displayListAjax($args = array()) {
		header('Content-type: text/html; charset=utf-8');
		if(count($args)==0)
			$args = $this->getDisplayArgs();
		$args = $this->mergeArgs($args,array('limit_nb'=>1000));
		$records = $this->getList($args);
		$this->html_response.= '<option value="0">'.t('Select_message','DataObject').
			t($this->table."_record")."</option>\n";
		$found_special = false;
		$wanted_id = 0;
		if(isset($args['special'])&&is_numeric($args['special']))
			$wanted_id = $args['special'];
		if(isset($args['wanted_table'])) { //WARN: untested
			$obj = $this->findOne($args['wanted_table'],$args['wanted_id']);
			if($obj!=null&&isset($obj[$args['wanted_field']]))
				$wanted_id = $obj[$args['wanted_field']];			
		}		
		foreach($records as $row) {
			$id = array_i($row,0); //id is the first data of each row
			if($id==$wanted_id)
				$found_wanted = true;		 
		}			
		$is_first = true;
		foreach($records as $row) {			
			$id = array_i($row,0);
			if(($id==$wanted_id) ||
					(!$found_wanted&&$is_first))
				$selected_txt = ' selected="selected" ';
			else		
				$selected_txt = '';			 
			$this->html_response.='<option value="'.$id.'"'.$selected_txt.'>'.
				$this->getDescForRecord($row).'</option>'."\n";
			$is_first = false;
		}
	}

//display the upper panel withs actions
	public function displayActions($display_type="",$id = 0) {
		if($display_type=="")
			$display_type=SEE_LIST;
		$actions = $this->getNextActions($id);
		$sep = "";
		$this->html_response.= '<div class="actions">';
		foreach($actions as $action) {
			if($action['ac_name']!="*") {
				$target_HTML = "";
				if(substr($action['ac_name'],0,6)=='target')
					$target_HTML = ' target="_blank" ';
				$others = "";
				if($action['ac_previous']!='*')
					$others .= "&previous=".$this->action;
				if($action['ac_previous_table']!='*')
					$others .= "&previous_table=".$this->table;				
				if($action['ac_is_id_needed']=='on')
					$others .= "&id=".$id;
				if($action['ac_name']=='insert'&&$this->action=='see_list_by') {
					$action['ac_name']='insert_by';
					$others='&previous_table='.$this->params['previous_table'].'&id='.$this->params['id'];
				} 
				$text = $this->html_page->getTextHtml($action['ac_label']);				
				if($action['ac_name']=="see_list_by" && $id>0) {
					$other_object = $this->getDataObject($action['ac_table']);				
					$args = $other_object->getByArgs($this->table,$id); 
					$text .= " (".$this->getCount($args,$action['ac_table']).")";
				}				
				$this->html_response.= $sep.'<a href="'.
					$this->html_page->getURL($action['ac_name'],$action['ac_table'],$others).
					'" '.$target_HTML.'>'.$text.'</a>';
				$sep = " | ";
			}
		}
		$this->html_response.= '</div>';
	}

//display a form (or, in case of SEE, just the data)
	//id is the object id for any display type but if $other_table_for_id!=null
	//if $other_table_for_id==null, $id is the id of an object of this table
	public function getDataFormHtml($display_type,$id=0,$other_table_for_id=null) {
		if(!Policy::canDo("contact.see"))
			return;

$res_html = "";
		$sql = "SELECT * FROM ".$this->table." LIMIT 1";
		$result = $this->db->sql_query($sql);
		$other_id = 0;
		if($id>0 && $other_table_for_id!=null) {
			$other_id = $id;
			$id = 0;
		}
		if($id>0) {
			$sql = "SELECT * FROM ".$this->table.
				" WHERE ".$this->db->sql_fieldname(0,$result)."=".$id;
			$result = $this->db->sql_query($sql);
			if($result==NULL || $this->db->sql_numrows($result)==0) {
				$this->html_page->displayError("see",t("No_document","DataObject"));
				return "";
			} 
		}
		
		$next_action_tab = array("insert"=>"validate_insert","search"=>"validate_search",
			"update"=>"validate_update");
		if($display_type==INSERT || $display_type==UPDATE || $display_type==I_MASSIVE)
			$res_html .= '<form enctype="multipart/form-data" id="form1" '.
				'name="form1" method="post" action="'.
				$this->html_page->getURL($next_action_tab[$display_type], $this->table).'">';
		if($display_type==SEARCH)
			$res_html .= '<form id="form1" name="form1" method="get" action="'.
				$this->html_page->getURL($next_action_tab[$display_type], $this->table).'">'.
				'<input type="hidden" name="table" value="'.$this->table.'" />'.
				'<input type="hidden" name="action" value="'.$next_action_tab[$display_type].'" />';								
		if(($display_type==INSERT || $display_type==UPDATE) && $id>0)
			$res_html .= '<input type="hidden" name="'.
				$this->db->sql_fieldname(0,$result).
				'" value="'.$id.'" />';
		if(($display_type==INSERT || $display_type==UPDATE) && isset($this->params['opener_field_name']))
			$res_html .= '<input type="hidden" name="opener_field_name" '.
				'value="'.$this->params['opener_field_name'].'" />';
		$class="";		
		$this->displayActions($this->action,$id);
		$res_html .= '<table id="formTable" cellspacing="0" cellpadding="0">';
		$class = $this->html_page->altColor($class);

$i = 1;
		$row = $this->db->sql_fetchrow($result);
		$this->current_object = $row;
		if($id==0 && $this->current_object!=null)
			foreach($this->current_object as $k=>$v_unu)
				$this->current_object[$k] = ""; //as $row is a random object
		while ($name = $this->db->sql_fieldname($i,$result)){
			//displaying the fields
			switch($display_type) {
			case INSERT:
			case SEARCH:
				//verify special case, if it is a insert_by or search_by
				if($other_id>0 && 
						$this->getTableNameFromForeignFieldname($name)==$other_table_for_id)
					$field_html = $this->getFieldHtml($name, $display_type, $other_id);
				else
					$field_html = $this->getFieldHtml($name, $display_type);
				break;
			case UPDATE:
			case SEE:
			case SEE_LIST: 
				$field_html = $this->getFieldHtml($name,$display_type,$row[$name]);
				break;
			}
			
			if($field_html!==null) {
				$res_html .= '<tr'.$class.'><th scope="row">';
				$res_html .= $this->html_page->getTextHTML(
					$this->getNameFromFieldname($name)
				);
				$res_html .= '</th>';
				if($field_html=="")
					$field_html=" ";
				$res_html .= '<td>'.$field_html.'</td></tr>'."\n";	
				$class = $this->html_page->altColor($class);
			}
			$i++;
		}
		if($display_type!=SEE && $display_type!=SEE_LIST)
			$res_html .= '<tr'.$class.'><th colspan="2">'.
				$this->getSubmitButtonHtml($display_type)."</th></tr>\n</table>\n</form>";
		else
			$res_html .= "\n</table>\n";
		
	/*attente*/
	
	if($id>0 && $this->action == SEE) { //$this->table != "command" &&
		$class = "";
		$class = $this->html_page->altColor($class);
		$res_html .= "<br /><b>Dernières Versions : </b>";
		//table modification
		
		if($this->table == "command")
			$limit = "LIMIT 0,10";
		else
			$limit = "LIMIT 0,5";
		
		$sql = "SELECT mo_table, mo_field, mo_value_varchar, mo_value_text, mo_value_int, 
									 mo_value_double, mo_value_datetime, mo_datetime, co_name, co_firstname 
				FROM modification, contact 
						WHERE contact.co_id = modification.mo_contact 
				AND mo_object_id = '$id' 
				AND mo_table = '$this->table'
				ORDER BY mo_id DESC 
				".$limit."";
		$result = $this->db->sql_query($sql);
		if($result) {
			$tp .= "<table>";
			$tp .= "<tr><th>Date</th><th>Champ</th><th>Ancienne Valeur</th><th>Auteur</th></tr>";
			while($row = $this->db->sql_fetchrow($result)) {
				$update_time = $this->html_page->getDateHtml($row['mo_datetime'],true,true);
			if($class == "") {
			$tp .= "<tr>";
			$class = $this->html_page->altColor($class);
			} else {
			$tp .= " <tr ".$class.">";
			$class="";
			}
			
			if($this->getNameFromFieldname($row['mo_field']) == 'Id')
				$champ = "Création ";
			else
				$champ = $this->getNameFromFieldname($row['mo_field']);
			
			if($row['mo_value_varchar'] != ''){
				if(strpos($row['mo_field'], 'file')){
				$modif = "<a href=".$this->getDirectoryName().$row['mo_value_varchar']." target='_blank'>".$row['mo_value_varchar']."</a>";
			}else
					$modif = $row['mo_value_varchar'];
			}
			elseif($row['mo_value_text'] != '')
				$modif = $row['mo_value_text'];
			elseif($row['mo_value_int'] != '')
				$modif = $row['mo_value_int'];
			elseif($row['mo_value_double'] != '')
				$modif = $row['mo_value_double'];
			elseif($row['mo_value_datetime'] != '')
				$modif = $row['mo_value_datetime'];
			
			$tp .= "<td>".$update_time."</td>
									<td>".$champ."</td>
									<td>".$modif."</td>
									<td>".$row['co_firstname']." ".strtoupper($row['co_name'])."</td></tr>";
			}
			$tp .= "</table>";
		}
		$res_html .= $tp."<br style='clear:left;' />";	
	}	
		
		if($id>0) {
			$modifications = $this->findModifications("",$id);
			if(count($modifications)>1) {
				$times = array_keys($modifications);
				$last_modif = array_i($modifications,1);
				if($last_modif['mo_contact']==0) {
					$desc = "?";
				} else {					
					$contact = $this->findOne('contact',$last_modif['mo_contact']);
					$contact_dataobject = $this->getDataObject('contact'); 
					$desc = '<a href="'.$this->html_page->getUrl('see','contact','&id='.$last_modif['mo_contact']).
						'">'.$contact_dataobject->getDescForRecord($contact).'</a>';
				}
				$res_html .= "<p>Dernière modification : ".
					$this->html_page->getDateHtml($times[1],true,true).", ".$desc;					
			}
		}	
		return $res_html;
	}

public function displayInsertMassiveForm() {
		$this->html_response.= '<form enctype="multipart/form-data" id="form1" '.
			'name="form1" method="post" action="'.
			$this->html_page->getURL('validate_insert_massive',$this->table).'">';

$this->displayActions($this->action,$id);
		$this->html_response.= '<table id="massiveFormTable" cellspacing="0" cellpadding="0">';
		$class="";
		$all_field_names = $this->getFieldNames();
		$field_names = array();
		foreach($all_field_names as $name)
			if($this->getFieldHtml($name, I_MASSIVE)!="")
				$field_names[] = $name;
				
		array_shift($field_names);//id
		$class = $this->html_page->altColor($class);
		$this->html_response.= "<tr ".$class."><th></th>\n";
		$this->current_object = array();
		foreach($field_names as $name) {
			$this->current_object[$name] = "";
			$this->html_response.= "<th>".$this->html_page->getTextHTML(
				$this->getNameFromFieldname($name)
			)."</th>";
		}
		//optimization : create one line (then replicate)
		$old_html_response = $this->html_response;
		$this->html_response = "";
		foreach($field_names as $name) {
			$field_html = $this->getFieldHtml($name, I_MASSIVE);
			$this->html_response.= "<td>".$field_html."</td>";
		}
		$inner_txt = $this->html_response;		 
		$this->html_response = $old_html_response;
		//end opt.
		//main line
		$inner_main_txt = $inner_txt;
		$class = $this->html_page->altColor($class);
		foreach($field_names as $name) {		
			$jscript_add = 'onchange="for(var i=0;i<'.DATAOBJECT_NBINSERT_MASSIVE.';i++)'.
				'\$(\''.$name.'_\'+i+\'\').value=\$F(\''.$name.'\');"';	
			$inner_main_txt = preg_replace('/name\s?=\"'.$name.'\"/',$jscript_add.' $0',$inner_main_txt);
		}
		$this->html_response.= '<tr '.$class.'><th>Ajout ?</th>'.$inner_main_txt."</tr>\n";

for($j=0;$j<DATAOBJECT_NBINSERT_MASSIVE;$j++) {		 
			$class = $this->html_page->altColor($class);
			$inner_numbered_txt = $inner_txt;
			//names with [3]
			$inner_numbered_txt = preg_replace('/name\s?=\s?\"([a-z_]+)\"/',
				'name="$1['.$j.']"',$inner_numbered_txt);
			//ids with _3
			foreach($field_names as $name)
				$inner_numbered_txt = preg_replace('/'.$name.'([\'\"])/',
					$name."_".$j."\$1",$inner_numbered_txt);
			$this->html_response.= '<tr '.$class.' '.
				'onclick="var cb=document.getElementById(\'do_insert_'.$j.'\');'.
				'if(!cb.e)cb.checked=true;">'."\n".
				'<th><input type="checkbox" name="do_insert['.$j.']" id="do_insert_'.$j.'"'. 
				'onmouseover="this.e=true;" onmouseout="this.e=false;" /></th>'.
				$inner_numbered_txt."</tr>\n";
		}
		$class = $this->html_page->altColor($class);
		$this->html_response.= '<tr'.$class.'><th colspan="'.(count($field_names)+1).'">'.
			'Ou choisisser le fichier csv à importer : '.
			$this->getFieldHtmlFile("csv",I_MASSIVE).
			'<a href="'.$this->html_page->getURL("display_massive_csv",$this->table).
			'">Télécharger le modele pour '.$this->table."</a></th></tr>\n";
		$class = $this->html_page->altColor($class);
		$this->html_response.= '<tr'.$class.'><th colspan="'.(count($field_names)+1).'">'.
			$this->getSubmitButtonHtml($display_type)."</th></tr>\n</table>\n</form>";	
	}
	
	protected function getFieldNames($table = "") {
		if($table=="")
			$table = $this->table;
		$sql = "SELECT * FROM ".$table." LIMIT 1";
		$result = $this->db->sql_query($sql);
		$row = $this->db->sql_fetchrow($result);
		$i = 0;
		while ($name = $this->db->sql_fieldname($i,$result)) {			
			$field_names[] = $name;
			$i++;
		}	 
		return $field_names;
	}

/* Displaying one field being aware of his type and what need to be displayed
	 * fieldname: name of the field
	 * displaytype: INSERT/I_MASSIVE/SEARCH/UPDATE/SEE/SEE_LIST
	 * updateValue (opt): current content
	 */
	public function getFieldHtml($field_name,$display_type, $update_value="") {
		$is_foreign = false;
		foreach($this->db->sql_listtables() as $table)
			if($this->getTableNameFromForeignFieldname($field_name)==$table)
				$is_foreign = true;
		if($is_foreign)
			return $this->getFieldHtmlForeign($field_name,$display_type, $update_value);
		elseif(strstr($field_name, "_file")!==false)
			return $this->getFieldHtmlFile($field_name,$display_type, $update_value);
		elseif(strstr($field_name, "_date")!==false)
			return $this->getFieldHtmlDate($field_name,$display_type, $update_value);
		elseif(strstr($field_name, "_is_")!==false)
			return $this->getFieldHtmlBoolean($field_name,$display_type, $update_value);			
		elseif(strstr($field_name, "_password")!==false)
			return $this->getFieldHtmlPassword($field_name,$display_type, $update_value);
		elseif(strstr($field_name, "_country")!==false)
			return $this->getFieldHtmlCountry($field_name,$display_type, $update_value);
		else
			return $this->getFieldHtmlOther($field_name,$display_type, $update_value);
	}

/**
	 *	foreign fields are field corresponding to id of other tables
	 *	filter : "AND ..."
	 */
	protected function getFieldHtmlForeign($field_name,$display_type,$update_value="",$filter="",$args=null) {
		$res = "";
		$table = $this->getTableNameFromForeignFieldname($field_name);
		if($args==null)
			$args = $this->getDataObject($table)->getDefaultArgs();
		elseif(!isset($args['order'])||$args['order']=='')
			$args = $this->mergeArgs($this->getDataObject($table)->getDefaultArgs(),$args);		
		if($display_type==SEARCH) {
			$id_fieldname = $this->getPrefix($table)."_id";
			$filter .= ' AND '.$id_fieldname.' IN '.
				'(SELECT '.$field_name.' FROM (SELECT DISTINCT '.$field_name.' FROM '.$this->table.') unu)';
			$count = $this->getDataObject($table)->getCount(
				$this->mergeArgs($args,array('filter'=>$filter,'limit_nb'=>10000)),$table);
			$records = $this->getDataObject($table)->getList(
				$this->mergeArgs($args,array('filter'=>$filter,'limit_nb'=>10000)),$table);		 
		} elseif($display_type==SEE || $display_type==SEE_LIST) {
			$found=null;
			if($update_value>0)
				$found = $this->getDataObject($table)->findOne($table, $update_value);
			if($found==null)
				return "";
			$records = array($found);
		} else {			
			$records = $this->getDataObject($table)->getList(
				$this->mergeArgs($args,array('filter'=>$filter,'limit_nb'=>10000)),$table);			 
		}
		if($display_type!=SEE && $display_type!=SEE_LIST) {
			$res.= '<select name="'.$field_name.'" id="'.$field_name.'" '.
				$this->getFieldSpecialAttributes($field_name,$display_type,$update_value).'>';
			 //fill the default option with something usefull
			if($display_type==I_MASSIVE)
				$text = ucfirst(t($table."_record"))." ?";
			else
				$text = t('Select_message','DataObject').t($table."_record");
			$res.= '<option value="0">'.$text."</option>\n";
		}
		foreach($records as $n=>$selection) {
			$desc = $this->getDataObject($table)->getDescForRecord($selection);
			switch($display_type) {
			case SEARCH:
			case INSERT:
			case I_MASSIVE:
			case UPDATE:
				if($display_type==I_MASSIVE && mb_strlen($desc)>32) {
					$desc_dec = $this->html_page->getTextNotHTML($desc);
					$desc_dec = mb_substr($desc_dec,0,16)."...".mb_substr($desc_dec,-13);
					$desc = $this->html_page->getTextHtml($desc_dec);
				}

//autoselect the option if it was already used
				$css_class = "";
				if(($n/10)%2==0)
					$css_class = ' class="alt" ';
				$selectect_html = "";
				if(array_i($selection,0)==$update_value)
					$selectect_html = ' selected="selected" '; 
				$res.= '<option value="'.array_i($selection,0).'" '.$selectect_html.$css_class.'>'.$desc."</option>\n";
				break;
			case SEE:
			case SEE_LIST:
				$res.= '<a href="'.
					$this->html_page->getUrl("see",$table,"&id=".$update_value).
					'">'.$desc.'</a>';
			}
		}
		if($display_type!=SEE && $display_type!=SEE_LIST)
			$res.= "</select>\n";
		if($display_type==INSERT||$display_type==I_MASSIVE||$display_type==UPDATE)
			$res.= '<a target="_blank" href="'.
				$this->html_page->getUrl('insert',$table,'&opener_field_name='.$field_name).
			'">+</a>'."\n";
		return $res;
	}

protected function getFieldHtmlFile($field_name,$display_type,$update_value="") {
		$res = "";
		if($update_value=='') {
			$file_string = t('No_file','DataObject');
			$edit_html = "";
		} else {
			$file_string = '<a href="'.$this->getDirectoryName().stripslashes($update_value).'"'.
				' target="_blank">'.
				$this->html_page->getTextHTML(stripslashes($update_value)).'</a>';
			$edit_html = ' <a href="'.$this->html_page->getUrl('update','file',
				'&name='.$this->table."/".stripslashes($update_value).'&dir=files').'" '.
				'target="_blank">('.t('Edit','DataObject').')</a>';
		}
		$spe_attrs = $this->getFieldSpecialAttributes($field_name,$display_type,$update_value);
		$end_html = ' name="'.$field_name.'" size="32" id="'.$field_name.'" '.$spe_attrs.'/>';		
		$checkbox_name = 'check'.$field_name;
		$new_empty_file_html = '<input type="checkbox" name="'.
			'check_new'.$field_name.'" />'.t('New_empty_file','DataObject');		
		switch($display_type) {
		case INSERT:
			$res.= '<input type="file"'.$end_html.$new_empty_file_html;
			break;
		case I_MASSIVE:
			$res.= '<input type="file"'.$end_html;
			break;
		case SEARCH:
			$res.= '<input type="text"'.$end_html;
			break;
		case UPDATE:			
			$res.= '<input type="file" ';
			if($update_value!="")
				$res .= ' onchange="$(\''.$checkbox_name.'\').checked = true;" ';
			$res .= $end_html;
			if($update_value!=""){
				$res .= '<input type="checkbox" name="'.$checkbox_name.'" '.
					'id="'.$checkbox_name.'" />';
				$res.= t('Delete_old_file','DataObject')." ".$file_string.$edit_html;
			} else
				$res .= $new_empty_file_html;
			break;
		case SEE:
			$res.= $file_string.$edit_html;
			break;
		case SEE_LIST:
			$res.= $file_string;
		}
		return $res;
	}

protected function getFieldHtmlDate($field_name,$display_type,$update_value="") {
		//no date : now
		$res = "";
		$has_time = strpos($field_name,"datetime")==3;
		if(($display_type==INSERT||$display_type==I_MASSIVE)&&$update_value==="")
			if($has_time)
				$update_value = date("Y-m-d H:i");
			else
				$update_value = date("Y-m-d");
		if($display_type==UPDATE && strpos($update_value,"0000-00-00")===0)
			$update_value = "";
		//writing readonly : user friendly date
		if($display_type==SEE || $display_type==SEE_LIST)
			if($update_value==0)
				$update_value = "-";
			else
				if($has_time)
					$update_value = $this->html_page->getDateHTML($update_value,true,true,true);
				else
					$update_value = $this->html_page->getDateHTML($update_value,false,true,true);
		$size = 8;
		if($has_time)
			$size = 14;
		$res.=$this->getFieldHtmlOther($field_name,$display_type,$update_value,$size);
		$has_time_js = "false";
		if($has_time)
			$has_time_js = "true";	
		if($display_type!=SEE && $display_type!=SEE_LIST) {
			$res.= '<a href="javascript:NewCal(\''.$field_name.'\','.
				'\'yyyymmdd\','.$has_time_js.',24,'.t('wday_start_week').')">'.
				'<img src="images/cal.gif" border="0" alt="Choisir une date" style="float:none" /></a>';
		}
		return $res;
	}

protected function getFieldHtmlBoolean($field_name,$display_type,$update_value="false") {
		$res = "";
		$bool_value = $update_value!="false" && $update_value!="no" && $update_value!=""; 
		if($display_type==SEE || $display_type==SEE_LIST)
			if($bool_value)
				$res.= t('Yes','DataObject');
			else
				$res.= t('No','DataObject');
		else {
			$res .= '<input type="checkbox" ';
			if($bool_value)
				$res .= 'checked="checked" ';
			$spe_attrs = $this->getFieldSpecialAttributes($field_name,$display_type,$update_value);
			$res .= ' name="'.$field_name.'" id="'.$field_name.'" '.$spe_attrs.'/>';	
		}
		return $res;
	}

//password ; use md5.js
	protected function getFieldHtmlPassword($field_name,$display_type,$update_value="") {
		$res = "";
		switch($display_type) {
		case INSERT:
		case I_MASSIVE:
		case UPDATE:
			$res .= '<input type="password" name="'.$field_name.'" id="'.$field_name.'" '.
				'value="'.$this->html_page->getTextHTML(stripslashes($update_value)).'" '.
				'onchange ="this.value=MD5(this.value)" '. 
				$this->getFieldSpecialAttributes($field_name,$display_type,$update_value).' />';
			//insert type, we need some additionnal information
			break;
		case SEE:
		case SEE_LIST:
		case SEARCH:
			$res.= '****';
			break;
		}
		return $res;
	}
	
	protected function getFieldHtmlCountry($field_name,$display_type,$update_value="") {
		$countries = t('countries');
		return $this->getFieldHtmlSelection($field_name,$display_type,
			array_combine($countries,$countries),$update_value);
	}

//other : simple text fields (or numeric)
	protected function getFieldHtmlOther($field_name,$display_type,$update_value="",$size=32) {
		$res = "";
		switch($display_type) {
		case INSERT:
		case I_MASSIVE:
		case UPDATE:
		case SEARCH:
			if($display_type==I_MASSIVE && $size=32)
				$size = 8;
			$res .= '<input type="text" name="'.$field_name.'" id="'.$field_name.'" '.
				'value="'.$this->html_page->getTextHTML(stripslashes($update_value)).'" '.
				$this->getFieldSpecialAttributes($field_name,$display_type,$update_value).
				' size="'.$size.'" />';
			//insert type, we need some additionnal information
			if (strstr( $field_name, "reference"))
				$res .= t('Reference_message','DataObject');
			break;
		case SEE:
			if(strip_tags($update_value)==$update_value)
				$res .= nl2br(stripslashes($update_value));
			else
				$res .= stripslashes($update_value);
			 break;
		case SEE_LIST:
			$res .=
				$this->html_page->getShortTextHTML($update_value,DATAOBJECT_SIZE_CONTENT_SHOW_SEE_LIST);
		}
		return $res;
	}

/* used only when asked by a subclass (depending on the fieldname) 
		$values : array of value=>label (displayed text), or only value (label
		found so in translation files)
	*/
	protected function getFieldHtmlSelection($field_name,$display_type,$values,$update_value="") {
		$res = "";
		if($display_type!=SEE && $display_type!=SEE_LIST) {
			$res .= '<select name="'.$field_name.'" id="'.$field_name.'" '.
				$this->getFieldSpecialAttributes($field_name,$display_type,$update_value).'>';
			if($display_type==SEARCH) {
				$res .= '<option value="">'.t('Select_message','DataObject').
					$this->getNameFromFieldname($field_name)."</option>\n";
			}
			foreach($values as $key => $value) {
				if(is_int($key) && isset($values[0]) && isset($values[1])) {					
					$key = $value;
					if($value!="")
						$value = t($field_name."_".$value);
				}
				$select_text = '';
				if($key===$update_value)
					$select_text = ' selected="selected" ';
				$res .= '<option value="'.$key.'" '.$select_text.'>'.
					$this->html_page->getTextHTML($value).'</option>';	
			}
			$res .= '</select>';
		} else {
			if(isset($values[$update_value]))
				$res .= DataObject::getFieldHtmlOther($field_name,$display_type,$values[$update_value]);
			else
				$res .= DataObject::getFieldHtmlOther($field_name,$display_type,$update_value);
		}
		return $res;
	}

// used only when asked by a subclass (depending on the fieldname)
	protected function getFieldHtmlBigText($field_name,$display_type,$update_value="",$rows=DEFAULT_TEXTAREA_ROWS) {
		switch($display_type) {
		case INSERT:
		case UPDATE:
			return '<textarea name="'.$field_name.'" id="'.$field_name.
				'" rows="'.$rows.'" cols="'.DEFAULT_TEXTAREA_COLS.'"'.
				$this->getFieldSpecialAttributes($field_name,$display_type,$update_value).'>'.
				$update_value.'</ textarea>'; //no stripslashes !
		case SEARCH:			
			return DataObject::getFieldHtmlOther($field_name,$display_type,$update_value);			
		case I_MASSIVE:
			return DataObject::getFieldHtmlOther($field_name,$display_type,$update_value);
		case SEE:
			if(strpos($update_value,"<br")===false && strpos($update_value,"<p")===false)
				return '<div class="bigtext">'.nl2br($update_value).
					'</div>'; //class bigtext to create
			else
				return '<div class="bigtext">'.$update_value.'</div>';
		case SEE_LIST:
			return
				$this->html_page->getShortTextHTML($update_value,DATAOBJECT_SIZE_CONTENT_SHOW_SEE_LIST);
		}
	}

// use it from subclasses
	protected function getFieldHtmlDuration($field_name,$display_type,$update_value="") {
		if(($display_type==INSERT||$display_type==I_MASSIVE) && $update_value=="")
			$update_value = 0;
		if($display_type!=SEARCH || $update_value!="") 
			$update_value = $this->html_page->getDuration($update_value);		
		return DataObject::getFieldHtmlOther($field_name,$display_type,$update_value,6);
	}

// not used for now
	protected function getFieldHtmlHidden($field_name,$display_type,$update_value="") {
		return '<input type="hidden" name="'.$field_name.'" '.
			'value="'.$update_value.'" />';
	}
	
	//produce a code that should be evalued by caller
	protected function displayObjectMapAjax($table,$id) {
		header('Content-type: text/html; charset=utf-8');
		$data_object = $this->findOne($table,$id);
		$this->html_response.="var objectMap = new Hash({});\n";
		if($data_object!=null) //i.e. an object
			foreach($data_object as $key => $field)
				if(!is_numeric($key))
					$this->html_response.='objectMap = objectMap.merge({'.
						$key.':"'.str_replace(array("\"","\r","\n"),array("\\\"","","\\n\"+\n\""),$field).'"}); '."\n";
	}

//produce a code that should be evalued by caller
	protected function displayObjectMapListAjax($table,$args=array()) {
		if(count($args)==0)
			$args = $this->getDisplayArgs();
		$data_objects = $this->getList($args,$table);
		header('Content-type: text/html; charset=utf-8');
		$this->html_response.="var objectMapList = [];\n";
		foreach($data_objects as $n=>$data_object) {
			$this->html_response.="objectMapList[".$n."] = new Hash({});\n";
			if($data_object!=null) //i.e. an object
				foreach($data_object as $key => $field)
					if(!is_numeric($key))
						$this->html_response.='objectMapList['.$n.'] = objectMapList['.$n.'].merge({'.
							$key.':"'.str_replace(array("\r","\n"),array("","\"+\n\""),$field).'"}); '."\n";
		}
	}

/* overide this */
	public function getFieldSpecialAttributes($field_name="",$display_type=SEE,$update_value="") {
		return "";
	}

/* return html code for main submit button	*/
	protected function getSubmitButtonHtml($display_type=SEE) {
	 return '<input type="submit" value="Envoyer" onclick="'.
		'if(typeof(validate)==\'undefined\')return true; else return validate();" />';
	}
	
	public function duplicate($id) {
		$field_names = $this->getFieldNames();
		$id_field_name = array_shift($field_names);
		foreach ($field_names as $n=>$field_name) {
			if(strstr($field_name, "file")!=FALSE) {
				unset($field_names[$n]);
			}
		}
				
		$sql = "INSERT INTO ".$this->table."(".implode(",",$field_names).") SELECT ".
			implode(",",$field_names)." FROM ".$this->table." ".
			"WHERE ".$id_field_name."	= ".$id;
		$this->db->sql_query($sql);
		$this->next_id = $this->db->sql_nextid(); 
		$this->html_response .= "<h2>Modification du nouveau document</h2>";
		return $this->next_id;	 
	}

public function delete($id) {
		$this->html_response.= '<h1>'.t("Delete_question","DataObject",false,$id,$this->table).'</h1>'.
			'<a href="'.$this->html_page->getURL('validate_delete',$this->table).'&id='.$id.'">'.
			t('Delete_message1','DataObject').'</a>'.
			'<br /><br /><h1>'.t('Delete_message2','DataObject').'</h1>';
		$this->html_response .= $this->getDataFormHtml(QUICK_SHOW,$id);
	}

/* do a real insert */	
	public function validateInsert() {
		if(!Policy::canDo("contact.see"))
			return;
		$field_names = $this->getFieldNames();
		$sql = "INSERT INTO ".$this->table." VALUES (''";
		$id_field_name = array_shift($field_names); //id
		foreach($field_names as $field_name){
			if (strstr($field_name, "file")){
				$new_filename = '';
				if($_FILES[$field_name]['tmp_name']!='') {
					$new_filename = $this->html_page->getEncodedDocumentName($_FILES[$field_name]['name']);					
					if(!move_uploaded_file($_FILES[$field_name]['tmp_name'],
							$this->getDirectoryName().$new_filename))
						$this->html_page->displayError("send",t("Failed_insert","DataObject",
							false,$this->getDirectoryName().$new_filename));	
				} elseif(isset($_POST['check_new'.$field_name])) {
					$new_filename = $this->html_page->getEncodedDocumentName(
						$this->table.substr(md5(time().$field_name),0,8).'.txt');
					$f = fopen($this->getDirectoryName().$new_filename,"w");
					fputs($f," ");
					fclose($f);
				}
				$sql.= ', \''.addslashes($new_filename).'\'';
			} elseif(strstr($field_name, "password")!==false && 
						strlen($_POST[$field_name])<32) {
				$sql .= ', \''.md5(trim($_POST[$field_name])).'\'';
			} else { 
				$v = addslashes(trim($_POST[$field_name]));
				if(preg_match("/^(\d+)[:h'](\d+)(.*)/",$v,$matches)>0) //duration 
					$v = $matches[1]+$matches[2]/60;
				$sql .= ',\''.$v.'\' ';
			}
			$i++;
		}

$sql.= ')';

$id = 0;
		if($this->db->sql_query($sql)){
			$id = $this->next_id = $this->db->sql_nextid();
			$this->html_response .= "<h2>".t("Insert_message","DataObject",false,$this->table)."</h2>";
			$this->html_response .= $this->getDataFormHtml(QUICK_SHOW,$id);
			if(isset($_POST['opener_field_name']))
			$this->html_page->javascript_items .= 'var sel = window.opener.document.getElementById("'.
				$_POST['opener_field_name'].'")'."\n".
				'for (var i=0; i<sel.options.length; i++) sel.options[i].selected = false;'."\n".
				'sel.options[sel.options.length] = new Option("'.
				$this->getDescForRecord($this->findOne(null,$id)).' (nouveau)",'.$id.');'."\n".
				'sel.options[sel.options.length-1].selected = true;'."\n";
			$sql2 = 'INSERT INTO modification(mo_table, mo_field, mo_object_id, '.
				'mo_datetime, mo_value_int, mo_contact) VALUES ('.
				'"'.$this->table.'","'.$id_field_name.'",'.$id.',"'.date('Y-m-d H:i:s',time()).'",'.
				$id.','.$_SESSION['user']['co_id'].")";
			$this->db->sql_query($sql2);
		} else {
			$this->html_page->displayError("send",t("Failed_insert","DataObject")." - ".$sql);
		}
	}

public function validateInsertMassive() {
		if(!Policy::canDo("contact.see"))
			return;

$field_names = $this->getFieldNames();
		array_shift($field_names); //id
		$old_response = $this->html_response;
		
		if ($_FILES['csv']['type']=="text/comma-separated-values") {
			$all_field_names = $this->getFieldNames();
			$field_names = array();
			foreach($all_field_names as $name)
				if($this->getFieldHtml($name, I_MASSIVE)!="")
					$field_names[] = $name;
			array_shift($field_names);//id
			
			$handle = fopen($_FILES['csv']['tmp_name'], "r");
			
			//Verify if the column nane of the first line correspond to table structure
			$data = fgetcsv($handle, 0, ',', '"');
			foreach ($data as $i => $column_name) {
				if ($field_names[$i]!=$column_name) {
					$this->html_response = "Fichier CSV non valide!";
					return;
				}
			}
			
			$row = 0;
			while (($data = fgetcsv($handle, 0, ',', '"')) !== FALSE) {
				//$num = count($data);
				foreach($field_names as $col => $field_name){
					$error = false;
					if (empty($data[$col])) {
						$error = true;
					}
					$_POST[$field_name][$row] = htmlentities($data[$col], ENT_QUOTES,"ISO-8859-1");
				}
				if($error == false)
					$_POST['do_insert'][$row]=true;
				$row++;
			}
			fclose($handle);
			$nbr_records = $row;
		}
		else {
			$nbr_records = DATAOBJECT_NBINSERT_MASSIVE;
		}

$field_names = $this->getFieldNames();
		array_shift($field_names);//id
		$nb = 0;
		for($i=0;$i<$nbr_records;$i++) { 
			if(isset($_POST['do_insert'][$i])) {
				$sql = "INSERT INTO ".$this->table." VALUES (''";			
				foreach($field_names as $field_name){
					if($_POST[$field_name][$i]!="") {
						//no massive for password and files
						$v = addslashes(trim($_POST[$field_name][$i]));
						if(preg_match("/(\d+)[:h'](\d+)/",$v,$matches)>0) //duration 
							$v = $matches[1]+$matches[2]/60;
						$sql .= ',\''.$v.'\' ';
						$should_query = true;
					} else {
						$sql .= ',\''.$this->getDefaultValue($field_name).'\' ';
					}
				}
				$sql .=");";
				$this->db->sql_query($sql);				
				$nb++;
			}
		}
		$this->html_response = $old_response;
		$this->html_response .= "<h2>".t("Insert_massive_message","DataObject",
			false,$this->table,$nb)."</h2>";
		$this->html_response .= $this->getDataFormHtml(QUICK_SHOW,$this->db->sql_nextid());
	}
	
	public function displayMassiveCsv() {
		$this->html_page->layout_name = "void";
		$all_field_names = $this->getFieldNames();
		$field_names = array();
		foreach($all_field_names as $name)
			if($this->getFieldHtml($name, I_MASSIVE)!="")
				$field_names[] = $name;
		array_shift($field_names);//id
		
		foreach($field_names as $name)
			$csv .='"'.htmlentities($name, ENT_QUOTES,"ISO-8859-1").'",';
		$csv = substr($csv,0,-1)."\n";
		
		foreach($field_names as $key => $name)
			$csv .='"valeur'.$key.'",';
		$csv = substr($csv,0,-1)."\n";
		//echo $csv;
		
		header('Content-Disposition: attachment; filename="exemple.csv"');	
		echo html_entity_decode($csv,ENT_NOQUOTES,"ISO-8859-1"); 
	}

public function validateSearch() {
		if(!Policy::canDo("contact.see"))
			return;
		//build the filter
		$filter = "";
		$args = $this->getDisplayArgs();
		$order_value = "0";
		
		foreach($this->params as $index => $value)
			if(trim($value)!="" && $value!=="0") {
				$order_value .= "+IF(".$index."='".$value."',0,1)"; //best if exact matching
				if(is_numeric($value)) {
					$args['filter'] .= " AND ".$index."=".$value." ";					
				} else {
					$args['filter'] .= " AND ".$index." LIKE'%".addslashes($value)."%'";
				}
			}
		
		if($order_value!="0")
			$args['order'] = $order_value.",".$args['order'];
		$this->displayList($args);
		$this->html_response.="<h1>".t("New_search","DataObject")."</h1>";
		$this->html_response .= $this->getDataFormHtml(SEARCH);
	}

public function validateUpdate() {
		if(!Policy::canDo("contact.see"))
			return;		
		$all_field_names = $this->getFieldNames();
		$field_names = $all_field_names;
		$id_fieldname = array_shift($field_names);

$fields = array();
		foreach($field_names as $field_name){
			//check for a file : delete, delete&add or nothing
			$new_value = "";
			$is_set_a_value = true; 
			if (strstr($field_name, "file")!==false){
				$is_set_a_value = false;
				if(isset($_POST["check".$field_name])){ //delete
					$is_set_a_value = true;
					$new_value = '';
				}
				if($_FILES[$field_name]['tmp_name']!='') {
					$new_filename = $this->html_page->getEncodedDocumentName($_FILES[$field_name]['name']);
					if(move_uploaded_file($_FILES[$field_name]['tmp_name'],
							$this->getDirectoryName().$new_filename)) {
						$is_set_a_value = true;
						$new_value = $new_filename;
					} else
						$this->html_page->displayError("send",t("Failed_update","DataObject",
							false,$this->getDirectoryName().$new_filename));
				} elseif(isset($_POST['check_new'.$field_name])) {
					$is_set_a_value = true;
					$new_value = $this->html_page->getEncodedDocumentName(
						$this->table.substr(md5(time().$field_name),0,8).'.txt');
					$f = fopen($this->getDirectoryName().$new_value,"w");
					fputs($f," ");
					fclose($f);
				}								 
			} elseif(strstr($field_name, "password")!==false && 
						strlen($_POST[$field_name])<32) {
				$new_value = md5(trim($_POST[$field_name]));
			} else {
				$new_value = trim($_POST[$field_name]);
				if(preg_match("/^\s*(\d+)[:h'](\d+)\s*$/",$new_value,$matches)>0) //duration	
					$new_value = $matches[1]+$matches[2]/60;
			}
			if($is_set_a_value)
				$fields[$field_name] = $new_value;
		}

if($this->updateRecord($this->table,$_POST[$id_fieldname],$fields) || $some_file_uploaded) {
			$this->html_response.= "<h2>".t("Update_message","DataObject",false,$this->table).
				'</h2><br /><br /><h1>'.
				t($this->table."_record").' modifié(e)</h1>';
			$this->html_response .= $this->getDataFormHtml(QUICK_SHOW,$_POST[$id_fieldname]);
		} else { //(no modification)
			$this->html_response.= '<h1>'.t('No_modification',"DataObject").'</h1>';
			$this->html_response .= $this->getDataFormHtml(SEE,$_POST[$id_fieldname]);
		}	 
	}
 
	
	//TODO cascade deletion (ex:delete contact if entreprise deleted) : analysis and dev.
	public function validateDelete($id) {
		if(!Policy::canDo("contact.see"))
			return;
		
		if($this->deleteRecord($this->table,$id,&$nb_files_moved)){
			$this->html_response.= t('Delete_message3','DataObject',false,$nb_files_moved).'<br />';
			$this->displayList();
		} else {
			$this->html_response.= t('Query_result','DataObject')."<br />";
			$this->html_response.= $sql;
		}
		 
	}

//sending an email about a document
	public function displaySendForm($id) {
		$document_name = $this->getDocumentName($id,true);
		$user = $this->findOne("contact",$_SESSION['user']['co_id']);
		$from = $user['co_mail'];
		$name = $user['co_name'];
		$firstname = $user['co_firstname'];
		$object = $this->findOne("",$id);
		if($object==null) {
			$this->html_page->displayError("",t('No_document','DataObject'));
			return; 
		}		
		$receivers = $this->getUsualReceivers($object);
		if(count($receivers)>0) {
			$co_id = $receivers[0]['co_id'];
			$en_id = $receivers[0]['co_entreprise'];
		} else {
			$co_id = 0;
			$en_id = 0;
		} 
		$receivers_html = "";
		foreach($receivers as $row) {
			if($row['is_main_receiver']) 
				$selected_html = ' selected = "selected" ';
			else 
				$selected_html = "";
			$receivers_html.='<option '.$selected_html.' value="'.$row['co_mail'].'">'.
				$row['co_firstname']." ".$row['co_name'].", ".$row['co_mail']."</option>";		
		}		
						
		$data=array();
		$data['get_url']=$this->html_page->getUrl("validate_send",$this->table,"&id=".$id);
		$data['id']=$id;
		$data['co_id']=$co_id;
		$data['entreprise']=$en_id;
		if(file_exists($this->getDocumentName($id)))
			$data['document_info']= '<tr><td>'.t('Document','DataObject').'</td>'.
				'<td><a href="'.$document_name.'" target="_blank">'.$document_name.'</a></td></tr>';
		else
			$data['document_info']= '<tr><td colspan="2">'.t('Without_document','DataObject').'</td></tr>';
		$data['document_name_encoded']=urlencode($document_name);
		$data['name']=urlencode($name);
		$data['firstname']=urlencode($firstname);
		$data['subject']=$this->getDefaultMailSubject($id);
		$data['text']=$this->getDefaultMailText($id);
		$data['from']=$from;
		$data['receivers']=$receivers_html;
		$data['additionnal_receivers']=$this->getMailAdditionnalReceivers();
		$data['cols']=DEFAULT_TEXTAREA_COLS;
		$data['original_action']=$this->action;

$this->displayActions($this->action,$id);
		$this->html_response .= $this->html_page->getView("dataobject.send",$data);
	}

//$_POST[] should contain : id, co_id, co_name, co_firstname, co_entreprise, url, from, receivers, subject, text
	public function validateSend() {
		if(!Policy::canDo("contact.see"))
			return false;
		$additionnal_receivers = explode("\n",$_POST['additionnalReceivers']);
		$tmp = $additionnal_receivers;
		if(is_array($_POST['receivers']))
			$tmp = array_merge($_POST['receivers'],$tmp);
		$receivers = array();
		foreach($tmp as $receiver)
			if(trim($receiver)!='')
				$receivers[] = trim($receiver);
		if(count($receivers)==0) {
			$this->html_page->displayError("send",t('No_receiver','DataObject'));
			return false;
		}
		$headers = "";
		if(isset($_POST['from']) && trim($_POST['from'])!="")
			$headers .= "From: ".trim($_POST['from'])."\n";	
		for ($i=1;$i<count($receivers);$i++)
			$headers .= "CC: ".$receivers[$i]."\n";
		//It is seems that quotes is needed in the header in charset param. Outlook can't define encoding without them.

$text = $_POST['text'];
		if(isset($_POST['url']))
			$text = str_replace("\$URL",urldecode($_POST['url']),$text);
		if(isset($_POST['co_name']))
			$text = str_replace("\$name",urldecode($_POST['co_name']),$text);
		if(isset($_POST['co_firstname']))
			$text = str_replace("\$firstname",urldecode($_POST['co_firstname']),$text);

if(!$this->sendMail($receivers[0],$_POST['subject'], $text, $headers)) {
			$this->html_page->displayError("send",t('Mail_error','DataObject'));
			return false;
		}
		$this->html_response .= '<h1>'.t('Mail_message1','DataObject').'</h1>';
		
		$this->saveNoteSend($_POST['co_id'], $_POST['co_entreprise'], 
			$receivers, $_POST['url'], $_POST['text'], $_POST['original_action']);
		$this->html_response .= $this->getDataFormHtml(QUICK_SHOW,$_POST['id']);
		return true;
	}

//Part 3 : Model
	/*	
	NB : only mysql is completly valid $dbms now (a function miss everywhere else)
	*/
	public static function connect($dbms = "mysql", $bdd = DEFAULT_DB_DB, $server = DEFAULT_DB_SERVEUR,
			$login = DEFAULT_DB_LOGIN, $pwd = DEFAULT_DB_PWD) {
		include('db/'.$dbms.'.php');
		return new sql_db($server, $login, $pwd, $bdd, false);
	}

//replace new ...
	public function getDataObject($table = "") {
		if($table=="")
			return $this;
		$class_name = str_replace(" ","",ucwords(str_replace("_"," ",$table)));
		if (@class_exists($class_name))
			return new $class_name($this->html_page,"",$table);
		else
			return new DataObject($this->html_page,"",$table);
	}
	
	protected function getDefaultMailSubject($id) {
		return sprintf(t('Mail_default_subject','DataObject'),
			t($this->table."_record"));
	}

/* may contain some pseudo-attribute, beginning with $, replaced at sending time
		$URL : file sended, if any
		$name, $firstname : sender */
	protected function getDefaultMailText($id) {
		return(t('Mail_message2','DataObject'));
	}

protected function getUsualReceivers($object) {
		$en_id = 0;
		foreach($object as $k=>$v)
			if(strpos($k,"entreprise")==3)
				$en_id = $v;
		$co_id = 0;
		foreach($object as $k=>$v)
			if(strpos($k,"contact")==3)
				$co_id = $v;
		$res = array();

if($en_id!=0||$co_id!=0) {
			$sql = "SELECT co_id, co_mail, co_firstname, co_name, co_entreprise FROM contact ".
				"WHERE (co_entreprise = ".$en_id." OR co_id = ".$co_id.") ".
				"AND (co_mail <> '') AND (co_entreprise>0) ".
				"GROUP BY co_id ORDER BY co_mail";
			$result = $this->db->sql_query($sql);			
			while ($result && ($row = $this->db->sql_fetchrow($result))) { 
				$row['is_main_receiver'] = $row['co_id']==$co_id;
				$res[] = $row;
			}
		}
				
		return $res;
	}

//override it
	protected function getMailAdditionnalReceivers(){ 
		return ""; 
	}

//cm_entreprise -> entreprise
	protected function getTableNameFromForeignFieldname($field_name) {
		$s = substr($field_name,3);
		if(strpos($s,'_')!==false)
			$s = substr($s,0,strpos($s,'_'));
		return $s;
	}

// return : string to show - name of a field
	//no need for overriding, use translations (will search in table file, 
	//then in htmlpage *_record)
	//should be used more in this file
	protected function getNameFromFieldname($field_name) {
		$translation = t($field_name,ucfirst($this->table));
		if($translation!=$field_name)
			return $translation;
		else {
			$name = substr($field_name,3);
			$name_min = $name;
			if(strpos($name_min,'_')!==false) {
				$name_end = str_replace("_"," ",substr($name_min,strpos($name_min,'_')));
				$name_min = substr($name_min,0,strpos($name_min,'_'));				 
			}	 
			$translation = t($name_min.'_record');
			if($translation!=$name_min.'_record')
				return ucfirst($translation)." ".$name_end;
			else
				return ucwords(str_replace("_"," ",$name));
		}
	}

// return : string (valid html) to show enough to identify a record
	// override it
	public function getDescForRecord($record, $full_and_slow=true) {
		return $this->html_page->getShortTextHTML(array_i($record,1),50);
	}
 
 //used only by massive inserts
	protected function getDefaultValue($field_name,$display_type=SEE) {
		return "";
	}
 
 //return field frefix (eg. "co" for "contact")
	public function getPrefix($table="") {
		if($table=="") 
			$table = $this->table;
		if(isset(self::$table_prefixes[$table]))
			return self::$table_prefixes[$table];
		$sql = "SELECT * FROM ".$table." LIMIT 1";
		$result = $this->db->sql_query($sql);
		$res = substr($this->db->sql_fieldname(0,$result),0,2);
		self::$table_prefixes[$table] = $res;
		return $res;
	}

public function getDirectoryName() {
		return FILES_DIRECTORY.$this->table."/";
	}

public function getDocumentName($id,$abs_URL=false,$only_file_name=false,$suffix="") {
		if($abs_URL)
			$base = self::DOCUMENTS_PROTOCOL."://".$_SERVER['SERVER_NAME'].
				substr($_SERVER['SCRIPT_NAME'],0,strrpos($_SERVER['SCRIPT_NAME'],"/")).
				substr($this->getDirectoryName(),1); //ommitting a dot
		else if($only_file_name)
			$base = "";
		else
			$base = $this->getDirectoryName();
		$object = $this->findOne("",$id);
		if($object==null)
			return false;
		foreach($object as $k=>$v)
			if(substr($k,3)=="reference" && trim($v)!="")				
				return $this->html_page->getEncodedDocumentName($base.$v.$suffix.".html");
		$found_file_field = false;
		foreach($object as $k=>$v)
			if(strpos(substr($k,3),"file")===0 && !$found_file_field)
				if(trim($v)!="")
					return $base.$v;
				else
					$found_file_field = true;					
		return $this->html_page->getEncodedDocumentName($base.$this->table.$id.$suffix.".html");
	}

protected function getNextActions($id = 0){
		$sql_need_id = '';
		if($id==0)
			$sql_need_id = "AND (ac_is_id_needed = '') ";
		$sql = "SELECT * FROM action WHERE 1 ".
			"AND (ac_previous = '".$this->action."' OR ac_previous = '*') ".
			"AND ((ac_previous_table = '".$this->table."') OR
				((ac_table='' OR ac_table='".$this->table."') AND ac_previous_table = '*')) ".		 
			//uncomment below to show all action but the previous one	 
			//"AND (ac_name <> '".$previous."' OR (ac_table <> '".$this->table."' AND ac_table <> '')) ".
			$sql_need_id;
		$result = $this->db->sql_query($sql);
		$actions = array();
		while($result && ($action = $this->db->sql_fetchrow($result)))
			$actions[] = $action;
		 
		foreach($actions as $n1=>$a1)
			foreach($actions as $n2=>$a2)
				if($n1!=$n2 && $a1['ac_name']==$a2['ac_name'] && $a1['ac_table']==$this->table &&	$a2['ac_table']=='')
					unset($actions[$n2]);					
		$actions = Policy::getAllowedActions($actions);		
		return $actions;
	}
	
	/*unbiquitous method, return a full list of this table records*/
	public function getList($args = null, $table="") {
		if($table=="")
			$table = $this->table;
		if($args===null)
			$args = $this->getDataObject($table)->getDisplayArgs(null);
		elseif(!isset($args['order'])||$args['order']=='')
			$args = $this->mergeArgs($this->getDataObject($table)->getDefaultArgs(),$args);
		$fields = $args['fields'];
		if(trim($fields)=="")
			$fields = "*";
		$sql = "SELECT ".$fields." FROM ".$table." ".$args['join']." ".
			"WHERE 1 ".$args['filter'];			
		if(isset($args['order']))
			$sql .= " ORDER BY ".$args['order']." ";
		$limit_start = 0;
		if(isset($args['limit_start']) && trim($args['limit_start'])!="") 
			$limit_start = $args['limit_start'];
		$limit_nb = 1e6;
		if(isset($args['limit_nb'])) 
			$limit_nb = $args['limit_nb'];		
		$sql .= " LIMIT ".$limit_start.','.$limit_nb;
//echo "<br>".$sql."<br>";
		$result = $this->db->sql_query($sql);
		$records = array();
		if (!$result) {
			$error = $this->db->sql_error();
			$this->html_page->displayError(t('Sql_error','DataObject'),$error['message']." (SQL was : ".$sql.")");
			return $records; 
		}
		while ($row = $this->db->sql_fetchrow($result)) 
			$records[] = $row;

return $records;
	}

/**
	 *	 similar to getList, result : count only 
	 **/
	public function getCount($args = null, $table="") {
		if($table=="")
			$table = $this->table;
		if($args===null)
			$args = $this->getDataObject($table)->getDefaultArgs();
		elseif(!isset($args['order'])||$args['order']=='')
			$args = $this->mergeArgs($this->getDataObject($table)->getDefaultArgs(),$args);
		$sql = "SELECT count(*) as c FROM ".$table." ".$args['join'].
			" WHERE 1 ".$args['filter'];
		$result = $this->db->sql_query($sql);
		$row = $this->db->sql_fetchrow($result);
		return $row['c'];	 
	}

//can be called statically called, if $table indicated
	//filter : "AND ...."
	public function findOne($table="",$id=0,$filter="",$order="",$fields=""){
		$args = $this->getDataObject($table)->getDefaultArgs();
		if($table=="")
			$table = $this->table;
		if($order=="")
			$order = $args["order"];
		if($fields=="")
			$fields = $args['fields'];
		if($fields=="")
			$fields = "*";
		$sql = "SELECT ".$fields." FROM ".$table." ".$args['join']." WHERE 1 ";
		if($id>0)
			$sql .= " AND ".$this->getPrefix($table)."_id =".$id;
		if($fields!="*" || strpos($fields,',')==false)
			$order = "1";
		$sql .= " ".$filter." ORDER BY ".$order." LIMIT 1";
//echo $sql."\n";		
		$result = $this->db->sql_query($sql);
		if($result)
			return $this->db->sql_fetchrow($result);
		else
			return null;
	}
	
	public function findModifications($table="",$id=1) {
		if($table=="")
			$table = $this->table;
		//+1 : in case we just inserted/modified
		$now = date('Y-m-d H:i:s',time()+1); 
		$res = array($now => $this->findOne($table,$id));
		$sql = 'SELECT * FROM modification '.
			'WHERE mo_table="'.$table.'" AND mo_object_id="'.$id.'" ORDER BY mo_datetime DESC ';
		$result = $this->db->sql_query($sql);
		while($result && ($row = $this->db->sql_fetchrow($result))) {
			foreach(array('varchar','text','int','double','datetime') as $type)
				if($row['mo_value_'.$type]!==null)
					$res[$row['mo_datetime']][$row['mo_field']] = $row['mo_value_'.$type];
			$res[$row['mo_datetime']]['mo_contact'] = $row['mo_contact'];					
		}
		$last = null;
		foreach($res as $time=>$record) {
			if($last != null) {
				//reorder also
				$res[$time] = array('mo_contact'=>$record['mo_contact']);			
				foreach($last as $field_name => $value)
					if(isset($record[$field_name]))
						$res[$time][$field_name] = $record[$field_name];
					else 
						$res[$time][$field_name] = $value;				
			}
			$last = $res[$time];
		}
		return $res;
	}
	
	public function findFieldModifications($field_name="",$table="",$id=1,$actual_included=true) {
		if($table=="")
			$table = $this->table;
		$res = array();
		if($actual_included) {
			$id_field = $this->getPrefix($table)."_id";
			$now = date('Y-m-d H:i:s');
			$sql = "SELECT ".$field_name." as v FROM ".$table." WHERE ".$id_field." = ".$id;
			$result = $this->db->sql_query($sql);
			if($result && ($row = $this->db->sql_fetchrow($result)))
				$res[$now] = $row['v'];
		}
		$field_sql = "";
		if($field_name!="")
			$field_sql = ' AND mo_field="'.$field_name.'" '; 
		$sql = 'SELECT * FROM modification '.
			'WHERE mo_table="'.$table.'" AND mo_object_id='.$id.' '.$field_sql.
			'ORDER BY mo_datetime DESC ';
		$result = $this->db->sql_query($sql);
		while($result && ($row = $this->db->sql_fetchrow($result))) {
			foreach(array('varchar','text','int','double','datetime') as $type)
				if($row['mo_value_'.$type]!==null)
					$res[$row['mo_datetime']] = $row['mo_value_'.$type];
		}
		return $res;
	}
	
	public function updateRecord($table, $id, $fields) {
		$all_field_names = $this->getFieldNames($table);
		$field_names = $all_field_names;
		$id_fieldname = array_shift($field_names);
		$old_record = $this->findOne($table,$id);

$field_types = array();
		foreach($all_field_names as $n=>$field_name)
			$field_types[$field_name] = $this->db->sql_fieldtype($n);

$now = date('Y-m-d H:i:s');
		$sql = "UPDATE ".$table." SET ";
		$sep = "";
		$user_id = 0;
		if(isset($_SESSION['user']['co_id']))
			$user_id = $_SESSION['user']['co_id'];

foreach($fields as $field_name=>$new_value){
			if($new_value!=$old_record[$field_name]) {
				$tab_types = array("int"=>"int","real"=>"double","date"=>"datetime",
					"time"=>"datetime","datetime"=>"datetime","string"=>"varchar",
					"timestamp"=>"varchar","blob"=>"text");
				$type = $tab_types[$field_types[$field_name]];
				if($type == "varchar" && strlen($old_record[$field_name])>255)
					$type = "text";
				$sql2 = "INSERT INTO modification(mo_table, mo_field, mo_object_id, ".
					"mo_datetime, mo_value_".$type.", mo_contact) VALUES (".
					"'".$table."','".$field_name."',".$id.",'".$now."',".
					"'".addslashes($old_record[$field_name])."',".$user_id.")";
				$this->db->sql_query($sql2);
				$sql.= $sep.$field_name.'=\''.addslashes($new_value).'\' ';
				$sep=",";
			}
		}

if($sep=="")
			return false;
		$sql.= 'WHERE '.$id_fieldname.'='.$id;
	 
		if(!$this->db->sql_query($sql)) {
			$this->html_page->displayError("send",t("Failed_insert","DataObject")." - ".$sql);
			return false;
		} 
		return true;
	}

public function deleteRecord($table, $id, &$nb_file_moved = null) {		 
		$old_record = $this->findOne($table,$id);
		$all_field_names = $this->getFieldNames($table);
		$field_names = $all_field_names;
		$id_fieldname = array_shift($field_names);		 
		$field_types = array();
		foreach($all_field_names as $n=>$field_name)
			$field_types[$field_name] = $this->db->sql_fieldtype($n);

$nb_files_moved = 0;
		$now = date('Y-m-d H:i:s');
		foreach($field_names as $field_name) {
			if (strstr($field_name, "file")!==false && trim($old_record[$field_name])!='')
				if(@rename($this->getDirectoryName().$old_record[$field_name],
						'./files/bin/'.$old_record[$field_name]))
					$nb_files_moved++;
			$tab_types = array("int"=>"int","real"=>"double","date"=>"datetime",
				"time"=>"datetime","datetime"=>"datetime","string"=>"varchar",
				"timestamp"=>"varchar");
			$type = $tab_types[$field_types[$field_name]];
			if($type == "varchar" && strlen($old_record[$field_name])>255)
				$type = "text";
			$sql2 = "INSERT INTO modification(mo_table, mo_field, mo_object_id, ".
				"mo_datetime, mo_value_".$type.", mo_contact) VALUES (".
				"'".$table."','".$field_name."',".$id.",'".$now."',".
				"'".addslashes($old_record[$field_name])."',".$_SESSION['user']['co_id'].")";
			$this->db->sql_query($sql2);
		}

$sql = "DELETE FROM ".$table." WHERE ".$id_fieldname."=".$id;
	 
		return $this->db->sql_query($sql);
	}
		
	public function getListById($args = null, $table="") {
		$list = $this->getList($args,$table);
		$res = array();
		foreach($list as $l)
			$res[array_i($l,0)] = $l;
		return $res;
	}
	
	/* override it */
	public function getDefaultArgs() {
		return array("fields"=>"", "join"=>"", "filter"=>"",
			"order"=>2, "special"=>"","limit_start"=>0,
			"limit_nb" => DATAOBJECT_NBRECORDS_SEE_LIST);
	}

//use $get (or $this->params) to merge received listing args with default ones
	//"special" : depends on class, often: id of asked object in the list
	protected function getDisplayArgs($get = null) {
		if($get===null)
			$get = $this->params;
		$args = $get;
		if(!isset($args['filter']))
			$args['filter'] = '';
		//sample request : ...value=1&restriction=co_id&value1=3&restriction_sup1=co_ca
		for($i = "";isset($get["value".$i]);$i++) { //notice:type change for $i
			$text_value = "'".addslashes($get["value".$i])."'";
			if(isset($get["restriction".$i]))
				$args['filter'] .= " AND(".$get["restriction".$i]."=".$text_value.")";
			if(isset($get["interdiction".$i]))
				$args['filter'] .= " AND(".$get["interdiction".$i]."!=".$text_value.")";
			if(isset($get["restriction_sup".$i]))
				$args['filter'] .= " AND(".$get["restriction_sup".$i].">".$text_value.")";
			if(isset($get["restriction_inf".$i]))
				$args['filter'] .= " AND(".$get["restriction_inf".$i]."<".$text_value.")";
		}
		//sample request : ...values=1,4&restriction=co_role
		for($i = "";isset($get["values".$i]);$i++) { //
			$values_tab = array(); 
			foreach(explode(",",$get["values".$i]) as $v)
				$values_tab[] = "'".addslashes($v)."'";
			$values_sql = " IN('-10000',".implode(",",$values_tab).")";
			if(isset($get["restriction".$i]))
				$args['filter'] .= " AND(".$get["restriction".$i].$values_sql.")";
			if(isset($get["interdiction".$i]))
				$args['filter'] .= " AND(NOT ".$get["interdiction".$i].$values_sql.")";
		}
	
		return $this->mergeArgs($this->getDefaultArgs(),$args);
	}
	
	// used by ::displayListBy()
	protected function getByArgs($previous_table, $previous_id, $real_field="") {
		if($real_field!="")
			$used_field = $real_field;
		else
			$used_field = $this->getPrefix().'_'.$previous_table;
		return $this->mergeArgs($this->getDisplayArgs(),					
			array('filter'=>' AND ('.$used_field.' = '.$previous_id.')'));
	}
	
	//do more than array_merge, only for args (i.e. what could be in $_GET)
	//$args2 win
	protected function mergeArgs($args1, $args2) {
		$res = $args1;
		foreach(array('fields','join','filter','order','special','limit_start','limit_nb') as $arg)
			if(!isset($res[$arg]))
				$res[$arg] = '';
		if(isset($args2['fields']))
			$res['fields'] .= " ".$args2['fields'];
		if(isset($args2['join']))
			$res['join'] .= " ".$args2['join'];
		if(isset($args2['filter']))
			$res['filter'] .= " ".$args2['filter'];
		if(isset($args2['order']))
			if($res['order']!='') {
				//problem : x,y,a(z,2) should be split only on characters 1 and 3, not 7
				//solution : replace (..,..) with (..|||..), then merge, then replace back
				$tmp = $args1['order'];
				do {
					$order1 = $tmp;
					$tmp = preg_replace("/$([^$]*)\,/i","($1|||$2",$order1);
				} while($order1 != $tmp);
				$tmp = $args2['order'];
				do {
					$order2 = $tmp;
					$tmp = preg_replace("/$([^$]*)\,/i","($1|||$2",$order2);
				} while($order2 != $tmp);
				$order_array=array_merge(explode(",",$order2),explode(",",$order1));
				foreach($order_array as $n=>$v)
					$order_array[$n] = trim($v);
				foreach($order_array as $n1=>$v1) //search and remove field 2 times here
					foreach($order_array as $n2=>$v2) {
						//warning, bug prone due to same probleme 15 lines above
						$v1s = explode(" ",$v1); //avoid DESC
						$v2s = explode(" ",$v2);
						if(($n1<$n2 && $v1s[0]==$v2s[0]) || $v2s[0]=='')
							unset($order_array[$n2]); 
					}
				$res['order'] = str_replace("|||",",",implode(",",array_slice($order_array,0,2)));
			} else
				$res['order'] = $args2['order'];
		if(isset($args2['special']))
			$res['special'] .= $args2['special'];
		if(isset($args2['limit_start']))
			$res['limit_start'] = $args2['limit_start'];
		if(isset($args2['limit_nb']))
			$res['limit_nb'] = $args2['limit_nb'];						
		return $res;		
	}
	
	protected function mergeWithDefault($args) {
		return $this->mergeArgs($this->getDefaultArgs(),$args);
	}

protected function stopWorkflow($key) {
		if(isset($_SESSION['wflw'][$key])) {
			$this->html_response .= "<h2>".
				t('Workflow_message1','DataObject',false,$_SESSION['wflw'][$key]['name'])."</h2>";
			unset($_SESSION['wflw'][$key]);
		} else
			$this->html_response .= '<h2>'.
				t('Workflow_message2','DataObject',false,$key)."</h2>";
	}
	
	protected function stopAnyWorkflow() {
		if(isset($_SESSION['wflw']))
			foreach($_SESSION['wflw'] as $key=>$wflw)
				$this->stopWorkflow($key);
	}
	
	protected function stopOldWorkflows() {
		if(isset($_SESSION['wflw']))
			foreach($_SESSION['wflw'] as $key=>$wflw)
				if(isset($wflw['time_limit'])&&date('Y-m-d H:i:s')>$wflw['time_limit'])
					$this->stopWorkflow($key);
	}

protected static function log($message,$source_file="",$severity="DEBUG") {
		if($source_file == "")
			$source_file = "dataobject.class.php";
		$filename = LOGS_DIRECTORY.$source_file.".log";
		//archiving sometimes
		if(file_exists($filename)) {
			$filemtime = filemtime($filename);
			if(date(LOGS_ROTATION_PATTERN,$filemtime)!=date(LOGS_ROTATION_PATTERN))
				rename($filename, LOGS_DIRECTORY.$source_file.'.'.
					date(LOGS_ROTATION_PATTERN,$filemtime).'.log');
		}
		//adding
		$flog=fopen($filename,"a");
		if($flog!=false) {
			fputs($flog,date("Y-m-d H:i:s")." ".$severity." ".$_SERVER['REMOTE_ADDR']." ".$message."\n");
			fclose($flog);
		}		
	}
	
	//file : array('name'=>...,'content'=>...,'mime_type'=>...)
	protected function sendMail($receiver,$subject,$text,$headers="",$file=null) {
		$random_hash = md5(date('r', time()));
		if($headers!="" && substr($headers,-1)!="\n")
			$headers .= "\n";
		if($file==null)
			$headers .= "Content-Type: text/plain; charset=".t("page_encoding")."\n".
				"Content-Transfer-Encoding: 8bit\n";
		else
			$headers .= "Content-Type: multipart/mixed; boundary=\"file-".$random_hash."\"\n";			
		$headers .= "MIME-Version: 1.0\n".
			"X-Mailer: ".MAIN_TITLE."\n".			
			"Return-Path: nowhere@example.org\n";
		if(stripos($headers,"From:")!==false) {
			$from = substr(trim(stristr($headers,"From:")),strlen("From:"));
			if(strpos($from,"\n")!==false)
				$from = substr($from,0,strpos($from,"\n"));
			$headers .= "Reply-To: ".$from."\n";
		} else {
			if(isset($_SESSION['user']))
				$from=$_SESSION['user']['co_mail'];
			else
				$from=DEFAULT_MAIL;
			$headers .= "From: ".$from."\nReply-To: ".$from."\n";	
		}
		$text = $this->html_page->getTextNotHtml(str_replace("\'","'",$text));
		$headers = str_replace("\r\n","\n",$headers);
		$headers = str_replace("\n",EMAIL_HEADER_NL,$headers);
		$text = str_replace("\r\n","\n",$text);
		$text = str_replace("\n",EMAIL_TEXT_NL,$text);
		
		if($file!=null) {
			$text = "--file-".$random_hash."\n".
				"Content-Type: text/plain; charset=".t("page_encoding")."\n".
				"Content-Transfer-Encoding: 8bit\n\n".
				$text."\n\n".
				"--file-".$random_hash."\n".
				"Content-Type: ".$file['mime_type'].";\n name=\"".$file['name']."\"\n".
				"Content-Disposition: attachment;\n filename=\"".$file['name']."\"\n".
				"Content-Transfer-Encoding: base64\n\n".
				chunk_split(base64_encode($file['content']))."\n".
				"--file-".$random_hash."--";					 
		}

$this->log("Sending mail : ".$receiver.",".
			t("Mail_subject_prefix",'DataObject').
				$subject.",\n".$text."\n,".$headers.",-f".$from,
			"","INFO");

return mail($receiver,t('Mail_subject_prefix','DataObject').$subject,
			$text,$headers,"-f$from");
	}
	
//TODO create insert as function in dataobject, in order to save a modification
	protected function saveNoteSend($co_id, $co_entreprise, $receivers, $url, $text,
			$original_action) {
		$sql = 'INSERT INTO note VALUES("","'.date("Y-m-d").'",'.
			'"'.t('Sql_note1','DataObject',false,t($this->table."_record")).'","",'.
			$co_entreprise.','.$co_id.','.
			'"'.t('Sql_note2','DataObject',false,$url,implode(',',$receivers),$text).'",'.
			$_SESSION['user']['wo_id'].',0,"'.$this->getNoteType($original_action).'",'.
			'"'.$this->getNoteSubType($original_action).'")';
		$this->db->sql_query($sql);
	}

protected function getNoteType($original_action) {
		return 'sending';
	}

protected function getNoteSubType($original_action) {
		return 'other';
	}
}

Logiciel Open Source pour la gestion d'entreprise :CRM, GED, Comptabilité, Groupware, Projets, DRH

Une conception moderne, facilement maintenable et personnalisable

A propos du scaffolding

Code source de la classe mère :

Logiciel Open Source pour la gestion d'entreprise :
CRM, GED, Comptabilité, Groupware, Projets, DRH