/**
* $Id:$
*
* @package Mediboard
* @subpackage dPfacturation
* @author SARL OpenXtrem <*****@*****.**>
* @license GNU General Public License, see http://www.gnu.org/licenses/gpl.html
* @version $Revision:$
*/
CCanDo::checkEdit();
$date_min = CValue::getOrSession("_date_min", CMbDT::date());
$date_max = CValue::getOrSession("_date_max", CMbDT::date());
$type_journal = CValue::get("type_journal");
$date_min = CMbDT::dateTime($date_min);
$date_max = CMbDT::dateTime(CMbDT::date("+1 day", $date_max));
$ljoin = array();
$ljoin["facture_journal"] = "facture_journal.journal_id = files_mediboard.object_id";
$where = array();
$where["object_class"] = " = 'CJournalBill'";
$where["file_date"] = "BETWEEN '{$date_min}' AND '{$date_max}'";
$where["facture_journal.type"] = "= '{$type_journal}'";
$file = new CFile();
$files = $file->loadList($where, null, null, null, $ljoin);
foreach ($files as $_file) {
$_file->canDo();
}
// Création du template
$smarty = new CSmartyDP();
$smarty->assign("files", $files);
$smarty->assign("name_readonly", 1);
$smarty->display("vw_files_journaux.tpl");
* @package Mediboard
* @author SARL OpenXtrem <*****@*****.**>
* @license GNU General Public License, see http://www.gnu.org/licenses/gpl.html
* @version $Revision$
* @link http://www.mediboard.org
*/
$nb_files = round(CValue::get("nb_files", 0));
$date_debut = CValue::get("date_debut");
$date_fin = CValue::get("date_fin");
$purge = CValue::get("purge", 0);
$step_from = CValue::get("step_from", 0);
$file = new CFile();
if ($date_debut && $date_fin) {
$where = array();
$where["file_date"] = "BETWEEN '" . CMbDT::dateTime($date_debut) . "' AND '" . CMbDT::dateTime($date_fin) . "'";
$files = $file->loadList($where, null, "{$step_from}, 100");
$count = 0;
foreach ($files as $_file) {
if (!file_exists($_file->_file_path) || filesize($_file->_file_path) == 0 || file_get_contents($_file->_file_path) == "") {
if (!$purge) {
CAppUI::stepAjax($_file->_id);
$count++;
continue;
}
if ($msg = $_file->purge()) {
CAppUI::stepAjax("File id: " . $_file->_id . " - " . $_file->purge());
} else {
$count++;
}
}
}
CCanDo::checkEdit();
$do = CValue::get("do", "0");
// Auto send categories
$category = new CFilesCategory();
$category->send_auto = "1";
foreach ($categories = $category->loadMatchingList() as $_category) {
$_category->countDocItems();
$_category->countUnsentDocItems();
}
// Unsent docItems
$max_load = CAppUI::conf("dPfiles CDocumentSender auto_max_load");
$where["file_category_id"] = CSQLDataSource::prepareIn(array_keys($categories));
$where["etat_envoi"] = "!= 'oui'";
$where["object_id"] = "IS NOT NULL";
$file = new CFile();
$items["CFile"] = $file->loadList($where, "file_id DESC", $max_load);
$count["CFile"] = $file->countList($where);
$document = new CCompteRendu();
$items["CCompteRendu"] = $document->loadList($where, "compte_rendu_id DESC", $max_load);
$count["CCompteRendu"] = $document->countList($where);
// Sending
$max_send = CAppUI::conf("dPfiles CDocumentSender auto_max_send");
foreach ($items as $_items) {
$sent = 0;
/** @var CDocumentItem[] $_items */
foreach ($_items as $_item) {
$_item->loadTargetObject();
if ($do && !$_item->_send_problem) {
// Max sent
if (++$sent > $max_send) {
break;
$extensions = CValue::get("extensions", CFile::$file_types);
$file = new CFile();
$where = array();
$where["object_class"] = " NOT LIKE 'CFile'";
// Ne convertir que les fichiers dont le nom se finit par une extension convertible
$like = "";
$types = preg_split("/[\\s]+/", $extensions);
foreach ($types as $key => $_type) {
$like .= " file_name LIKE '%.{$_type}'";
if ($key != count($types) - 1) {
$like .= " OR";
}
}
$where[] = $like;
$where[] = "file_id NOT IN (SELECT object_id from files_mediboard WHERE object_class LIKE 'CFile')";
$order = "file_id DESC";
$files = $file->loadList($where, $order, $nb_files);
$nb_files_total = $file->countList($where);
$converted = 0;
$not_converted = "";
foreach ($files as $_file) {
if ($_file->convertToPDF()) {
$converted++;
} else {
$not_converted .= $_file->_id . " - ";
}
}
CAppUI::stepAjax("{$converted}/" . count($files) . " fichiers convertis parmi {$nb_files_total}");
if ($converted != count($files)) {
trigger_error("Les fichiers suivants n'ont pas été convertis : {$not_converted}", E_USER_ERROR);
}
