$filename = $cid . '_' . $did . '_' . $filename; $PREFIX = $year . '/' . $month . '/' . $dom; $fullfilename = INVOICE_DIR . '/' . $PREFIX . '/' . $filename; $DIR = INVOICE_DIR . '/' . $PREFIX; `mkdir -p {$DIR}`; `chmod 755 {$DIR}`; `chown 33:33 {$DIR}`; if ($tmp = $DB->GetOne('SELECT 1 FROM documentcontents WHERE docid = ? LIMIT 1;', array($docid))) { if (file_exists($fullfilename)) { @unlink($fullfilename); } invoice_create_pdf_file($docid, $fullfilename); `chmod 644 {$fullfilename}`; `chown 33:33 {$fullfilename}`; $md5 = md5_file($fullfilename); $DB->Execute('UPDATE documentcontents SET md5sum = ? WHERE docid = ? ;', array($md5, $docid)); } else { if ($doc['type'] == DOC_CNOTE) { $title = 'Faktura Korygująca'; } elseif ($doc['type'] == DOC_INVOICE_PRO) { $title = 'Faktura Proforma'; } else { $title = 'Faktura'; } invoice_create_pdf_file($docid, $fullfilename); `chmod 644 {$fullfilename}`; `chown 33:33 {$fullfilename}`; $md5 = md5_file($fullfilename); $DB->Execute('INSERT INTO documentcontents (docid, title, fromdate, todate, filename, contenttype, md5sum, description) VALUES (?, ?, ?, ?, ?, ?, ?, ?) ;', array($docid, $title, 0, 0, $filename, 'pdf', $md5, '')); } }
$filename .= '.pdf'; $cid = 'CID' . sprintf('%06.d', $doc[$i]['customerid']); $did = 'DID' . sprintf('%08.d', $doc[$i]['id']); $filename = $cid . '_' . $did . '_' . $filename; $fullfilename = INVOICE_DIR . '/' . $PREFIX . '/' . $filename; if ($tmp = $DB->GetOne('SELECT 1 FROM documentcontents WHERE docid = ? LIMIT 1;', array($doc[$i]['id']))) { if (file_exists($fullfilename) && !$replace) { if (!$quiet) { print "plik pdf (" . $fullfilename . ") dla podanej faktury już istnieje !!!\n"; } } else { invoice_create_pdf_file($doc[$i]['id'], $fullfilename); $md5 = md5_file($fullfilename); $DB->Execute('UPDATE documentcontents SET md5sum = ? WHERE docid = ? ;', array($md5, $doc[$i]['id'])); } } else { if ($doc[$i]['type'] == DOC_CNOTE) { $title = 'Faktura Korygująca'; } elseif ($doc[$i]['type'] == DOC_INVOICE_PRO) { $title = 'Faktura Proforma'; } else { $title = 'Faktura'; } invoice_create_pdf_file($doc[$i]['id'], $fullfilename); $md5 = md5_file($fullfilename); $DB->Execute('INSERT INTO documentcontents (docid, title, fromdate, todate, filename, contenttype, md5sum, description) VALUES (?, ?, ?, ?, ?, ?, ?, ?) ;', array($doc[$i]['id'], $title, 0, 0, $filename, 'pdf', $md5, '')); } `chmod 644 {$fullfilename}`; `chown 33:33 {$fullfilename}`; } }