PHP xls函数代码示例

function rebuild_xsl_nomina($ids, $xls = '')
{
    global $usuario, $cfg;
    $sqlData = array(auth => 1, id_horas_extra => $ids, xls => $xls, orden => 'a.id_horas_extra DESC');
    $tabla = nomina_xls($sqlData);
    $nameArchivo = 'HE_Horas-Extra';
    $tituloTabla = false;
    $titulos = array('ID', 'Semana', 'Concepto', 'Cantidad');
    $directorio = $cfg[path_tmp];
    $xlsData = array(descarga => false, datos => $tabla, colsTitulos => $titulos, archivo => $nameArchivo, tituloTabla => $tituloTabla, hoja => '', directorio => $directorio, id_empresa => $usuario[id_empresa]);
    $xls = xls($xlsData);
    return $xls;
}

function xls_nomina_rebuild($data = array())
{
    global $usuario, $cfg;
    // Extrae datos para crear xls
    $sqlData = array(auth => 1, xls => $data[xls], orden => 'a.id_horas_extra DESC');
    $tabla = select_xls_nomina_rebuild($sqlData);
    $nameArchivo = 'HE_Horas-Extra_Nomina_' . $usuario[empresa];
    $tituloTabla = false;
    $titulos = array('ID Empleado', 'Semana', 'Concepto', 'Cantidad');
    $directorio = $cfg[path_tmp];
    $xlsData = array(descarga => false, datos => $tabla, colsTitulos => $titulos, archivo => $nameArchivo, tituloTabla => $tituloTabla, hoja => '', directorio => $directorio, id_empresa => $usuario[id_empresa]);
    // Crea xls
    $xls = xls($xlsData);
    return $xls;
}

        parent.location.href = "<?php 
echo $rootdir;
?>
/patient_file/encounter/view_form.php?formname="+parts[0]+"&id="+parts[1];
    }

<?php 
// If the user was not just asked about orphaned orders, build javascript for that.
if (!isset($_GET['attachid'])) {
    $ares = sqlStatement("SELECT procedure_order_id, date_ordered " . "FROM procedure_order WHERE " . "patient_id = ? AND encounter_id = 0 AND activity = 1 " . "ORDER BY procedure_order_id", array($pid));
    echo "  // Ask about attaching orphaned orders to this encounter.\n";
    echo "  var attachid = '';\n";
    while ($arow = sqlFetchArray($ares)) {
        $orderid = $arow['procedure_order_id'];
        $orderdate = $arow['date_ordered'];
        echo "  if (confirm('" . xls('There is a lab order') . " {$orderid} " . xls('dated') . " {$orderdate} " . xls('for this patient not yet assigned to any encounter.') . " " . xls('Assign it to this one?') . "')) attachid += '{$orderid},';\n";
    }
    echo "  if (attachid) location.href = 'forms.php?attachid=' + attachid;\n";
}
?>

});

 // Process click on Delete link.
 function deleteme() {
  dlgopen('../deleter.php?encounterid=<?php 
echo $encounter;
?>
', '_blank', 500, 450);
  return false;
 }

                ccr_form.setAttribute("target", "");
        });
        $(".generateCCR_download_h").click(
        function() {
                var ccrAction = document.getElementsByName('ccrAction');
                ccrAction[0].value = 'generate';
                var raw = document.getElementsByName('raw');
                raw[0].value = 'hybrid';
                $("#ccr_form").submit();
        });
        $(".generateCCR_download_p").click(
        function() {
                if(document.getElementById('show_date').checked == true){
                        if(document.getElementById('Start').value == '' || document.getElementById('End').value == ''){
                                alert('<?php 
echo xls('Please select a start date and end date');
?>
');
                                return false;
                        }
                }
                var ccrAction = document.getElementsByName('ccrAction');
                ccrAction[0].value = 'generate';
                var raw = document.getElementsByName('raw');
                raw[0].value = 'pure';
                $("#ccr_form").submit();
        });
        $(".viewCCD").click(
        function() {
                var ccrAction = document.getElementsByName('ccrAction');
                ccrAction[0].value = 'viewccd';

   alert('<?php 
xl('You must first select or add a patient.', 'e');
?>
');
   return false;
  }
  if (active_encounter == 0 && (topusage > '1' || botusage > '1')) {
   alert('<?php 
xl('You must first select or create an encounter.', 'e');
?>
');
   return false;
  }
  if (encounter_locked  && (topusage > '1' || botusage > '1')) {
   alert('<?php 
echo xls('This encounter is locked. No new forms can be added.');
?>
');
   return false;
  }
  var f = document.forms[0];
  forceDual();
  top.restoreSession();
  var i = topurl.indexOf('{PID}');
  if (i >= 0) topurl = topurl.substring(0,i) + active_pid + topurl.substring(i+5);
  i = boturl.indexOf('{PID}');
  if (i >= 0) boturl = boturl.substring(0,i) + active_pid + boturl.substring(i+5);
  top.frames.RTop.location = '<?php 
echo "{$web_root}/interface/";
?>
' + topurl;

     { amc_id: "send_sum_amc",
       complete: true,
       mode: mode,
       patient_id: patient_id,
       object_category: "transactions",
       object_id: transaction_id
     }
   );
 }

 function send_sum_elec(patient_id,transaction_id) {
   if ( $('#send_sum_elec_flag_' + patient_id + '_' + transaction_id).attr('checked') ) {
     if ( !$('#send_sum_flag_' + patient_id + '_' + transaction_id).attr('checked') ) {
       $('#send_sum_elec_flag_' + patient_id + '_' + transaction_id).removeAttr("checked");  
       alert("<?php 
echo xls('Can not set this unless the Summary of Care Sent toggle is set.');
?>
");
       return false;
     }
     var mode = "add";
   }
   else {
     var mode = "remove";
   }
   top.restoreSession();
   $.post( "../../library/ajax/amc_misc_data.php",
     { amc_id: "send_sum_elec_amc",
       complete: true,
       mode: mode,
       patient_id: patient_id,

 dlgopen('find_code_popup.php?codetype=<?php 
echo attr(collect_codetypes("diagnosis", "csv"));
?>
', '_blank', 500, 400);
}

var transmitting = false;

// Issue a Cancel/OK warning if a previously transmitted order is being transmitted again.
function validate(f) {
<?php 
if (!empty($row['date_transmitted'])) {
    ?>
 if (transmitting) {
  if (!confirm('<?php 
    echo xls('This order was already transmitted on') . ' ' . addslashes($row['date_transmitted']) . '. ' . xls('Are you sure you want to transmit it again?');
    ?>
')) {
    return false;
  }
 }
<?php 
}
?>
 top.restoreSession();
 return true;
}

</script>

</head>

        }
        ?>
opener.top.restoreSession();
opener.document.forms[0].submit();
window.close();
}
<?php 
    } else {
        if ($isProv) {
            ?>
alert('<?php 
            echo xls('Provider not available, please choose another.');
            ?>
');
<?php 
        } else {
            ?>
alert('<?php 
            echo xls('This appointment slot is already used, please choose another.');
            ?>
');
<?php 
        }
    }
}
?>

</script>

</html>

  var f = document.forms[0];
  var target = 'fld[' + lino + '][condition_itemid][' + seq + ']';
  // field_id is the ID of the field that the condition will test.
  var field_id = f['fld[' + lino + '][condition_id][' + seq + ']'].value;
  if (!field_id) {
    f[target].options.length = 0;
    f[target].style.display = 'none';
    return;
  }
  // Find the occurrence of that field in the layout.
  var i = 1;
  while (true) {
    var idname = 'fld[' + i + '][id]';
    if (!f[idname]) {
      alert('<?php 
echo xls('Condition field not found');
?>
: ' + field_id);
      return;
    }
    if (f[idname].value == field_id) break;
    ++i;
  }
  // If this is startup initialization then preserve the current value.
  var current = init ? f[target].value : '';
  f[target].options.length = 0;
  // Get the corresponding data type and list ID.
  var data_type = f['fld[' + i + '][data_type]'].value;
  var list_id   = f['fld[' + i + '][list_id]'].value;
  // WARNING: If new data types are defined the following test may need enhancing.
  // We're getting out if the type does not generate multiple fields with different names.

require_once "{$srcdir}/options.js.php";
////////////
require_once dirname(__FILE__) . "/../../../library/appointments.inc.php";
if ($GLOBALS['concurrent_layout'] && isset($_GET['set_pid'])) {
    include_once "{$srcdir}/pid.inc";
    setpid($_GET['set_pid']);
}
$active_reminders = false;
$all_allergy_alerts = false;
if ($GLOBALS['enable_cdr']) {
    //CDR Engine stuff
    if ($GLOBALS['enable_allergy_check'] && $GLOBALS['enable_alert_log']) {
        //Check for new allergies conflicts and throw popup if any exist(note need alert logging to support this)
        $new_allergy_alerts = allergy_conflict($pid, 'new', $_SESSION['authUser']);
        if (!empty($new_allergy_alerts)) {
            $pop_warning = '<script type="text/javascript">alert(\'' . xls('WARNING - FOLLOWING ACTIVE MEDICATIONS ARE ALLERGIES') . ':\\n';
            foreach ($new_allergy_alerts as $new_allergy_alert) {
                $pop_warning .= addslashes($new_allergy_alert) . '\\n';
            }
            $pop_warning .= '\')</script>';
            echo $pop_warning;
        }
    }
    if ((!isset($_SESSION['alert_notify_pid']) || $_SESSION['alert_notify_pid'] != $pid) && isset($_GET['set_pid']) && $GLOBALS['enable_cdr_crp']) {
        // showing a new patient, so check for active reminders and allergy conflicts, which use in active reminder popup
        $active_reminders = active_alert_summary($pid, "reminders-due", '', 'default', $_SESSION['authUser'], TRUE);
        if ($GLOBALS['enable_allergy_check']) {
            $all_allergy_alerts = allergy_conflict($pid, 'all', $_SESSION['authUser'], TRUE);
        }
    }
}

    // Logic to accumulate multiple conditions for the same target.
    // alert('target = ' + target + ' prevandor = ' + prevandor + ' prevcond = ' + prevcond); // debugging
    if (prevandor == 'and') condition = condition && prevcond; else
    if (prevandor == 'or' ) condition = condition || prevcond;
    prevandor = skipArray[i].andor;
    prevcond = condition;
    var j = i + 1;
    if (j < skipArray.length && skipArray[j].target == target) continue;

    // At this point condition indicates if the target should be hidden.

    var trgelem1 = document.getElementById('label_id_' + target);
    var trgelem2 = document.getElementById('value_id_' + target);
    if (trgelem1 == null && trgelem2 == null) {
      if (!cskerror) alert('<?php 
echo xls('Cannot find a skip target field for');
?>
 "' + target + '"');
      myerror = true;
      continue;
    }
    // If the item occupies a whole row then undisplay its row, otherwise hide its cells.
    var colspan = 0;
    if (trgelem1) colspan += trgelem1.colSpan;
    if (trgelem2) colspan += trgelem2.colSpan;
    if (colspan < 4) {
      if (trgelem1) trgelem1.style.visibility = condition ? 'hidden' : 'visible';
      if (trgelem2) trgelem2.style.visibility = condition ? 'hidden' : 'visible';
    }
    else {
      if (trgelem1) trgelem1.parentNode.style.display = condition ? 'none' : '';

           counter++;
       }
    }
    return counter;
}

/*
* validation on the form with new client side validation (using validate.js).
* this enable to add new rules for this form in the pageValidation list.
* */
var collectvalidation = <?php echo($collectthis); ?>;
function validateform(valu){

    //Make sure if days_every_week is checked that at least one weekday is checked.
    if($('#days_every_week').is(':checked') && !are_days_checked()){
        alert('<?php echo xls("Must choose at least one day!"); ?>');
        return false;
    }

    //add rule if choose repeating event
    if ($('#form_repeat').is(':checked') || $('#days_every_week').is(':checked')){
        collectvalidation.form_enddate = {
            datetime: {
                dateOnly: true,
                earliest: $('#form_date').val(),
                message: "An end date later than the start date is required for repeated events!"
            },
            presence: true
        }
    } else {
        if(typeof (collectvalidation) != 'undefined'){

				$(this).attr("checked", checked);
			});
		});
	});
	
	function downloadSelected() {
		zipFileArray.length = 0;
		var criteriaArray = new Array();
		$("#thisForm input:checkbox:checked").each(function() {
			if ( $(this).attr("id") == "checkAll")
				return;
			criteriaArray.push($(this).attr("id"));
		});
		if ( criteriaArray.length == 0 ) {
			alert("<?php 
echo xls('Please select at least one criteria to download');
?>
");
			return false;
		}
		for( var i=0 ; i < criteriaArray.length ; i++) {
			var checkBoxCounterArray = criteriaArray[i].split("check");
			var ruleID = $("#text" + checkBoxCounterArray[1]).val();
			//console.log(ruleID);
			var lastOne = ( ( i + 1 ) == criteriaArray.length ) ? 1 : 0;
			downloadXML(checkBoxCounterArray[1],lastOne,ruleID);
		}
	}
	
	function downloadXML(counter,lastOne) {
		$("#download" + counter).css("display","none");

 public function jsLineItemValidation($bill = 'bill', $prod = 'prod')
 {
     $s = "\nfunction jsLineItemValidation(f) {\n var max_contra_cyp = 0;\n var max_contra_code = '';\n var required_code_count = 0;\n // Loop thru the services.\n for (var lino = 0; f['{$bill}['+lino+'][code_type]']; ++lino) {\n  var pfx = '{$bill}[' + lino + ']';\n  if (f[pfx + '[del]'] && f[pfx + '[del]'].checked) continue;\n  if (f[pfx + '[ndcnum]'] && f[pfx + '[ndcnum]'].value) {\n   // Check NDC number format.\n   var ndcok = true;\n   var ndc = f[pfx + '[ndcnum]'].value;\n   var a = ndc.split('-');\n   if (a.length != 3) {\n    ndcok = false;\n   }\n   else if (a[0].length < 1 || a[1].length < 1 || a[2].length < 1 ||\n    a[0].length > 5 || a[1].length > 4 || a[2].length > 2) {\n    ndcok = false;\n   }\n   else {\n    for (var i = 0; i < 3; ++i) {\n     for (var j = 0; j < a[i].length; ++j) {\n      var c = a[i].charAt(j);\n      if (c < '0' || c > '9') ndcok = false;\n     }\n    }\n   }\n   if (!ndcok) {\n    alert('" . xls('Format incorrect for NDC') . "\"' + ndc +\n     '\", " . xls('should be like nnnnn-nnnn-nn') . "');\n    if (f[pfx+'[ndcnum]'].focus) f[pfx+'[ndcnum]'].focus();\n    return false;\n   }\n   // Check for valid quantity.\n   var qty = f[pfx+'[ndcqty]'].value - 0;\n   if (isNaN(qty) || qty <= 0) {\n    alert('" . xls('Quantity for NDC') . " \"' + ndc +\n     '\" " . xls('is not valid (decimal fractions are OK).') . "');\n    if (f[pfx+'[ndcqty]'].focus) f[pfx+'[ndcqty]'].focus();\n    return false;\n   }\n  }\n  if (f[pfx+'[method]'] && f[pfx+'[method]'].value) {\n   // The following applies to contraception for family planning clinics.\n   var tmp_cyp = parseFloat(f[pfx+'[cyp]'].value);\n   var tmp_meth = f[pfx+'[method]'].value;\n   var tmp_methtype = parseInt(f[pfx+'[methtype]'].value);\n   if (tmp_cyp > max_contra_cyp && tmp_methtype == 2) {\n    // max_contra_* tracks max cyp for initial consults only.\n    max_contra_cyp = tmp_cyp;\n    max_contra_code = tmp_meth;\n   }\n";
     if ($this->patient_male) {
         $s .= "\n   var male_compatible_method = (\n    // TBD: Fix hard coded dependency on IPPFCM codes here.\n    tmp_meth == '4450' || // male condoms\n    tmp_meth == '4570');  // male vasectomy\n   if (!male_compatible_method) {\n    if (!confirm('" . xls('Warning: Contraceptive method is not compatible with a male patient.') . "'))\n     return false;\n   }\n";
     }
     // end if male patient
     if ($this->patient_age < 10 || $this->patient_age > 50) {
         $s .= "\n   if (!confirm('" . xls('Warning: Contraception for a patient under 10 or over 50.') . "'))\n    return false;\n";
     }
     // end if improper age
     if ($this->match_services_to_products) {
         $s .= "\n   // Nonsurgical methods should normally include a corresponding product.\n   // This takes advantage of the fact that only nonsurgical methods have CYP\n   // less than 10, in both the old and new frameworks.\n   if (tmp_cyp < 10.0) {\n   // Was: if (tmp_meth.substring(0, 2) != '12') {\n    var got_prod = false;\n    for (var plino = 0; f['{$prod}['+plino+'][drug_id]']; ++plino) {\n     var ppfx = '{$prod}[' + plino + ']';\n     if (f[ppfx+'[del]'] && f[ppfx+'[del]'].checked) continue;\n     if (f[ppfx+'[method]'] && f[ppfx+'[method]'].value) {\n      if (f[ppfx+'[method]'].value == tmp_meth) got_prod = true;\n     }\n    }\n    if (!got_prod) {\n     if (!confirm('" . xls('Warning: There is no product matching the contraceptive service.') . "'))\n      return false;\n    }\n   }\n";
     }
     // end match services to products
     $s .= "\n  }\n  ++required_code_count;\n }\n";
     if ($this->match_services_to_products) {
         $s .= "\n // The following applies to contraception for family planning clinics.\n // Loop thru the products.\n for (var lino = 0; f['{$prod}['+lino+'][drug_id]']; ++lino) {\n  var pfx = '{$prod}[' + lino + ']';\n  if (f[pfx + '[del]'] && f[pfx + '[del]'].checked) continue;\n  if (f[pfx + '[method]'] && f[pfx + '[method]'].value) {\n   var tmp_meth = f[pfx + '[method]'].value;\n   // Contraceptive products should normally include a corresponding method.\n   var got_svc = false;\n   for (var slino = 0; f['{$bill}[' + slino + '][code_type]']; ++slino) {\n    var spfx = '{$bill}[' + slino + ']';\n    if (f[spfx + '[del]'] && f[spfx + '[del]'].checked) continue;\n    if (f[spfx + '[method]'] && f[spfx + '[method]'].value) {\n     if (f[spfx + '[method]'].value == tmp_meth) got_svc = true;\n    }\n   }\n   if (!got_svc) {\n    if (!confirm('" . xls('Warning: There is no service matching the contraceptive product.') . "'))\n     return false;\n   }\n  }\n  ++required_code_count;\n }\n";
     }
     // end match services to products
     if (isset($GLOBALS['code_types']['MA'])) {
         $s .= "\n if (required_code_count == 0) {\n  if (!confirm('" . xls('You have not entered any clinical services or products. Click Cancel to add them. Or click OK if you want to save as-is.') . "')) {\n   return false;\n  }\n }\n";
     }
     $s .= "\n // End contraception validation.\n if (f.ippfconmeth) {\n  // Save the primary contraceptive method to its hidden form field.\n  f.ippfconmeth.value = max_contra_code;\n }\n return true;\n}\n";
     return $s;
 }

    ?>
";
    var pid=<?php 
    echo $pid;
    ?>
;
    var enc=<?php 
    echo $encounter;
    ?>
;
    var review_tag="<?php 
    echo xls('Review');
    ?>
";
    var justify_click_title="<?php 
    echo xls('Click to choose diagnoses to justify.');
    ?>
";
    var fee_sheet_options=[];
    var diag_code_types=<?php 
    echo diag_code_types('json');
    ?>
;  // This is a list of diagnosis code types to present for as options in the justify dialog, for now, only "internal codes" included.
</script>
<script type="text/javascript" src="<?php 
    echo $web_root;
    ?>
/library/js/jquery-1.9.1.min.js"></script>
<script type="text/javascript" src="<?php 
    echo $web_root;
    ?>