'; + $res.='

'; + $res.=''; + $res.='

'; $res .= ''; $res .= ''; $res .= ''; - $res .= ''; - $res .= ''; + $res .= ''; + $res .= ''; + $res.=''; + $res.=''; + $res .= ''; $res .= ''; $res .= ''; $i = 0; @@ -356,7 +365,10 @@ html{height:100%}' . "\n"; $res .= ''; $res .= ''; $res .= ''; + $res.=''; + $res.=''; $res .= ''; + $res .= ''; $res .= ''; $i++; } @@ -369,6 +381,175 @@ html{height:100%}' . "\n"; echo $res; } + public static function exportLinksAsExcel($args) { + global $core; + + $book_id = $args[1]; + $time = $args[2]; + + $daoBook = new wsDAOBook($core->con); + $pages = $daoBook->getPagesOfBook($book_id); + + $dao = new wsDAODocument($core->con); + $dao->getLinksAndRulers($book_id, $links, $rulers, $time); + + $cols = array('document_id' => __('Document'), 'document_page' => __('Page du document'), + 'page' => __('Page de la publication'), 'left' => __('x'), 'top' => __('y'), 'width' => __('Largeur'), 'height' => __('Hauteur'), + 'type' => __('Type'), 'to' => __('Destination'), 'target' => __('Cible'), + 'infobulle' => __('Infobulle'), 'numerotation' => __('NumÃ©rotation'), + 'display_area' => __('Activer la surbrillance'), + 'video_loop' => __('Video : boucle'), 'video_auto_start' => __('Video : dÃ©marrage automatique'), 'video_controls' => __('VidÃ©o : afficher les contrÃ´les'), 'video_sound_on' => __('VidÃ©o : activer le son'), + 'inline' => __('VidÃ©o : afficher dans la page'), 'video_width' => __('VidÃ©o : Largeur du popup'), 'video_height' => __('VidÃ©o : Hauteur du popup'), + 'interactive' => __('InteractivitÃ©'), 'video_service' => __('Webvideo : service') + ); + + $xls = new PHPExcel(); + $s = $xls->setActiveSheetIndex(0); + $s->setTitle('Links'); + + + + // Labels + $i = 0; + foreach ($cols as $id => $label) { + $s->setCellValueByColumnAndRow($i, 1, $id); + $s->getColumnDimensionByColumn($i)->setAutoSize(true); + $s->getStyleByColumnAndRow($i, 1)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); + $i++; + } + // Links + $j = 2; + foreach ($links as $l) { + $i = 0; + foreach ($cols as $id => $label) { + if ($id == 'document_id' || $id == 'document_page') { + $infos = $pages[$l['page']]; + $value = $infos[$id]; + } else { + if (is_bool($l[$id])) { + $l[$id] = $l[$id] ? 1 : 0; + } + if ($id == 'numerotation') { + if ($l[$id] == 'false') { + $l[$id] = 'physical'; + } + } + $value = $l[$id]; + } + $s->setCellValueByColumnAndRow($i, $j, $value); + $s->getStyleByColumnAndRow($i, $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); + $i++; + } + $j++; + } + // Rulers + $s = $xls->createSheet(); + $s->setTitle('Rulers'); + + $rcols = array('document_id', 'document_page', 'page', 'type', 'pos'); + $i = 0; + // Labels + foreach ($rcols as $id) { + $s->setCellValueByColumnAndRow($i, 1, $id); + $s->getColumnDimensionByColumn($i)->setAutoSize(true); + $s->getStyleByColumnAndRow($i, 1)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); + $i++; + } + + // Contents + $j = 2; + foreach ($rulers as $r) { + $i = 0; + foreach ($rcols as $id) { + if ($id == 'document_id' || $id == 'document_page') { + $infos = $pages[$r['page']]; + $value = $infos[$id]; + } else { + $value = $r[$id]; + } + $s->setCellValueByColumnAndRow($i, $j, $value); + $s->getStyleByColumnAndRow($i, $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); + $i++; + } + $j++; + } + + $xls->setActiveSheetIndex(0); + + ob_end_clean(); + files::registerMimeTypes(array('xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')); + cubeHTTP::forceDownload('links_' . $book_id . '_' . $time . '.xlsx', false); + + $writer = new PHPExcel_Writer_Excel2007($xls); + $writer->save('php://output'); + + exit; + } + + public static function importLinksAsExcel($args) { + global $core; + $book_id = $args[1]; + + $xls = new PHPExcel(); + $reader = new PHPExcel_Reader_Excel2007(); + $xls = $reader->load($_FILES['file']['tmp_name']); + + $s = $xls->setActiveSheetIndexByName('Links'); + $i = 0; + $links = array(); + foreach ($s->getRowIterator() as $row) { + $cellIterator = $row->getCellIterator(); + $cellIterator->setIterateOnlyExistingCells(false); + if ($i == 0) { + $cols = array(); + foreach ($cellIterator as $cell) { + $cols[] = $cell->getValue(); + } + } else { + $link = array(); + $j = 0; + foreach ($cellIterator as $cell) { + $link[$cols[$j]] = $cell->getValue(); + $j++; + } + $links[] = $link; + } + + $i++; + } + + $i = 0; + $rulers = array(); + $s = $xls->setActiveSheetIndexByName('Rulers'); + foreach ($s->getRowIterator() as $row) { + $cellIterator = $row->getCellIterator(); + $cellIterator->setIterateOnlyExistingCells(false); + if ($i == 0) { + $cols = array(); + foreach ($cellIterator as $cell) { + $cols[] = $cell->getValue(); + } + } else { + $link = array(); + $j = 0; + foreach ($cellIterator as $cell) { + $ruler[$cols[$j]] = $cell->getValue(); + $j++; + } + + $rulers[] = $ruler; + } + $i++; + } + + + + $dao = new wsDAODocument($core->con); + $dao->setLinksAndRulers($book_id, json_encode($links), json_encode($rulers), 'Import from excel',$core->user->utilisateur_id); + + http::redirect(SITE_PATH . 'restoreLinks/' . $book_id); + } + public static function editComposition($args) { $fv = array(session_name() => session_id(), 'book_id' => $args[0]); @@ -434,7 +615,7 @@ html{height:100%}' . "\n"; $e[2] = TIME; //http::redirect(SITE_PATH . 'viewer/' . implode('_', $e) . '/' . $wmode); $url = SITE_PATH . 'viewer/' . implode('_', $e) . '/' . $wmode . '/'; - $url = rtrim($url, '/').'/'; + $url = rtrim($url, '/') . '/'; ob_end_clean(); echo ''; exit; diff --git a/inc/ws/DAO/class.ws.dao.document.php b/inc/ws/DAO/class.ws.dao.document.php index 73059882b..defabeb16 100644 --- a/inc/ws/DAO/class.ws.dao.document.php +++ b/inc/ws/DAO/class.ws.dao.document.php @@ -33,8 +33,8 @@ class wsDAODocument extends commonDAO { } } - public function restoreLinksVersion($book_id, $update) { - $sql = 'INSERT INTO document_links_versions SELECT document_id,links,rulers,' . TIME . ' FROM document_links_versions WHERE `update`=' . $update . ' AND document_id IN (SELECT document_id FROM book_pages WHERE book_id=' . $book_id . ')'; + public function restoreLinksVersion($book_id, $update, $user=0) { + $sql = 'INSERT INTO document_links_versions (document_id,links,rulers,update,comments,user) SELECT document_id,links,rulers,' . TIME . ',\'Links from a previous version\',' . $user . ' FROM document_links_versions WHERE `update`=' . $update . ' AND document_id IN (SELECT document_id FROM book_pages WHERE book_id=' . $book_id . ')'; $this->con->execute($sql); } @@ -102,7 +102,7 @@ class wsDAODocument extends commonDAO { return implode("\n", $log); } - public function setLinksAndRulers($book_id, $links, $rulers) { + public function setLinksAndRulers($book_id, $links, $rulers, $comments='', $user=0) { $daoBook = new wsDAOBook($this->con); $pages = $daoBook->getPagesOfBook($book_id); @@ -157,6 +157,8 @@ class wsDAODocument extends commonDAO { $c->document_id = $document_id; $c->links = json_encode($links[$document_id]); $c->rulers = json_encode($rulers[$document_id]); + $c->comments = $comments; + $c->user = $user; $c->insert(); } @@ -177,7 +179,7 @@ class wsDAODocument extends commonDAO { $pages = $daoBook->getPagesOfBook($book_id); $book = $daoBook->selectById($book_id); $width = $book->parametres->width; - + $xml = simplexml_load_file('http://ws.fluidbook.com/books/' . $book_id . '/data/links.xml'); $links = $xml->xpath('//oneLink'); @@ -251,7 +253,7 @@ class wsDAODocument extends commonDAO { $c = $this->con->openCursor('document_links_versions'); $c->update = TIME; - + krsort($links); foreach ($links as $document_id => $l) { @@ -266,7 +268,14 @@ class wsDAODocument extends commonDAO { $c->update('WHERE book_id=\'' . $this->con->escape($book_id) . '\''); } - public function getLinksAndRulers($book_id, &$links, &$rulers) { + public function getLinksAndRulers($book_id, &$links, &$rulers, $time=null) { + + if (is_null($time)) { + $timeQuery = 'ORDER BY `update` DESC LIMIT 1'; + } else { + $timeQuery = 'AND `update`=' . $time; + } + $daoBook = new wsDAOBook($this->con); $pages = $daoBook->getPagesOfBook($book_id); @@ -282,7 +291,7 @@ class wsDAODocument extends commonDAO { $rulers = array(); foreach ($documents as $d) { - $r = $this->con->select('SELECT * FROM document_links_versions WHERE document_id=' . $d . ' ORDER BY `update` DESC LIMIT 1'); + $r = $this->con->select('SELECT * FROM document_links_versions WHERE document_id=' . $d . ' ' . $timeQuery); if (mb_substr($r->links, 1, 1) == ':') { $ll = unserialize($r->links); @@ -324,7 +333,7 @@ class wsDAODocument extends commonDAO { public function getLinksVersions($book_id) { $res = array(); - $r = $this->con->select('SELECT * FROM document_links_versions WHERE document_id IN(SELECT document_id FROM book_pages WHERE book_id=\'' . $this->con->escape($book_id) . '\')'); + $r = $this->con->select('SELECT l.*,u.prenom,u.nom FROM document_links_versions l LEFT JOIN utilisateurs u ON l.user=u.utilisateur_id WHERE document_id IN(SELECT document_id FROM book_pages WHERE book_id=\'' . $this->con->escape($book_id) . '\')'); while ($r->fetch()) { if (!isset($res[$r->update])) { $res[$r->update] = array('links' => 0, 'rulers' => 0); @@ -337,6 +346,13 @@ class wsDAODocument extends commonDAO { foreach ($rr as $rrr) { $res[$r->update]['rulers'] += count($rrr); } + $res[$r->update]['comments'] = $r->comments; + if ($r->user > 0) { + $user = $r->prenom . ' ' . $r->nom; + } else { + $user = ''; + } + $res[$r->update]['user'] = $user; } return $res; } -- 2.39.5

' . __('Date') . '	' . __('Nombre de liens') . '	' . __('Nombre de rÃ¨gles') . '	' . __('Liens') . '	' . __('RÃ¨gles') . '	' . __('Utilisateur') . '	' . __('Informations') . '
' . date('Y-m-d H:i:s', $time) . '	' . $infos['links'] . '	' . $infos['rulers'] . '	'.$infos['user'].'	'.$infos['comments'].'	' . __('Restaurer') . '	' . str_replace(' ', ' ', __('Export Excel')) . '