/class.xmodblog.inc

https://github.com/jcplat/console-seolan · PHP · 948 lines · 800 code · 63 blank · 85 comment · 80 complexity · 6bf57d70f31c3b73fadafdceb3b67eea MD5 · raw file 

    

  1. <?php
    2. 

  2. // Blog
    3. 

  3. //
    4. 

  4. class XModBlog extends XModTable {
    5. 

  5.   /// duree en jours pendant laquelle un event ou un commentaire sont consideres comme recents
    6. 

  6.   var $recentevents=7;
    7. 

  7. 

  8.   function __construct($ar=NULL) {
    9. 

  9.     parent::__construct($ar);
    10. 

  10.     XLabels::loadLabels('xmodblog');
    11. 

  11.   }
    12. 

  12. 

  13.   /// suppression du module
    14. 

  14.   function delete($ar=NULL) {
    15. 

  15.     parent::delete($ar);
    16. 

  16.   }
    17. 

  17. 

  18.   /// corbeille des taches
    19. 

  19.   public function getTasklet(){
    20. 

  20.     // liste des entites en attente de validation
    21. 

  21.     $blogs = array();
    22. 

  22.     // blogs a valider 
    23. 

  23.     $query=$this->xset->select_query(array("cond"=>array('PUBLISH'=>array('=',2),
    24. 

  24. 							 'dtype'=>array('=','blog'))));
    25. 

  25.     $rs=selectQuery($query);
    26. 

  26.     while($rs && ($ors = $rs->fetch())){
    27. 

  27.       if (!isset($blogs[$ors['KOID']])){
    28. 

  28. 	$blogs[$ors['KOID']] = array('publish'=>2,'posts'=>array());
    29. 

  29.       }
    30. 

  30.     }
    31. 

  31.     unset($rs); unset($ors);
    32. 

  32.     // posts a valider
    33. 

  33.     $query=$this->xset->select_query(array("cond"=>array('PUBLISH'=>array('=',2),
    34. 

  34. 							 'dtype'=>array('=','post'))));
    35. 

  35.     $rs=selectQuery($query);
    36. 

  36.     while($rs && ($ors = $rs->fetch())){
    37. 

  37.       if (!isset($blogs[$ors['blog']])){
    38. 

  38. 	$blogs[$ors['blog']] = array('publish'=>1,'posts'=>array());
    39. 

  39.       }
    40. 

  40.       $blogs[$ors['blog']]['posts'][$ors['KOID']]=array('title'=>$ors['title'], 'publish'=>2, 'comments'=>array());
    41. 

  41.     }
    42. 

  42.     unset($rs); unset($ors);
    43. 

  43.     // comptage du nombre de commentaires a valider
    44. 

  44.     $query=$this->xset->select_query(array("cond"=>array('PUBLISH'=>array('=',2),
    45. 

  45. 							 'dtype'=>array('=','comment'))));
    46. 

  46.     $rs=selectQuery($query);
    47. 

  47.     while($rs && ($ors = $rs->fetch())){
    48. 

  48.       if (!isset($blogs[$ors['blog']])){
    49. 

  49. 	$blogs[$ors['blog']] = array('publish'=>1, 'posts'=>array());
    50. 

  50.       }
    51. 

  51.       if (!isset($blogs[$ors['blog']]['posts'][$ors['paperup']])){
    52. 

  52. 	$blogs[$ors['blog']]['posts'][$ors['paperup']] = array('publish'=>1, 'comments'=>array());
    53. 

  53.       }
    54. 

  54.       $blogs[$ors['blog']]['posts'][$ors['paperup']]['comments'][$ors['KOID']] = array('publish'=>2, 'title'=>$ors['title']);
    55. 

  55.     }
    56. 

  56.     unset($rs); unset($ors);
    57. 

  57.     $t= '';
    58. 

  58.     foreach($blogs as $oidblog=>$blog){
    59. 

  59.       $rdb = $this->xset->rdisplay($oidblog);
    60. 

  60.       $bt = XLabels::getSysLabel('xmodblog', 'modulename').' : '.$rdb['title'];
    61. 

  61.       /*
    62. 

  62.       if ($blog['publish'] == 2 && $this->secure($oidblog, ':rwv')){
    63. 

  63. 	$url = $GLOBALS['TZR_SESSION_MANAGER']::complete_self(true, true).'&function=browseBlog&moid='.$this->_moid.'&oid='.$oidblog.'&template=xmodblog/browseblog.html&tplentry=br';
    64. 

  64. 	$a1 = '<a href="'.$url.'">';
    65. 

  65. 	$a2 = '</a>';
    66. 

  66. 	$t .= '<p>'.XLabels::getSysLabel('general','view').' '.$a1.$rdb['title'].$a2.'</p>';
    67. 

  67.       }
    68. 

  68.       */
    69. 

  69.       foreach($blog['posts'] as $oidpost=>$post){
    70. 

  70. 	$rdp = $this->xset->rdisplay($oidpost);
    71. 

  71. 	$a1=$a2='';
    72. 

  72. 	if ($post['publish'] == 2 && $this->secure($oidblog, ':rwv')){
    73. 

  73. 	  $url = $GLOBALS['TZR_SESSION_MANAGER']::complete_self(true, true).'&function=displayPost&moid='.$this->_moid.'&oid='.$oidblog.'&post='.$oidpost.'&template=xmodblog/displaypost.html&tplentry=br';
    74. 

  74. 	  $a1 = '<a href="'.$url.'">';
    75. 

  75. 	  $a2 = '</a>';
    76. 

  76. 	  $t .= '<p>'.XLabels::getSysLabel('general','view').' '.$a1.$rdp['title'].$a2.' - '.$bt.'</p>';
    77. 

  77. 	}
    78. 

  78. 	$pt = XLabels::getSysLabel('xmodblog', 'post').' : '.$rdp['title'].', '.$bt;
    79. 

  79. 	foreach($post['comments'] as $oidcomment=>$comment){
    80. 

  80. 	  $b1=$b2='';
    81. 

  81. 	  if ($comment['publish'] == 2 && $this->secure($oidcomment, ':rwv')){
    82. 

  82. 	    $url = $GLOBALS['TZR_SESSION_MANAGER']::complete_self(true, true).'&function=displayPost&moid='.$this->_moid.'&oid='.$oidblog.'&post='.$oidpost.'&template=xmodblog/displaypost.html&tplentry=br&comment='.$oidcomment;
    83. 

  83. 	    $b1 = '<a href="'.$url.'">';
    84. 

  84. 	    $b2 = '</a>';
    85. 

  85. 	    $rdc = $this->xset->rdisplay($oidcomment);
    86. 

  86. 	    $t .= '<p>'.XLabels::getSysLabel('general','view').' '.$b1.$rdc['title'].$b2.' - '.$pt.'</p>';
    87. 

  87. 	  }
    88. 

  88. 	}
    89. 

  89.       }
    90. 

  90.     }
    91. 

  91.     if (!empty($t)){
    92. 

  92.       $t = '<h2>En attente de validation</h2>'.$t;
    93. 

  93.     }
    94. 

  94.     return $t;
    95. 

  95.   }
    96. 

  96. 

  97.   /// affichage dans la partie page d'accueil de la corbeille de taches
    98. 

  98.   public function getShortTasklet(){
    99. 

  99.     // posts a valider
    100. 

  100.     $urln=$GLOBALS['TZR_SESSION_MANAGER']::complete_self(true, true).'&moid='.$this->_moid.
    101. 

  101.       '&_function=browseBlogs&tplentry=br&template=xmodblog/browseblogs.html';
    102. 

  102.     $url1=$GLOBALS['TZR_SESSION_MANAGER']::complete_self(true, true).'&moid='.$this->_moid.
    103. 

  103.       '&_function=browseBlog&tplentry=br&template=xmodblog/browseblog.html';
    104. 

  104.     $query=$this->xset->select_query(array("cond"=>array('PUBLISH'=>array('=',2),
    105. 

  105. 							 'dtype'=>array('=','post'))));
    106. 

  106.     $rs=selectQuery($query);
    107. 

  107.     $posts=0;
    108. 

  108.     $blogsposts=array();
    109. 

  109.     while($rs && ($ors = $rs->fetch())){
    110. 

  110.       if($this->secure($ors['blog'], ':rwv')) {
    111. 

  111. 	$posts++;$blogsposts[$ors['blog']]=1;
    112. 

  112.       }
    113. 

  113.     }
    114. 

  114.     $t='';
    115. 

  115. 

  116.     if($posts>0) {
    117. 

  117.       if(count($blogsposts)>1) $url=$urln;
    118. 

  118.       else {
    119. 

  119. 	$tab=array_keys($blogsposts);
    120. 

  120. 	$url=$url1.'&oid='.$tab[0];
    121. 

  121.       }
    122. 

  122.       if($posts==1) $t.='<p><a href="'.$url.'">Un</a> article &agrave; valider</p>';
    123. 

  123.       elseif($posts>0) $t.='<p><a href="'.$url.'">'.$posts.'</a> articles &agrave; valider</p>';
    124. 

  124.     }
    125. 

  125. 

  126.     // posts a valider
    127. 

  127.     $query=$this->xset->select_query(array("cond"=>array('PUBLISH'=>array('=',2),
    128. 

  128. 							 'dtype'=>array('=','comment'))));
    129. 

  129.     $rs=selectQuery($query);
    130. 

  130.     $comments=0;
    131. 

  131.     $blogscomments=array();
    132. 

  132.     while($rs && ($ors = $rs->fetch())){
    133. 

  133.       if($this->secure($ors['blog'], ':rwv')) {
    134. 

  134. 	$comments++;$blogscomments[$ors['blog']]=1;
    135. 

  135.       }
    136. 

  136.     }
    137. 

  137.     if($comments>0) {
    138. 

  138.       if(count($blogscomments)>1) $url=$urln;
    139. 

  139.       else {
    140. 

  140. 	$tab=array_keys($blogscomments);
    141. 

  141. 	$url=$url1.'&oid='.$tab[0];
    142. 

  142.       }
    143. 

  143.       if($comments==1) $t.='<p><a href="'.$url.'">Un</a> commentaire &agrave; valider</p>';
    144. 

  144.       elseif($comments>0) $t.='<p><a href="'.$url.'">'.$comments.'</a> commentaires &agrave; valider</p>';
    145. 

  145.     }
    146. 

  146.     return $t;
    147. 

  147.   }
    148. 

  148. 

  149.   /// liste des articles recents
    150. 

  150.   function &portlet2() {
    151. 

  151.     $urln=$GLOBALS['TZR_SESSION_MANAGER']::complete_self(true, true).'&moid='.$this->_moid.
    152. 

  152.       '&_function=browseBlogs&tplentry=br&template=xmodblog/browseblogs.html';
    153. 

  153.     $url1=$GLOBALS['TZR_SESSION_MANAGER']::complete_self(true, true).'&moid='.$this->_moid.
    154. 

  154.       '&_function=browseBlog&tplentry=br&template=xmodblog/browseblog.html';
    155. 

  155.     $query=$this->xset->select_query(array("cond"=>array('PUBLISH'=>array('=',1),
    156. 

  156. 							 'UPD'=>array('>', '=DATE_SUB(NOW(), INTERVAL '.$this->recentevents.' DAY)'),
    157. 

  157. 							 'dtype'=>array('=','post'))));
    158. 

  158.     $rs=selectQuery($query);
    159. 

  159.     $posts=0;
    160. 

  160.     $blogsposts=array();
    161. 

  161.     while($rs && ($ors = $rs->fetch())){
    162. 

  162.       if($this->secure($ors['blog'],':ro')) {
    163. 

  163. 	$posts++;$blogsposts[$ors['blog']]=1;
    164. 

  164.       }
    165. 

  165.     }
    166. 

  166.     $query=$this->xset->select_query(array("cond"=>array('PUBLISH'=>array('=',1),
    167. 

  167. 							 'UPD'=>array('>', '=DATE_SUB(NOW(), INTERVAL '.$this->recentevents.' DAY)'),
    168. 

  168. 							 'dtype'=>array('=','comment'))));
    169. 

  169.     $rs=selectQuery($query);
    170. 

  170.     $comments=0;
    171. 

  171.     $blogscomments=array();
    172. 

  172.     while($rs && ($ors = $rs->fetch())){
    173. 

  173.       if($this->secure($ors['blog'],':ro')) {
    174. 

  174. 	$comments++;$blogscomments[$ors['blog']]=1;
    175. 

  175.       }
    176. 

  176.     }
    177. 

  177. 

  178.     if(($comments+$posts)>0) {
    179. 

  179.       $txt ='<h1>'.$this->modulename.'</h1>';
    180. 

  180.       if($posts>0) {
    181. 

  181. 	if(count($blogsposts)>1) $url=$urln;
    182. 

  182. 	else {
    183. 

  183. 	  $tab=array_keys($blogsposts);
    184. 

  184. 	  $url=$url1.'&oid='.$tab[0];
    185. 

  185. 	}
    186. 

  186. 	if($posts==1) $txt.='<p><a href="'.$url.'">Un</a> nouvel article</p>';
    187. 

  187. 	else $txt.='<p><a href="'.$url.'">'.$posts.'</a> nouveaux articles</p>';
    188. 

  188.       }
    189. 

  189.       if($comments>0) {
    190. 

  190. 	if(count($blogscomments)>1) $url=$urln;
    191. 

  191. 	else {
    192. 

  192. 	  $tab=array_keys($blogscomments);
    193. 

  193. 	  $url=$url1.'&oid='.$tab[0];
    194. 

  194. 	}
    195. 

  195. 	if($comments==1) $txt.='<p><a href="'.$url.'">Un</a> nouveau commentaire</p>';
    196. 

  196. 	else $txt.='<p><a href="'.$url.'">'.$comments.'</a> nouveaux commentaires</p>';
    197. 

  197.       }
    198. 

  198.     }
    199. 

  199.     return $txt;
    200. 

  200.   }
    201. 

  201.   /// initialisation des propriétés
    202. 

  202.   public function initOptions() {
    203. 

  203.     parent::initOptions();
    204. 

  204.     $alabel = XLabels::getSysLabel('xmodblog.modulename');
    205. 

  205.     $this->_options->setOpt('Duree en jours de la nouveaut&eacute;', 'recentevents', 'text', NULL,7, $alabel);
    206. 

  206.   }
    207. 

  207.   function display($ar=NULL) {
    208. 

  208.     return $this->goto1($ar);
    209. 

  209.   }
    210. 

  210.   /// recherche des nouveautes pour abonnement
    211. 

  211.   protected function _whatsNew($ts,$user, $group=NULL, $specs=NULL, $timestamp=NULL) {
    212. 

  212.     list($koid)=explode(';',$specs);
    213. 

  213.     if(Kernel::isAKoid($koid)) $query='select * from '.$this->table.' where UPD>="'.$ts.'" and UPD<="'.$timestamp.'" and PUBLISH="1" AND blog="'.$koid.'"';
    214. 

  214.     else $query='select * from '.$this->table.' where UPD>="'.$ts.'" and UPD<="'.$timestamp.'" and PUBLISH="1"';
    215. 

  215.     $r=&$this->xset->browse(array('select'=>$query, 'selected'=>'0', 'pagesize'=>'99', 'tplentry'=>TZR_RETURN_DATA,'selectedfields'=>'all'));
    216. 

  216.     $txt='';
    217. 

  217.     foreach($r['lines_oid'] as $i => $oid) {
    218. 

  218.       $d1=&$this->xset->display(array('_lastupdate'=>true,'tplentry'=>TZR_RETURN_DATA,'oid'=>$oid,'_options'=>array('error'=>'return')));
    219. 

  219.       $url=$GLOBALS['TZR_SESSION_MANAGER']::admin_url(true,false).'&moid='.$this->_moid.'&function=goto1&oid='.$oid.'&tplentry=br&template=xmodtable/view.html&_direct=1';
    220. 

  220.       if(is_array($d1)) {
    221. 

  221. 	$when=$d1['oUPD']->html;
    222. 

  222. 	$who=$d1['lst_upd']['usernam'];
    223. 

  223. 	$txt.='<li><a href="'.$url.'">'.$d1['oblog']->toText().' : '.getTextFromHTML($d1['link']).'</a> ('.$when.', '.$who.')</li>';
    224. 

  224.       }
    225. 

  225.     }
    226. 

  226.     return $txt;
    227. 

  227.   }
    228. 

  228.   function goto1($ar=NULL) {
    229. 

  229.     $p=new XParam($ar,array());
    230. 

  230.     $oid=$p->get('oid');
    231. 

  231.     $moid=$this->_moid;
    232. 

  232. 

  233.     $right= $this->secure($oid, 'displayPost');
    234. 

  234.     if(!$right) securityWarning('XModBlog::goto1: could not access to objet '.$oid.' in module '.$moid);
    235. 

  235. 

  236.     $url=$GLOBALS['TZR_SESSION_MANAGER']::admin_url(true,false);
    237. 

  237.     $disp=$this->xset->display(array('tplentry'=>TZR_RETURN_DATA, 'oid'=>$oid));
    238. 

  238.     $oidblog=$disp['oblog']->raw;
    239. 

  239.     $oidpost=$disp['opaperup']->raw;
    240. 

  240.     $oid=$disp['oid'];
    241. 

  241.     if($disp['odtype']->raw=='post')
    242. 

  242.       $durl="{$url}&moid=$moid&template=xmodblog/displaypost.html&oid={$oidblog}&post={$oid}&function=displayPost&tplentry=br&skip=1";
    243. 

  243.     if($disp['odtype']->raw=='comment')
    244. 

  244.       $durl="{$url}&moid=$moid&template=xmodblog/displaypost.html&oid={$oidblog}&post={$oidpost}&function=displayPost&tplentry=br&skip=1#{$oid}";
    245. 

  245.     header("Location: $durl");
    246. 

  246.     exit();
    247. 

  247.   }
    248. 

  248. 

  249.   /// securite des fonctions accessibles par le web
    250. 

  250.   function secGroups($function, $group=NULL) {
    251. 

  251.     $g=array('addBlog'=>array('rwv','admin'),
    252. 

  252. 	     'addComment'=>array('ro','rw','rwv','admin'),
    253. 

  253. 	     'addPost'=>array('rw','rwv','admin'),
    254. 

  254. 	     'addLink'=>array('rw','rwv','admin'),
    255. 

  255. 	     'browseBlog'=>array('none','ro','rw','rwv','admin'),
    256. 

  256. 	     'browseBlog2'=>array('none','ro','rw','rwv','admin'),
    257. 

  257. 	     'browseBlogs'=>array('none','ro','rw','rwv','admin'),
    258. 

  258. 	     'delBlog'=>array('rw','rwv','admin'),
    259. 

  259. 	     'delPost'=>array('rw','rwv','admin'),
    260. 

  260. 	     'delLink'=>array('rw','rwv','admin'),
    261. 

  261. 	     'displayPost'=>array('none','ro','rw','rwv','admin'),
    262. 

  262. 	     'displayPost2'=>array('none','ro','rw','rwv','admin'),
    263. 

  263. 	     'editBlog'=>array('rwv','admin'),
    264. 

  264. 	     'editComment'=>array('rw','rwv','admin'),
    265. 

  265. 	     'editPost'=>array('rw','rwv','admin'),
    266. 

  266. 	     'procAddBlog'=>array('rwv','admin'),
    267. 

  267. 	     'procAddComment'=>array('none','ro','rw','rwv','admin'),
    268. 

  268. 	     'procAddPost'=>array('rw','rwv','admin'),
    269. 

  269. 	     'procAddLink'=>array('rw','rwv','admin'),
    270. 

  270. 	     'procEditBlog'=>array('rwv','admin'),
    271. 

  271. 	     'procEditComment'=>array('rw','rwv','admin'),
    272. 

  272. 	     'procEditPost'=>array('rw','rwv','admin'),
    273. 

  273. 	     'validatePost'=>array('rwv','admin'),
    274. 

  274. 	     'validateBlog'=>array('rwv','admin'));
    275. 

  275.     if(isset($g[$function])) {
    276. 

  276.       if(!empty($group)) return in_array($group, $g[$function]);
    277. 

  277.       return $g[$function];
    278. 

  278.     }
    279. 

  279.     return parent::secGroups($function,$group);
    280. 

  280.   }
    281. 

  281. 

  282.   /// rend vrai si $oid est l'identifiant d'un article/blog/post
    283. 

  283.   private function isA($oid, $dtype) {
    284. 

  284.     return (countSelectQuery('SELECT COUNT(KOID) FROM '.$this->table.' WHERE KOID="'.$oid.'" AND dtype="'.$dtype.'"')>0);
    285. 

  285.   }
    286. 

  286. 

  287.   /// rend le nombre de blogs
    288. 

  288.   private function countBlogs() {
    289. 

  289.     return countSelectQuery('SELECT COUNT(KOID) FROM '.$this->table.' WHERE dtype="blog"');
    290. 

  290.   }
    291. 

  291. 

  292.   /// rend l'oid d'un blog
    293. 

  293.   private function oneBlog() {
    294. 

  294.     $rs=selectQuery('SELECT KOID FROM '.$this->table.' WHERE dtype="blog"');
    295. 

  295.     if($rs && ($ors=$rs->fetch())) {
    296. 

  296.       return $ors['KOID'];
    297. 

  297.     }
    298. 

  298.     return NULL;
    299. 

  299.   }
    300. 

  300.   
    301. 

  301.   /// recherche de la liste des blogs disponibles
    302. 

  302.   function browseBlogs($ar=NULL) {
    303. 

  303.     $p=new XParam($ar, array('order'=>'title'));
    304. 

  304.     $tplentry=$p->get('tplentry');
    305. 

  305.     $ar['select']=$this->xset->select_query(array('order'=>'title','cond'=>
    306. 

  306. 						  array('dtype'=>array('=','blog'))));
    307. 

  307.     $ar['pagesize']=1000;
    308. 

  308.     $this->browse($ar);
    309. 

  309.     $br=XShell::from_screen('br');
    310. 

  310.     foreach($br['lines_oid'] as $i=>$oid) {
    311. 

  311.       // comptage du nombre de posts
    312. 

  312.       if ($this->secure($oid, ':rwv'))
    313. 

  313. 	$query=$this->xset->select_query(array("cond"=>array('blog'=>array('=',$oid),
    314. 

  314. 							     'dtype'=>array('=','post'))));
    315. 

  315.       else 
    316. 

  316. 	$query=$this->xset->select_query(array("cond"=>array('blog'=>array('=', $oid),
    317. 

  317. 							     'PUBLISH'=>array('=', 1),
    318. 

  318. 							     'dtype'=>array('=','post'))));
    319. 

  319.       $nbposts=countSelectQuery($query,true);
    320. 

  320.       $br['lines_posts'][$i]=$nbposts;
    321. 

  321. 

  322.       $br['lines_poststopublish'][$i]=0;
    323. 

  323.       if ($this->secure($oid, ':rwv')){
    324. 

  324. 	// comptage du nombre de posts a valider
    325. 

  325. 	$query=$this->xset->select_query(array("cond"=>array('blog'=>array('=',$oid),
    326. 

  326. 							     'PUBLISH'=>array('=',2),
    327. 

  327. 							     'dtype'=>array('=','post'))));
    328. 

  328. 	$nbposts=countSelectQuery($query, true);
    329. 

  329. 	$br['lines_poststopublish'][$i]=$nbposts;
    330. 

  330.       }
    331. 

  331. 

  332.       // comptage du nombre de commentaires
    333. 

  333.       if ($this->secure($oid, ':rwv'))
    334. 

  334. 	$query=$this->xset->select_query(array("cond"=>array('blog'=>array('=',$oid),
    335. 

  335. 							     'dtype'=>array('=','comment'))));
    336. 

  336.       else
    337. 

  337. 	$query=$this->xset->select_query(array("cond"=>array('blog'=>array('=',$oid),
    338. 

  338. 							     'PUBLISH'=>array('=', 1),
    339. 

  339. 							     'dtype'=>array('=','comment'))));
    340. 

  340. 	
    341. 

  341.       $nbposts=countSelectQuery($query, true);
    342. 

  342.       $br['lines_comments'][$i]=$nbposts;
    343. 

  343. 

  344.       // comptage du nombre de commentaires a valider
    345. 

  345.       $br['lines_commentstopublish'][$i]=0;
    346. 

  346.       if ($this->secure($oid, ':rwv')){
    347. 

  347. 	$query=$this->xset->select_query(array("cond"=>array('blog'=>array('=',$oid),
    348. 

  348. 							     'PUBLISH'=>array('=',2),
    349. 

  349. 							     'dtype'=>array('=','comment'))));
    350. 

  350. 	$nbposts=countSelectQuery($query, true);
    351. 

  351. 	$br['lines_commentstopublish'][$i]=$nbposts;
    352. 

  352.       }
    353. 

  353. 

  354.       // article le plus recent
    355. 

  355.       $query=$this->xset->select_query(array("cond"=>array('blog'=>array('=',$oid),
    356. 

  356. 							   'dtype'=>array('=','post'))));
    357. 

  357.       $rs=selectQueryGetOne(str_replace($this->xset->getTable().'.*', 'max(UPD) as maxupd', $query));
    358. 

  358.       $br['lines_lastpostdate'][$i]=$rs['maxupd'];
    359. 

  359.     }
    360. 

  360.     return XShell::toScreen1('br',$br);
    361. 

  361.   }
    362. 

  362.   /// affichage du contenu d'un blog
    363. 

  363.   // gestion des categorie et archive
    364. 

  364.   // affichage par défaut des 5 derniers post + list de categ
    365. 

  365.   // si on passe categ, affichage des post de la categ
    366. 

  366.   // si on passe mois = YYYYmm on affiche les post du mois
    367. 

  367.   function browseBlog2($ar=NULL) {
    368. 

  368.     $p=new XParam($ar, array());
    369. 

  369.     $tplentry=$p->get('tplentry');
    370. 

  370.     $oid=$p->get('oid');
    371. 

  371.     $categ = $p->get('categ');
    372. 

  372.     $mois = $p->get('mois');
    373. 

  373. 

  374.     $right= $this->secure($oid, 'validatePost');
    375. 

  375.     //info du blog
    376. 

  376.     $r = $this->xset->display(array('tplentry'=>TZR_RETURN_DATA, 'oid'=>$oid));
    377. 

  377.     XShell::toScreen1($tplentry.'blog',$r);
    378. 

  378.     // list des posts
    379. 

  379.     $arsel =array();
    380. 

  380.     //classer par date decroissant 
    381. 

  381.     $arsel['order']='datep DESC';
    382. 

  382.     //selection des post du blog voulu dans br_lines_oid
    383. 

  383.     $arsel['cond'] = array();
    384. 

  384.     $arsel['cond']['dtype'] = array('=','post');
    385. 

  385.     $arsel['cond']['blog'] = array('=',$oid);
    386. 

  386. 

  387.     if(!$right) $arsel['cond']['PUBLISH'] = array('=',1);
    388. 

  388.     
    389. 

  389.     if($categ){
    390. 

  390.       $arsel['cond']['categ'] = array('=',$categ);
    391. 

  391.       $ar['pagesize'] = 9999;
    392. 

  392.     }elseif($mois){
    393. 

  393.       $arsel['cond']['datep'] = array('LIKE',"$mois%");
    394. 

  394.       $ar['pagesize'] = 9999;
    395. 

  395.     }else $ar['pagesize'] = 5;
    396. 

  396.     $ar['select']=$this->xset->select_query($arsel);
    397. 

  397.     $ar['selectedfields']='all';
    398. 

  398. 

  399.     $this->xset->browse($ar);
    400. 

  400.     $br=XShell::from_screen($tplentry);
    401. 

  401.     foreach($br['lines_oid'] as $i=>$oid2) {
    402. 

  402.       if($right)
    403. 

  403. 	$query=$this->xset->select_query(array('order'=>'datep ASC',
    404. 

  404. 					       'cond'=>array('blog'=>array('=',$oid),
    405. 

  405. 							     'paperup'=>array('=',$oid2),
    406. 

  406. 							     'dtype'=>array('=','comment'))));
    407. 

  407.       else
    408. 

  408. 	$query=$this->xset->select_query(array('order'=>'datep ASC',
    409. 

  409. 					       'cond'=>array('blog'=>array('=',$oid),
    410. 

  410. 							     'PUBLISH'=>array('=',1),
    411. 

  411. 							     'paperup'=>array('=',$oid2),
    412. 

  412. 							     'dtype'=>array('=','comment'))));
    413. 

  413.       // ligne un peu inutile a transformer en count pour avoir le nombre de commentaires
    414. 

  414.       $br['lines_comments'][$i]=$this->xset->browse(array('tplentry'=>TZR_RETURN_DATA,'select'=>$query, 
    415. 

  415. 							  'pagesize'=>100, 'selectedfields'=>'all'));
    416. 

  416.     }
    417. 

  417.     XShell::toScreen1($tplentry,$br);
    418. 

  418. 

  419.     // commentaires recents
    420. 

  420.     $ar=array();
    421. 

  421.     $ar['select']=$this->xset->select_query(array('order'=>'datep DESC','cond'=>
    422. 

  422. 						  array('dtype'=>array('=','comment'),
    423. 

  423. 							'blog'=>array('=',$oid))));
    424. 

  424.     $ar['selectedfields']=array('datep','title','blog','paperup');
    425. 

  425.     $ar['pagesize']=10;
    426. 

  426.     $ar['tplentry']=$tplentry.'comments';
    427. 

  427.     $this->xset->browse($ar);
    428. 

  428. 

  429.     // Liens
    430. 

  430.     $ar=array();
    431. 

  431.     $ar['select']=$this->xset->select_query(array('order'=>'datep DESC','cond'=>
    432. 

  432.                                                   array('dtype'=>array('=','link'),
    433. 

  433.                                                         'blog'=>array('=',$oid))));
    434. 

  434.     $ar['selectedfields']=array('who','title','txt');
    435. 

  435.     $ar['pagesize']=100;
    436. 

  436.     $ar['tplentry']=$tplentry.'links';
    437. 

  437.     $this->xset->browse($ar);
    438. 

  438.     
    439. 

  439.     //liste de tous les posts
    440. 

  440.     $ar=array();
    441. 

  441.     // list des posts
    442. 

  442.     $arsel =array();
    443. 

  443.     //classer par date decroissant 
    444. 

  444.     $arsel['order']='datep DESC';
    445. 

  445. 

  446.     //selection detous les post  brpost_lines_oid
    447. 

  447.     $arsel['cond'] = array();
    448. 

  448.     $arsel['cond']['dtype'] = array('=','post');
    449. 

  449.     $arsel['cond']['blog'] = array('=',$oid);
    450. 

  450. 

  451.     $ar['select']=$this->xset->select_query(array('order'=>'datep DESC','cond'=>
    452. 

  452. 						  array('dtype'=>array('=','post'),
    453. 

  453. 							'blog'=>array('=',$oid))));
    454. 

  454.     $ar['selectedfields']=array('title','datep','categ');
    455. 

  455.     $ar['pagesize']=9999;
    456. 

  456.     $ar['tplentry']=$tplentry.'posts';
    457. 

  457.     $brpost = $this->xset->browse($ar);
    458. 

  458. 

  459.     //construction du tableau des categ et archive
    460. 

  460.     $tbcateg = array_unique($brpost['lines_categ']); 
    461. 

  461.     sort($tbcateg,SORT_STRING);
    462. 

  462.     $tb['categ'] = $tbcateg;
    463. 

  463.     $tbodatep = $brpost['lines_odatep'];
    464. 

  464.     foreach($tbodatep as $k=>$v){
    465. 

  465.       $tbdatep[$k] =       date('Y-m',strtotime($v->raw));
    466. 

  466.     }
    467. 

  467.     $tbdatep = array_unique($tbdatep);
    468. 

  468.     sort($tbdatep);
    469. 

  469.     $tb['datep'] = $tbdatep;
    470. 

  470.     XShell::toScreen1($tplentry."classement",$tb);
    471. 

  471.   }
    472. 

  472. 

  473. 

  474. 

  475.   /// rend les infos fondamentales sur le blog : titre, auteur, etc
    476. 

  476.   private function _getBlogTitle($oid) {
    477. 

  477.     return $this->xset->rDisplay($oid);
    478. 

  478.   }
    479. 

  479.   /// rend les infos fondamentales sur le post : titre, auteur, etc
    480. 

  480.   private function _getPostTitle($oid) {
    481. 

  481.     return $this->xset->rDisplay($oid);
    482. 

  482.   }
    483. 

  483.   /// rend les infos fondamentales sur le commentaire : titre, auteur, etc
    484. 

  484.   private function _getCommentTitle($oid) {
    485. 

  485.     return $this->xset->rDisplay($oid);
    486. 

  486.   }
    487. 

  487.   /// affichage du contenu d'un blog
    488. 

  488.   function browseBlog($ar=NULL) {
    489. 

  489.     $p=new XParam($ar, array());
    490. 

  490.     $tplentry=$p->get('tplentry');
    491. 

  491.     $oid=$p->get('oid');
    492. 

  492. 

  493.     $right= $this->secure($oid, 'validatePost');
    494. 

  494. 

  495.     $r = $this->xset->display(array('tplentry'=>TZR_RETURN_DATA, 'oid'=>$oid));
    496. 

  496.     XShell::toScreen1($tplentry.'blog',$r);
    497. 

  497.     if($right)
    498. 

  498.       $ar['select']=$this->xset->select_query(array('order'=>'datep DESC','cond'=>
    499. 

  499. 						    array('dtype'=>array('=','post'),
    500. 

  500. 							  'blog'=>array('=',$oid))));
    501. 

  501.     else
    502. 

  502.       $ar['select']=$this->xset->select_query(array('order'=>'datep DESC','cond'=>
    503. 

  503. 						    array('dtype'=>array('=','post'),
    504. 

  504. 							  'PUBLISH'=>array('=',1),
    505. 

  505. 							  'blog'=>array('=',$oid))));
    506. 

  506.     $ar['selectedfields']='all';
    507. 

  507.     $br = $this->xset->browse($ar);
    508. 

  508.     // calcul des droits sur les objets
    509. 

  509.     if($this->object_sec){
    510. 

  510.       $lang_data = XShell::getLangData();
    511. 

  511.       $br['objects_sec']=$GLOBALS['XUSER']->getObjectsAccess($this, $lang_data, $br['lines_oid']);
    512. 

  512.     }
    513. 

  513.     foreach($br['lines_oid'] as $i=>$oid2) {
    514. 

  514.       if($right)
    515. 

  515. 	$query=$this->xset->select_query(array('order'=>'datep ASC',
    516. 

  516. 					       'cond'=>array('blog'=>array('=',$oid),
    517. 

  517. 							     'paperup'=>array('=',$oid2),
    518. 

  518. 							     'dtype'=>array('=','comment'))));
    519. 

  519.       else
    520. 

  520. 	$query=$this->xset->select_query(array('order'=>'datep ASC',
    521. 

  521. 					       'cond'=>array('blog'=>array('=',$oid),
    522. 

  522. 							     'PUBLISH'=>array('=',1),
    523. 

  523. 							     'paperup'=>array('=',$oid2),
    524. 

  524. 							     'dtype'=>array('=','comment'))));
    525. 

  525.       // ligne un peu inutile a transformer en count pour avoir le nombre de commentaires
    526. 

  526.       $br['lines_comments'][$i]=$this->xset->browse(array('tplentry'=>TZR_RETURN_DATA,'select'=>$query, 
    527. 

  527. 							  'pagesize'=>100, 'selectedfields'=>'all'));
    528. 

  528.     }
    529. 

  529.     XShell::toScreen1($tplentry,$br);
    530. 

  530.     $ar=array();
    531. 

  531.     $ar['select']=$this->xset->select_query(array('order'=>'datep DESC','cond'=>
    532. 

  532. 						  array('dtype'=>array('=','post'),
    533. 

  533. 							'blog'=>array('=',$oid))));
    534. 

  534.     $ar['selectedfields']=array('datep','title');
    535. 

  535.     $ar['pagesize']=100;
    536. 

  536.     $ar['tplentry']=$tplentry.'posts';
    537. 

  537.     $this->xset->browse($ar);
    538. 

  538. 

  539.     // commentaires recents
    540. 

  540.     $ar=array();
    541. 

  541.     $ar['select']=$this->xset->select_query(array('order'=>'datep DESC','cond'=>
    542. 

  542. 						  array('dtype'=>array('=','comment'),
    543. 

  543. 							'blog'=>array('=',$oid))));
    544. 

  544.     $ar['selectedfields']=array('datep','title','blog','paperup');
    545. 

  545.     $ar['pagesize']=100;
    546. 

  546.     $ar['tplentry']=$tplentry.'comments';
    547. 

  547.     $this->xset->browse($ar);
    548. 

  548. 

  549.     // Liens
    550. 

  550.     $ar=array();
    551. 

  551.     $ar['select']=$this->xset->select_query(array('order'=>'datep DESC','cond'=>
    552. 

  552.                                                   array('dtype'=>array('=','link'),
    553. 

  553.                                                         'blog'=>array('=',$oid))));
    554. 

  554.     $ar['selectedfields']=array('who','title','txt');
    555. 

  555.     $ar['pagesize']=100;
    556. 

  556.     $ar['tplentry']=$tplentry.'links';
    557. 

  557.     $this->xset->browse($ar);
    558. 

  558.   }
    559. 

  559.   /// affichage d'un article
    560. 

  560.   function displayPost2($ar=NULL) {
    561. 

  561.     $p=new XParam($ar, array());
    562. 

  562.     $tplentry=$p->get('tplentry');
    563. 

  563.     $oid=$p->get('oid');
    564. 

  564.     $post=$p->get('post');
    565. 

  565. 

  566.     //display du blog
    567. 

  567.     $r = $this->xset->display(array('tplentry'=>TZR_RETURN_DATA, 'oid'=>$oid));
    568. 

  568.     XShell::toScreen1($tplentry.'blog',$r);
    569. 

  569.     //display du post
    570. 

  570.     $r = $this->xset->display(array('tplentry'=>TZR_RETURN_DATA, 'oid'=>$post));
    571. 

  571.     XShell::toScreen1($tplentry.'post',$r);
    572. 

  572.     $right= $this->secure($oid, 'validatePost');
    573. 

  573.     if($right)
    574. 

  574.       $query=$this->xset->select_query(array('order'=>'datep ASC',
    575. 

  575. 					     'cond'=>array('blog'=>array('=',$oid),
    576. 

  576. 							   'paperup'=>array('=',$post),
    577. 

  577. 							   'dtype'=>array('=','comment'))));
    578. 

  578.     else
    579. 

  579.       $query=$this->xset->select_query(array('order'=>'datep ASC',
    580. 

  580. 					     'cond'=>array('blog'=>array('=',$oid),
    581. 

  581. 							   'paperup'=>array('=',$post),
    582. 

  582. 							   'PUBLISH'=>array('=',1),
    583. 

  583. 							   'dtype'=>array('=','comment'))));
    584. 

  584. 

  585.     //commentaire du post
    586. 

  586.     $this->xset->browse(array('tplentry'=>$tplentry.'comment','select'=>$query, 
    587. 

  587. 			      'pagesize'=>100, 'selectedfields'=>'all'));
    588. 

  588.     $this->addComment(array('tplentry'=>$tplentry.'add'));	
    589. 

  589. 

  590.     // commentaires recents
    591. 

  591.     $ar=array();
    592. 

  592.     $ar['select']=$this->xset->select_query(array('order'=>'datep DESC','cond'=>
    593. 

  593. 						  array('dtype'=>array('=','comment'),'blog'=>array('=',$oid))));
    594. 

  594.     $ar['selectedfields']=array('datep','title','blog','paperup');
    595. 

  595.     $ar['pagesize']=10;
    596. 

  596.     $ar['tplentry']=$tplentry.'comments';
    597. 

  597.     XModTable::browse($ar);
    598. 

  598.     //liste de tous les posts
    599. 

  599.     $ar=array();
    600. 

  600.     // list des posts
    601. 

  601.     $arsel =array();
    602. 

  602.     //classer par date decroissant 
    603. 

  603.     $arsel['order']='datep DESC';
    604. 

  604. 

  605.     //selection de tous les posts  brposts_lines_oid
    606. 

  606.     $arsel['cond'] = array();
    607. 

  607.     $arsel['cond']['dtype'] = array('=','post');
    608. 

  608.     $arsel['cond']['blog'] = array('=',$oid);
    609. 

  609. 

  610.     $ar['select']=$this->xset->select_query(array('order'=>'datep DESC','cond'=>
    611. 

  611. 						  array('dtype'=>array('=','post'),
    612. 

  612. 							'blog'=>array('=',$oid))));
    613. 

  613.     $ar['selectedfields']=array('title','datep','categ');
    614. 

  614.     $ar['pagesize']=9999;
    615. 

  615.     $ar['tplentry']=$tplentry.'posts';
    616. 

  616.     $brpost = $this->xset->browse($ar);
    617. 

  617. 

  618.     //construction du tableau des categ et archive
    619. 

  619.     $tbcateg = array_unique($brpost['lines_categ']); 
    620. 

  620.     sort($tbcateg,SORT_STRING);
    621. 

  621.     $tb['categ'] = $tbcateg;
    622. 

  622.     $tbodatep = $brpost['lines_odatep'];
    623. 

  623. 

  624.     foreach($tbodatep as $k=>$v){
    625. 

  625.       $tbdatep[$k] =       date('Y-m',strtotime($v->raw));
    626. 

  626.     }
    627. 

  627.     $tbdatep = array_unique($tbdatep);
    628. 

  628.     sort($tbdatep);
    629. 

  629.     $tb['datep'] = $tbdatep;
    630. 

  630.     XShell::toScreen1($tplentry."classement",$tb);
    631. 

  631. 

  632.   }
    633. 

  633.   /// affichage d'un article
    634. 

  634.   function displayPost($ar=NULL) {
    635. 

  635.     $p=new XParam($ar, array());
    636. 

  636.     $tplentry=$p->get('tplentry');
    637. 

  637.     $oid=$p->get('oid');
    638. 

  638.     $post=$p->get('post');
    639. 

  639. 

  640.     $r = $this->xset->display(array('tplentry'=>TZR_RETURN_DATA, 'oid'=>$oid));
    641. 

  641.     XShell::toScreen1($tplentry.'blog',$r);
    642. 

  642.     $r = $this->xset->display(array('tplentry'=>TZR_RETURN_DATA, 'oid'=>$post));
    643. 

  643.     if ($this->object_sec){
    644. 

  644.       $lang_data = XShell::getLangData();
    645. 

  645.       $oids = array($post);
    646. 

  646.       list($r['object_sec']) = $GLOBALS['XUSER']->getObjectsAccess($this, $lang_data, $oids);
    647. 

  647.     }
    648. 

  648.     XShell::toScreen1($tplentry.'post',$r);
    649. 

  649.     $right= $this->secure($oid, 'validatePost');
    650. 

  650.     if($right)
    651. 

  651.       $query=$this->xset->select_query(array('order'=>'datep ASC',
    652. 

  652. 					     'cond'=>array('blog'=>array('=',$oid),
    653. 

  653. 							   'paperup'=>array('=',$post),
    654. 

  654. 							   'dtype'=>array('=','comment'))));
    655. 

  655.     else
    656. 

  656.       $query=$this->xset->select_query(array('order'=>'datep ASC',
    657. 

  657. 					     'cond'=>array('blog'=>array('=',$oid),
    658. 

  658. 							   'paperup'=>array('=',$post),
    659. 

  659. 							   'PUBLISH'=>array('=',1),
    660. 

  660. 							   'dtype'=>array('=','comment'))));
    661. 

  661. 

  662.     $this->xset->browse(array('tplentry'=>$tplentry.'comment','select'=>$query, 
    663. 

  663. 			      'pagesize'=>100, 'selectedfields'=>'all'));
    664. 

  664.     $this->addComment(array('tplentry'=>$tplentry.'add'));	
    665. 

  665. 

  666.     $ar=array();
    667. 

  667.     $ar['select']=$this->xset->select_query(array('order'=>'datep DESC','cond'=>
    668. 

  668. 						  array('dtype'=>array('=','post'),
    669. 

  669. 							'blog'=>array('=',$oid))));
    670. 

  670.     $ar['selectedfields']=array('datep','title');
    671. 

  671.     $ar['pagesize']=100;
    672. 

  672.     $ar['tplentry']=$tplentry.'posts';
    673. 

  673.     XModTable::browse($ar);
    674. 

  674.     // commentaires recents
    675. 

  675.     $ar=array();
    676. 

  676.     $ar['select']=$this->xset->select_query(array('order'=>'datep DESC','cond'=>
    677. 

  677. 						  array('dtype'=>array('=','comment'),'blog'=>array('=',$oid))));
    678. 

  678.     $ar['selectedfields']=array('datep','title','blog','paperup');
    679. 

  679.     $ar['pagesize']=10;
    680. 

  680.     $ar['tplentry']=$tplentry.'comments';
    681. 

  681.     XModTable::browse($ar);
    682. 

  682.   }
    683. 

  683. 

  684.   /// suppression d'un article et tous les commentaires associes
    685. 

  685.   function delPost($ar=NULL) {
    686. 

  686.     $p=new XParam($ar, array());
    687. 

  687.     $post=$p->get('post');
    688. 

  688.     updateQuery('delete from '.$this->table.' where KOID="'.$post.'" OR paperup="'.$post.'"');
    689. 

  689.   }
    690. 

  690.   /// validation d'un blog
    691. 

  691.   function validateBlog($ar=NULL) {
    692. 

  692.     $p=new XParam($ar, array());
    693. 

  693.     $oid=$p->get('oid');
    694. 

  694.     $this->publish(array('oid'=>$oid));
    695. 

  695.   }
    696. 

  696.   /// validation d'un article ou d'un commentaire
    697. 

  697.   function validatePost($ar=NULL) {
    698. 

  698.     $p=new XParam($ar, array());
    699. 

  699.     $post=$p->get('post');
    700. 

  700.     $this->publish(array('oid'=>$post));
    701. 

  701.   }
    702. 

  702. 

  703. 

  704.   function addComment($ar=NULL) {
    705. 

  705.     parent::insert($ar);
    706. 

  706.   }
    707. 

  707. 

  708.   /// ajout d'un commentaire sur un article.
    709. 

  709.   function procAddComment($ar=NULL) {
    710. 

  710.     $p=new XParam($ar, array());
    711. 

  711.     $ar['dtype']='comment';
    712. 

  712.     $ar['blog']=$p->get('oid');
    713. 

  713.     $ar['paperup']=$p->get('post');
    714. 

  714.     $ar['datep']=date('Y-m-d H:i:s');
    715. 

  715.     if(!XUser::isNobody()) {
    716. 

  716.       $ar['whoa'] = XUser::get_current_user_uid();
    717. 

  717.     }
    718. 

  718.     parent::procInsert($ar);
    719. 

  719.   }
    720. 

  720. 

  721.   /// ajout d'un blog dans la liste des blogs
    722. 

  722.   function addBlog($ar) {
    723. 

  723.     parent::insert($ar);
    724. 

  724.   }
    725. 

  725. 

  726.   /// ajout d'un blog dans la liste des blogs
    727. 

  727.   function procAddBlog($ar=NULL) {
    728. 

  728.     $p=new XParam($ar, array());
    729. 

  729.     $ar['dtype']='blog';
    730. 

  730.     $ar['datep']=date('Y-m-d H:i:s');
    731. 

  731.     parent::procInsert($ar);
    732. 

  732.   }
    733. 

  733.   /// generation de l'ecran des proproetes d'un blog
    734. 

  734.   function editBlog($ar) {
    735. 

  735.     parent::edit($ar);
    736. 

  736.   }
    737. 

  737.   /// modifications d'un blog
    738. 

  738.   function procEditBlog($ar=NULL) {
    739. 

  739.     $p=new XParam($ar, array());
    740. 

  740.     parent::procEdit($ar);
    741. 

  741.   }
    742. 

  742. 

  743.   /// suppression d'un blog
    744. 

  744.   function delBlog($ar=NULL){
    745. 

  745.     $p=new XParam($ar, array());
    746. 

  746.     $oid=$p->get('oid');
    747. 

  747.     $blog=$this->xset->display(array(
    748. 

  748. 				     'oid'=>$oid,
    749. 

  749. 				     'tplentry'=>TZR_RETURN_DATA
    750. 

  750. 				     )
    751. 

  751. 			       );
    752. 

  752.     if($blog['odtype']->raw=='blog'){
    753. 

  753.       updateQuery('delete from '.$this->table.' where KOID="'.$oid.'" OR blog="'.$oid.'"');
    754. 

  754.     }
    755. 

  755.   }
    756. 

  756. 

  757.   /// gestion des posts
    758. 

  758.   function editPost($ar=NULL) {
    759. 

  759.     $p=new XParam($ar, array());
    760. 

  760.     $ar['oid']=$p->get('post');
    761. 

  761.     $ar['options']['blog']['readonly']=2;
    762. 

  762.     parent::edit($ar);
    763. 

  763.   }
    764. 

  764.   function procEditPost($ar=NULL) {
    765. 

  765.     $p=new XParam($ar, array());
    766. 

  766.     parent::procEdit($ar);
    767. 

  767.   }
    768. 

  768. 

  769.   function addPost($ar=NULL) {
    770. 

  770.     parent::insert($ar);
    771. 

  771.   }
    772. 

  772.   function procAddPost($ar=NULL) {
    773. 

  773.     $p=new XParam($ar, array());
    774. 

  774.     $ar['dtype']='post';
    775. 

  775.     $ar['blog']=$p->get('oid');
    776. 

  776.     $ar['datep']=date('Y-m-d H:i:s');
    777. 

  777.     $who = $p->get('who');
    778. 

  778.     if (!empty($who['url'])){
    779. 

  779.       $ar['who'] = array('label'=>$who['label'],
    780. 

  780. 			 'url'=>'mailto:'.$who['url'],
    781. 

  781. 			 '_target'=>'_blank');
    782. 

  782. 	
    783. 

  783.     }
    784. 

  784.     parent::procInsert($ar);
    785. 

  785.   }
    786. 

  786. 

  787.   // gestion des commentaires
    788. 

  788.   //
    789. 

  789.   function editComment($ar=NULL) {
    790. 

  790.     $p=new XParam($ar, array());
    791. 

  791.     $ar['oid']=$p->get('post');
    792. 

  792.     parent::edit($ar);
    793. 

  793.   }
    794. 

  794.   function procEditComment($ar=NULL) {
    795. 

  795.     $p=new XParam($ar, array());
    796. 

  796.     parent::procEdit($ar);
    797. 

  797.   }
    798. 

  798. 

  799.   /// gestion des liens
    800. 

  800.   function addLink($ar=NULL) {
    801. 

  801.     parent::insert($ar);
    802. 

  802.   }
    803. 

  803.   function procAddLink($ar=NULL) {
    804. 

  804.     $p=new XParam($ar, array());
    805. 

  805.     $ar['dtype']='link';
    806. 

  806.     $ar['blog']=$p->get('oid');
    807. 

  807.     $ar['datep']=date('Y-m-d H:i:s');
    808. 

  808.     parent::procInsert($ar);
    809. 

  809.   }
    810. 

  810.   function delLink($ar=NULL) {
    811. 

  811.     $p=new XParam($ar,NULL);
    812. 

  812.     $link=$p->get('link');
    813. 

  813.     updateQuery('delete from '.$this->table.' where KOID="'.$link.'" AND dtype="link"');
    814. 

  814.   }
    815. 

  815. 

  816.   /// Action principale du menu
    817. 

  817.   public function getMainAction(){
    818. 

  818.     return $GLOBALS['TZR_SESSION_MANAGER']::complete_self().'moid='.$this->_moid.'&function=browseBlogs&tplentry=br&template=xmodblog/browseblogs.html';
    819. 

  819.   }
    820. 

  820. 

  821.   /// cette fonction est appliquee pour afficher l'ensemble des methodes de ce module
    822. 

  822.   protected function _actionlist(&$my=NULL) {
    823. 

  823.     XModule::_actionlist($my);
    824. 

  824.     parent::_clearActionlist($my);
    825. 

  825.     $myclass='xmodblog';
    826. 

  826.     $moid=$this->_moid;
    827. 

  827.     $dir='xmodblog';
    828. 

  828.     $cnt=$this->countBlogs();
    829. 

  829.     $o1=new XModuleAction($this, 'browseBlogs', XLabels::getSysLabel($myclass,'browseblogs','text'),
    830. 

  830. 			  '&amp;moid='.$moid.
    831. 

  831. 			  '&amp;_function=browseBlogs&amp;tplentry=br&amp;'.
    832. 

  832. 			  'template='.$dir.'/browseblogs.html');
    833. 

  833.     $o1->containerable=$o1->menuable=true;
    834. 

  834.     $o1->setToolbar('general','browse');
    835. 

  835.     $my['browse']=$o1;
    836. 

  836.     $oid=@$_REQUEST['oid'];
    837. 

  837.     $post=@$_REQUEST['post'];
    838. 

  838.     if($this->secure(NULL, ':admin')) {
    839. 

  839.       $o1=new XModuleAction($this, 'administration', XLabels::getSysLabel('general', 'administration', 'text'),
    840. 

  840. 			    '&moid='.$this->_moid.'&function=adminBrowseFields&template=xmodule/admin/browseFields.html');
    841. 

  841.       $o1->homepageable = false;
    842. 

  842.       $o1->menuable=true;
    843. 

  843.       $o1->quicklinkable=true;
    844. 

  844.       $o1->group='actions';
    845. 

  845.       $o1->setToolBar('general', 'administration');
    846. 

  846.       $my['administration']=$o1;
    847. 

  847.     }
    848. 

  848.     if($this->secure(NULL, 'addBlog')) {
    849. 

  849.       $o1=new XModuleAction($this, 'addblog', XLabels::getSysLabel($myclass,'addblog','text'),
    850. 

  850. 			    '&amp;moid='.$moid.
    851. 

  851. 			    '&amp;_function=addBlog&amp;tplentry=br&amp;'.
    852. 

  852. 			    'template='.$dir.'/addblog.html');
    853. 

  853.       $o1->homepageable=false;
    854. 

  854.       $o1->menuable=$o1->quicklinkable=true;
    855. 

  855.       $o1->group='edit';
    856. 

  856.       $o1->setToolbar('general','new');
    857. 

  857.       $my['insert']=$o1;
    858. 

  858.     }
    859. 

  859.     if(!empty($oid)) {
    860. 

  860.       $o1=new XModuleAction($this, 'browseBlog', XLabels::getSysLabel($myclass,'browseblog','text'),
    861. 

  861. 			    '&amp;moid='.$moid.
    862. 

  862. 			    '&amp;_function=browseBlog&amp;tplentry=br&amp;oid='.$_REQUEST['oid'].'&amp;'.
    863. 

  863. 			    'template='.$dir.'/browseblog.html');
    864. 

  864.       $o1->homepageable=$o1->menuable=$o1->quicklinkable=true;
    865. 

  865.       $o1->setToolbar('general','view');
    866. 

  866.       $my['browseblog']=$o1;
    867. 

  867.       $right= $this->secure($oid, 'addPost');
    868. 

  868.       $isablog=$this->isA($oid,'blog');
    869. 

  869.       $isapost=$this->isA($post,'post');
    870. 

  870.       $isacomment=$this->isA($post,'comment');
    871. 

  871.       if($isablog  && $right) {
    872. 

  872. 	$o1=new XModuleAction($this, 'addpost', XLabels::getSysLabel($myclass,'addpost','text'),
    873. 

  873. 			      '&amp;moid='.$moid.
    874. 

  874. 			      '&amp;_function=addPost&amp;tplentry=br&amp;oid='.$oid.'&amp;'.
    875. 

  875. 			      'template='.$dir.'/addpost.html');
    876. 

  876. 	$o1->homepageable=$o1->menuable=$o1->quicklinkable=true;
    877. 

  877. 	$o1->group='edit';
    878. 

  878. 	$o1->setToolbar('general','new');
    879. 

  879. 	$my['insert']=$o1;
    880. 

  880.       }
    881. 

  881.       $right= $this->secure($oid, 'addComment');
    882. 

  882.       if($isapost){
    883. 

  883. 	if($right) {
    884. 

  884. 	  $o1=new XModuleAction($this, 'addcomment', XLabels::getSysLabel($myclass,'addcomment','text'),
    885. 

  885. 				'&amp;moid='.$moid.
    886. 

  886. 				'&amp;_function=addComment&amp;tplentry=br&amp;oid='.$oid.'&amp;'.
    887. 

  887. 				'&amp;post='.$post.'&amp;template='.$dir.'/addcomment.html');
    888. 

  888. 	  $o1->homepageable=$o1->menuable=$o1->quicklinkable=true;
    889. 

  889. 	  $o1->group='edit';
    890. 

  890. 	  $o1->setToolbar('general','new');
    891. 

  891. 	  $my['insert']=$o1;
    892. 

  892. 	}
    893. 

  893. 	$right= $this->secure($oid, 'editPost');
    894. 

  894. 	if($right) {
    895. 

  895. 	  $o1=new XModuleAction($this, 'edit', XLabels::getSysLabel($myclass,'editpost','text'),
    896. 

  896. 				'&amp;moid='.$moid.
    897. 

  897. 				'&amp;_function=editPost&amp;tplentry=br&amp;oid='.$oid.'&amp;'.
    898. 

  898. 				'&amp;post='.$post.'&amp;template='.$dir.'/editpost.html');
    899. 

  899. 	  $o1->homepageable=$o1->menuable=$o1->quicklinkable=true;
    900. 

  900. 	  $o1->group='edit';
    901. 

  901. 	  $o1->setToolbar('general','edit');
    902. 

  902. 	  $my['edit']=$o1;
    903. 

  903. 	}
    904. 

  904.       }
    905. 

  905.     }
    906. 

  906.     unset($my['query']);
    907. 

  907. 

  908.     if($this->interactive) {
    909. 

  909.       $o1=new XModuleAction($this,'browseBlogs',$this->modulename,
    910. 

  910. 			    '&moid='.$moid.'&_function=browseBlogs&tplentry=br&template='.$dir.'/browseblogs.html');
    911. 

  911.       $my['stack'][]=$o1;
    912. 

  912.       if(!empty($oid)) {
    913. 

  913. 	$blog=$this->_getBlogTitle($oid);
    914. 

  914. 	$o1=new XModuleAction($this,'browseBlog',$blog['otitle']->toText(),
    915. 

  915. 			      '&moid='.$moid.'&_function=browseBlog&tplentry=br&oid='.$oid.'&template='.$dir.'/browseblog.html');
    916. 

  916. 	$my['stack'][]=$o1;
    917. 

  917. 	if($isapost){
    918. 

  918. 	  $postd=$this->_getPostTitle($post);
    919. 

  919. 	  $o1=new XModuleAction($this,'displayPost',$postd['otitle']->toText(),
    920. 

  920. 				'&moid='.$moid.'&_function=displayPost&tplentry=br&oid='.$oid.'&post='.$post.
    921. 

  921. 				'&template='.$dir.'/displaypost.html');
    922. 

  922. 	  $my['stack'][]=$o1;
    923. 

  923. 	}elseif($isacomment){
    924. 

  924. 	  $com=$this->_getCommentTitle($post);
    925. 

  925. 	  $postd=$this->_getPostTitle($com['opaperup']->raw);
    926. 

  926. 	  $o1=new XModuleAction($this,'displayPost',$postd['otitle']->toText(),
    927. 

  927. 				'&moid='.$moid.'&_function=displayPost&tplentry=br&oid='.$oid.'&post='.$postd['oid'].
    928. 

  928. 				'&template='.$dir.'/displaypost.html');
    929. 

  929. 	  $my['stack'][]=$o1;
    930. 

  930. 	  $o1=new XModuleAction($this,'editComment',$com['otitle']->toText(),
    931. 

  931. 				'&moid='.$moid.'&_function=editComment&tplentry=br&oid='.$oid.'&post='.$com['oid'].
    932. 

  932. 				'&template='.$dir.'/editcomment.html');
    933. 

  933. 	  $my['stack'][]=$o1;
    934. 

  934. 	}
    935. 

  935.       }
    936. 

  936.       $modsubmoid=XModule::getMoid(XMODSUB_TOID);
    937. 

  937.       if(!empty($modsubmoid)){
    938. 

  938. 	$o1=new XModuleAction($this, 'subscribe', XLabels::getSysLabel('xmodsub','subadd','text'),
    939. 

  939. 			      '&amoid='.$this->_moid.'&class=XModSub&moid='.$modsubmoid.
    940. 

  940. 			      '&_function=preSubscribe&tplentry=br&template=xmodsub/sub.html&aoid='.$oid);
    941. 

  941. 	$o1->menuable=true;
    942. 

  942. 	$o1->group='more';
    943. 

  943. 	$my['subscribe']=$o1;
    944. 

  944.       }
    945. 

  945.     }
    946. 

  946.   }
    947. 

  947. }
    948. 

  948. ?>
    949.