a cada galley
// busco
//
// 37569
//afegeixo una línia a continuació $remote
//
$linia0 = "";
foreach ($gg as $gi=>$ai) {
// $remote = " \n ";
$remote = " \n ";
$x = rep("~($linia0\s+$gi.+)~mUs","$1$remote",$x);
}
//***********************************************
//PDF -->
$x = rep('~\w+~U','Accés',$x);
//elimino línies en blanc
//elimino línies duplicades
$xx = explode(PHP_EOL,$x);
$xx = array_map('rtrim',$xx);
$xx = array_filter($xx);
$xx = array_values($xx);
foreach ($xx as $i=>$l) if ($i) if ($xx[$i] == $xx[$i-1]) if (preg_match('~^\s*<(first|last)name>.*$~uU',$l)) unset($xx[$i-1]);
$x = implode(PHP_EOL,$xx);
//nou fitxer amb format d'importació raco
// $f9 = array_merge(['raco',$path],$issue_id,[basename($f)]);
$f9 = ['raco',$path,$num,basename($f)];
$f9 = implode('-',$f9);
$f9 = dirname(__FILE__) . "/xml.raco/$f9";
loga($f9);
//creo el nou fitxer
file_put_contents($f9,$x);
// loga($x);
}
function rep($find,$replace,$x) {
$x = preg_replace($find,$replace,$x,-1,$q);
loga([$find,$q,strlen($x)]);
return $x;
}
function transform_all() {
$ff = glob(dirname(__FILE__) . '/xml.rcub/*');
if (!$ff) return;
foreach ($ff as $f) transform($f);
}
function llista($tit,$dir) {
$ff = glob(dirname(__FILE__) . "/xml.$dir/*");
if (!$ff) return;
date_default_timezone_set('CET');
// rsort($ff);
echo "XML $tit
\n";
echo "\n";
foreach ($ff as $f) {
$size = number_format(filesize($f),0,',','.');
$name = basename($f);
$time = date('Y-m-d H:i',filemtime($f));
$view = "view";
$download = "download";
$delete = "esborra";
$id = substr($name,strpos($name,'native-'));
echo "
| $delete | $download | $size | $time | $name |
\n";
}
echo "
\n";
}
function cape() {
echo "
Conversió de fitxers \"Native XML Plugin\" de RCUB per importar a RACO
\n";
}
function upload() {
if (empty($_FILES['f'])) return;
extract($_FILES['f']); // name type tmp_name error size
$f9 = dirname(__FILE__) . "/xml.rcub/$name";
loga('Upload',$f9);
loga($_FILES['f']);
// loga(stat($tmp_name));
// loga(date('Y-m-d',$stat['mtime']));
if (file_exists($f9)) {
avis("Error: $name ja existeix");
} elseif ($type != 'text/xml') {
avis("Error: $name no és un XML");
} elseif (move_uploaded_file($tmp_name, $f9)) {
avis("Fitxer pujat correctament: $name");
transform($f9);
} else {
avis("Error pujant el fitxer: $name");
}
}
function form() {
echo "\n";
}
function delete() {
if (empty($_GET['x'])) return;
$f = dirname(__FILE__) . '/xml.' . $_GET['x'];
if (!file_exists($f)) return;
if (realpath($f) != $f) return;
$dir = pathinfo(dirname($f),PATHINFO_EXTENSION);
$name = basename($f);
if (unlink($f)) {
avis("Fitxer esborrat: $dir - $name");
loga("esborra $f",$f);
}
}
function download() {
if (empty($_GET['d'])) return;
$f = dirname(__FILE__) . '/xml.' . $_GET['d'];
if (!file_exists($f)) return;
header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename="'.basename($f).'"');
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');
header('Content-Length: ' . filesize($f));
readfile($f);
loga("download $f",$f);
die;
}
function avis($x) {
echo "$x
\n";
}
/*
[cn] => Gestio Documental
[colect2] => FPE
[uid] => ****
[mail] => ****@ub.edu
* */
function auten($x='') {
require_once '/usr/local/UB/CAS/ub_idp/config.php';
require_once $phpcas_path . '/CAS.php';
phpCAS::client(CAS_VERSION_2_0, $cas_host, $cas_port, $cas_context);
phpCAS::setCasServerCACert($cas_server_ca_cert_path);
phpCAS::forceAuthentication();
if (!$x) return;
$xx = preg_split('~\s+~',$x);
if (in_array(phpCAS::getUser(),$xx)) return phpCAS::getAttributes();
if (in_array(phpCAS::getAttribute('mail'),$xx)) return phpCAS::getAttributes();
pre(phpCAS::getAttributes());
die;
}
function pre($a) {
$trace = debug_backtrace();
$filename = $trace[0]['file'];
$linenumber = $trace[0]['line'];
$lines = file($filename);
$line = trim($lines[$linenumber-1]);
$a = print_r($a,true);
$a = htmlentities($a);
echo "$filename $linenumber $line\n$a
\n";
}
function loga($x,$l='log') {
$c = '# '; //primer char de línia
static $f;
if (!$f) {
$l = basename($l,'.xml');
$f = __DIR__ . "/log/$l" . date('__Y-m-d_H-i-s') . '.txt';
if (file_exists($f)) {
$b = $f . date('__Y-m-d_H-i-s',filemtime($f)) . '.txt';
rename($f,$b);
}
file_put_contents ($f,$c . date('Y-m-d H:i:s') . "\n" . print_r($GLOBALS['user'],true) . "\n");
}
$trace = debug_backtrace();
$filename = $trace[0]['file'];
$linenumber = $trace[0]['line'];
$lines = file($filename);
$line = trim($lines[$linenumber-1]);
$hora = date('H:i.s');
$x = print_r($x,true);
file_put_contents($f,"\n$c$hora\n$c$filename\n$c$linenumber\n$c$line\n$x\n",FILE_APPEND);
}
function sql($sql,$params=array()) {
global $db;
// pre($sql);
// pre($params);
$st = $db->prepare($sql);
$st->execute($params);
if (!$st) return false;
switch (strtolower(strtok($sql,' '))) {
case 'select':
case 'show': return $st->fetchAll(PDO::FETCH_ASSOC);
case 'insert': return $db->lastInsertId();
default: return $st->rowCount();
}
}
/*
*
journal - issue - publications - submissions - section - galley
select
j.path,
i.issue_id,i.published,i.access_status,
p.publication_id,p.access_status,p.status,p.url_path,p.version,
s.submission_id,s.status,s.stage_id,
ss.setting_value section,
g.galley_id,g.locale,g.label,g.seq
from journals j
join issues i on j.journal_id=i.journal_id
join publication_settings ps on i.issue_id=ps.setting_value and ps.setting_name='issueId'
join publications p on ps.publication_id=p.publication_id
join submissions s on p.submission_id=s.submission_id
join section_settings ss on p.section_id=ss.section_id and ss.setting_name='abbrev' and ss.setting_value>'' and p.locale=ss.locale
join publication_galleys g on p.publication_id=g.publication_id
where p.publication_id=1714
order by j.path,i.issue_id,p.seq;
select s.*, po.seq from submissions s
left join publications po on s.current_publication_id = po.publication_id
left join publications issue_p on issue_p.submission_id = s.submission_id
left join publication_settings issue_ps on issue_p.publication_id = issue_ps.publication_id
where s.context_id = 12 and s.status in (3) and (issue_ps.setting_name = 'issueId' and issue_ps.setting_value in ('2658'))
group by s.submission_id, po.seq order by po.seq asc;
select `s`.* from `submissions` as `s`
left join `publications` as `issue_p` on `issue_p`.`submission_id` = `s`.`submission_id`
left join `publication_settings` as `issue_ps` on `issue_p`.`publication_id` = `issue_ps`.`publication_id`
where `s`.`context_id` = '12' and `s`.`status` in (3) and `issue_ps`.`setting_name` = 'issueId' and `issue_ps`.`setting_value` in ('2658')
group by `s`.`submission_id` order by `s`.`date_submitted` desc;
* */