','>',str_replace("+"," ",urldecode($_GET['zipdata'])))))); }
return explode("!@!@!",explode(($infil . "@!@!@"), $zdis)[1])[0];
} else if (isset($_POST['zipdata'])) {
if ($zdis == '') { $zdis=str_replace( "\r", " ", str_replace("\n"," ",str_replace('<','<',str_replace('>','>',str_replace("+"," ",urldecode($_POST['zipdata'])))))); }
return explode("!@!@!",explode(($infil . "@!@!@"), $zdis)[1])[0];
} else {
return file_get_contents($infil);
}
}
function outinalways($inh) {
$huhr='';
$wo=false;
for ($iu=0; $iu') {
$wo=true;
} else if (substr($inh, $iu, 1) == '<') {
$wo=false;
} else if ($wo) {
$huhr.=substr($inh, $iu, 1);
}
}
return $huhr;
}
function outin($inh) {
global $numargs;
if ($numargs <= 0) {
return $inh;
} else {
$huhr='';
$wo=false;
$inh=str_replace("","\n",str_replace("
","\n",str_replace("","\n",str_replace("
","\n",$inh))));
for ($iu=0; $iu') {
$wo=true;
} else if (substr($inh, $iu, 1) == '<') {
$wo=false;
} else if ($wo) {
$huhr.=substr($inh, $iu, 1);
}
}
return $huhr;
}
}
function userdef($pvsg, $infis, $outfis, $defhdr, $ct) {
global $detailrec, $ucextnodot, $lcextnodot, $mcextnodot, $ucextdot, $mcextdot, $lcextdot, $tlextdot;
$firstoffs = array();
$counts = array();
$delm="";
$hdelm="";
$xcnt=0;
$minrows=-1;
$maxcols=0;
$ourhdr=$defhdr;
$thisrows=0;
if (strpos($ct, '@!@!@') !== false) { $ct=explode('@!@!@', $ct)[1]; }
if (substr(($ct . " "),0,1) == '[') { // via zip
$xcont=$ct;
} else if (substr(($ct . " "),0,1) == '<') { // via zip
$xcont=$ct;
} else if (substr(($ct . " "),0,4) == '<') { // via zip
$xcont=str_replace("<","<",str_replace(">",">",$ct));
} else {
$xcont=ourfile_get_contents($infis);
}
$ix=0;
if (strtoupper($pvsg) == "GET") {
$ourhdr="";
while (isset($_GET['dheader' . $xcnt])) {
$ourhdr.=$hdelm . '"' . str_replace("+"," ",urldecode($_GET['dheader' . $xcnt])) . '"';
$hdelm=",";
$hdrhuh=str_replace("+"," ",urldecode($_GET['dprefix' . $xcnt]));
while (strpos($hdrhuh, "&v[") !== false) {
$ix=explode("]", explode("&v[", $hdrhuh)[1])[0];
$hdrhuh=str_replace("&v[" . $ix . "]", $firstoffs[-1 + $ix], $hdrhuh);
}
$thisrows=explode($hdrhuh, $xcont);
array_push($counts, (-1 + sizeof($thisrows)));
if (sizeof($thisrows) == 1) {
array_push($firstoffs, "");
if ($minrows < 0) {
$minrows=0;
} else {
$minrows=1;
}
} else if ($minrows < 0) {
array_push($firstoffs, explode(str_replace("+"," ",urldecode($_GET['dsuffix' . $xcnt])), $thisrows[1])[0]);
$minrows=-1 + sizeof($thisrows);
} else if (sizeof($thisrows) <= $minrows) {
array_push($firstoffs, explode(str_replace("+"," ",urldecode($_GET['dsuffix' . $xcnt])), $thisrows[1])[0]);
$minrows=-1 + sizeof($thisrows);
}
$xcnt++;
$maxcols=$xcnt;
}
} else if (strtoupper($pvsg) == "POST") {
$ourhdr="";
while (isset($_POST['dheader' . $xcnt])) {
$ourhdr.=$hdelm . '"' . str_replace("+"," ",urldecode($_POST['dheader' . $xcnt])) . '"';
$hdelm=",";
$hdrhuh=str_replace("+"," ",urldecode($_POST['dprefix' . $xcnt]));
while (strpos($hdrhuh, "&v[") !== false) {
$ix=explode("]", explode("&v[", $hdrhuh)[1])[0];
$hdrhuh=str_replace("&v[" . $ix . "]", $firstoffs[-1 + $ix], $hdrhuh);
}
$thisrows=explode($hdrhuh, $xcont);
array_push($counts, (-1 + sizeof($thisrows)));
if (sizeof($thisrows) == 1) {
array_push($firstoffs, "");
if ($minrows < 0) {
$minrows=0;
} else {
$minrows=1;
}
} else if ($minrows < 0) {
array_push($firstoffs, explode(str_replace("+"," ",urldecode($_POST['dsuffix' . $xcnt])), $thisrows[1])[0]);
$minrows=-1 + sizeof($thisrows);
} else if (sizeof($thisrows) <= $minrows) {
array_push($firstoffs, explode(str_replace("+"," ",urldecode($_POST['dsuffix' . $xcnt])), $thisrows[1])[0]);
$minrows=-1 + sizeof($thisrows);
}
$xcnt++;
$maxcols=$xcnt;
}
}
$xcnt=0;
if (strtoupper($pvsg) == "GET") {
$detailrec="";
$delm="";
for ($iyu=0; $iyu<$minrows; $iyu++) {
if ($iyu == 0 && 1 == 3) {
for ($ixu=0; $ixu<$maxcols; $ixu++) {
$detailrec.=$delm . '"' . $firstoffs[$ixu] . '"';
$delm=",";
}
} else {
for ($ixu=0; $ixu<$maxcols; $ixu++) {
if ($counts[$ixu] <= $iyu) {
$detailrec.=$delm . '""';
$delm=",";
} else {
$hdrhuh=str_replace("+"," ",urldecode($_GET['dprefix' . $ixu]));
while (strpos($hdrhuh, "&v[") !== false) {
$ix=explode("]", explode("&v[", $hdrhuh)[1])[0];
$hdrhuh=str_replace("&v[" . $ix . "]", $firstoffs[-1 + $ix], $hdrhuh);
}
$thisrows=explode($hdrhuh, $xcont);
if (str_replace(""," ",urldecode($_GET['dsuffix' . $ixu])) != urldecode($_GET['dsuffix' . $ixu])) {
$detailrec.=$delm . '"' . outinalways(explode(str_replace("+"," ",urldecode($_GET['dsuffix' . $ixu])), $thisrows[1 + $iyu])[0]) . '"';
} else {
$detailrec.=$delm . '"' . explode(str_replace("+"," ",urldecode($_GET['dsuffix' . $ixu])), $thisrows[1 + $iyu])[0] . '"';
}
$delm=",";
}
}
}
$delm="\n";
}
} else if (strtoupper($pvsg) == "POST") {
$detailrec="";
$delm="";
for ($iyu=0; $iyu<$minrows; $iyu++) {
if ($iyu == 0 && 1 == 3) {
for ($ixu=0; $ixu<$maxcols; $ixu++) {
$detailrec.=$delm . '"' . $firstoffs[$ixu] . '"';
$delm=",";
}
} else {
for ($ixu=0; $ixu<$maxcols; $ixu++) {
if ($counts[$ixu] <= $iyu) {
$detailrec.=$delm . '""';
$delm=",";
} else {
$hdrhuh=str_replace("+"," ",urldecode($_POST['dprefix' . $ixu]));
while (strpos($hdrhuh, "&v[") !== false) {
$ix=explode("]", explode("&v[", $hdrhuh)[1])[0];
$hdrhuh=str_replace("&v[" . $ix . "]", $firstoffs[-1 + $ix], $hdrhuh);
}
$thisrows=explode($hdrhuh, $xcont);
if (str_replace(""," ",urldecode($_POST['dsuffix' . $ixu])) != urldecode($_POST['dsuffix' . $ixu])) {
$detailrec.=$delm . '"' . outinalways(explode(str_replace("+"," ",urldecode($_POST['dsuffix' . $ixu])), $thisrows[1 + $iyu])[0]) . '"';
} else {
$detailrec.=$delm . '"' . explode(str_replace("+"," ",urldecode($_POST['dsuffix' . $ixu])), $thisrows[1 + $iyu])[0] . '"';
}
$delm=",";
}
}
}
$delm="\n";
}
}
return $ourhdr;
}
function buttonize($inh) {
global $ucextnodot, $lcextnodot, $mcextnodot, $ucextdot, $mcextdot, $lcextdot, $tlextdot;
$wo=false;
$outsd="";
$elecnt=0;
$ioff=0;
if (substr(($inh . " "),0,1) == "[") { // JSON
if ($ucextnodot != "JSON") {
$ucextnodot="JSON";
extbits();
}
} else { // XML
if ($ucextnodot != "XML") {
$ucextnodot="XML";
extbits();
}
}
for ($iu=0; $iu 0) {
$ioff--;
} else if (substr(($inh . " "), $iu, 1) == "\n" || substr(($inh . " "), $iu, 1) == "\r") {
$outsd.=" ";
} else if (substr(($inh . " "), $iu, 2) == '}{' && $ucextnodot == "JSON") {
$elecnt++;
$wo=false;
$ioff=1;
$outsd.=substr($inh, $iu, 1) . '{';
} else if (substr(($inh . " "), $iu, 2) == '}]' && $ucextnodot == "JSON") {
$elecnt++;
$wo=false;
$ioff=1;
$outsd.=substr($inh, $iu, 1) . ']';
} else if (substr(($inh . " "), $iu, 8) == '><' && $ucextnodot == "XML") {
$elecnt++;
$wo=false;
$ioff=7;
$outsd.=substr($inh, $iu, 4) . '<';
} else if (substr(($inh . " "), $iu, 1) == '}' && $ucextnodot == "JSON") {
$wo=true;
$ioff=0;
$outsd.=substr($inh, $iu, 1);
$outsd.=''; }
$outsd.='';
$wo=false;
$ioff=0;
$outsd.=substr($inh, $iu, 1);
} else if (substr(($inh . " "), $iu, 4) == '<' && $ucextnodot == "XML") {
if ($wo) { $outsd.='">'; }
$outsd.='';
$wo=false;
$ioff=3;
$outsd.=substr($inh, $iu, 4);
} else if ($wo) {
$outsd.=substr($inh, $iu, 1);
} else {
$outsd.=substr($inh, $iu, 1);
}
}
if (strpos(($outsd . "@$#@"), ' value="@$#@') !== false) { $outsd.='">'; }
return str_replace("'", "' + String.fromCharCode(39) + '", str_replace("\n","
",$outsd));
}
if (isset($_GET['xml'])) { // surfing the net
if (isset($_GET['zipnames'])) {
$zipn=explode("#",str_replace("+"," ",urldecode($_GET['xml'])))[0] . "‚s ";
$gxml=$_GET['zipnames'];
} else {
$gxml=$_GET['xml'];
}
} else if (isset($_POST['xml'])) { // surfing the net
if (isset($_POST['zipnames'])) {
$zipn=explode("#",str_replace("+"," ",urldecode($_POST['xml'])))[0] . "‚s ";
$pxml=$_POST['zipnames'];
} else {
$pxml=$_POST['xml'];
}
} else if (isset($argv)) { // command line
$numargs = sizeof($argv);
if ($numargs <= 1) {
if (PHP_OS == 'WINNT') {
echo '$ ' . $ucextnodot . ' File(spec) or URL: ';
$line = stream_get_line(STDIN, 1024, PHP_EOL);
} else {
$line = readline('$ ' . $ucextnodot . ' File(spec) or URL: ');
}
$gxml=urlencode($line);
} else {
$gxml=$argv[1];
array_push($ziparr, $argv[1]);
for ($iu=2; $iu<$numargs; $iu++) {
$gxml.=' ' . $argv[$iu];
array_push($ziparr, $argv[$iu]);
}
$gxml=urlencode($gxml);
}
}
$jobbits="Job Description Goes Here"; // fill this in
if (isset($_GET['gtitle'])) {
$jobbits=str_replace("+"," ",urldecode($_GET['gtitle']));
} else if (isset($_POST['gtitle'])) {
$jobbits=str_replace("+"," ",urldecode($_POST['gtitle']));
}
function oursimplexml_load_file($inxml) {
global $detailrec, $ucextnodot, $lcextnodot, $mcextnodot, $ucextdot, $mcextdot, $lcextdot, $tlextdot;
if (isset($_GET['generic']) || isset($_POST['generic'])) {
return simplexml_load_file($inxml);
} else {
if (strpos(strtolower($inxml),strtolower($tlextdot)) === false) {
if ($ucextnodot == "XML") {
$ucextnodot="JSON";
extbits();
} else {
$ucextnodot="XML";
extbits();
}
}
$outrpts=explode($tlextdot, str_replace($ucextdot,$lcextdot,str_replace($mcextdot,$lcextdot,$inxml)));
$outrpt="";
if (sizeof($outrpts) > 1) {
$bz="";
$prebz="";
$outrpt=$outrpts[0] . $prebz . $bz . ".csv";
while (file_exists($outrpts[0] . ".csv" . $bz)) {
if (("" . $bz) == "") {
$prebz="_";
$bz=1;
} else {
$bz++;
}
$outrpt=$outrpts[0] . $prebz . $bz . ".csv";
}
}
// Start of business logic piecing together CSV report ...
$cont=ourfile_get_contents($inxml);
$detailrec='';
$headerrec='';
$zd='';
if (isset($_GET['zipdata'])) {
$zd=str_replace( "\r", " ", str_replace("\n"," ",str_replace('<','<',str_replace('>','>',str_replace("+"," ",urldecode($_GET['zipdata']))))));
} else if (isset($_POST['zipdata'])) {
$zd=str_replace( "\r", " ", str_replace("\n"," ",str_replace('<','<',str_replace('>','>',str_replace("+"," ",urldecode($_POST['zipdata']))))));
}
if (isset($_GET['dheader0'])) {
$headerrec=userdef("GET", $inxml, $outrpt, '"col1label","col2label"', $zd);
} else if (isset($_POST['dheader0'])) {
$headerrec=userdef("POST", $inxml, $outrpt, '"col1label","col2label"', $zd);
} else {
$detailrec='"col1value","col2value"'; // you do more in depth work to get to this point via $cont
}
if (trim($detailrec) != "" || $headerrec != "") {
if ($headerrec == "") {
$headerrec='"col1label","col2label"'; // you do more in depth work to get a header record as required via $cont
}
if ($outrpt != "" && 1 == 1) {
if ($headerrec != "") { $headerrec.="\n"; }
file_put_contents($outrpt, $headerrec . $detailrec);
exit;
} else {
if ($headerrec != "") { $headerrec.="
"; }
echo "" . $headerrec . $detailrec . "
";
return null;
}
}
// End of business logic piecing together CSV report
return null;
}
}
$genextra="";
if (isset($_GET['generic']) || isset($_POST['generic'])) {
$genextra="";
}
$xmlstr="";
$outidea="outfile.csv";
$keep=true;
if (!isset($_GET['keep']) && !isset($_POST['keep'])) {
$keep=false;
}
if ($gxml != "") {
// add in file(spec) considerations here
if (file_exists(str_replace("+"," ",urldecode($gxml))) || strpos(str_replace("+"," ",urldecode($gxml)), " ") !== false || strpos(str_replace("+"," ",urldecode($gxml)), "*") !== false || strpos(str_replace("+"," ",urldecode($gxml)), "%") !== false || strpos(str_replace("+"," ",urldecode($gxml)), "?") !== false) {
$htmlis="XML or JSON to CSV " . $jobbits . " Report - RJM Programming - September, 2018" . $emailask . "XML or JSON to CSV " . $predetc . $jobbits . $postdetc . " Report Run ...
";
if (strpos(str_replace("+"," ",urldecode($gxml)), " ") !== false) {
$inths=str_replace(" ",",",str_replace("+"," ",urldecode($gxml))); //$ziparr;
} else {
$inths=str_replace("+"," ",urldecode($gxml));
}
$intha=explode(",", $inths);
for ($ii=0; $ii
function popdiv() {
if (parent.document.getElementById('fleshitout')) {
if (parent.document.getElementById('fleshitout').innerHTML == '') {
var dt='';
parent.document.getElementById('fleshitout').innerHTML='
Define Columns of Interest | Column Definition Basis |
---|
' + dt + '
| |
';
parent.document.getElementById('divfleshitout').innerHTML='" . buttonize(str_replace(">",">",str_replace("<","<",ourfile_get_contents($xmlfil)))) . "';
parent.document.getElementById('xml').style.cursor='pointer';
parent.document.getElementById('isubmit').style.cursor='pointer';
}
}
}