query($sql)) {
echo "Error: " . $db->error . PHP_EOL;
}
}
$seedCheck = $db->query("SELECT COUNT(*) c FROM doc_format_master")->fetch_assoc();
if ((int)($seedCheck['c'] ?? 0) === 0) {
$tpl = 'FITNESS CERTIFICATE
\n\nI, Dr {dr_name}, after carefully examining the case, hereby certify that {p_fname} ({p_code}) has been advised rest from {rest_from_date} to {rest_to_date}.\nHe/She may resume duty from {resume_date}.
\n\nDr. {dr_name}
{dr_sign}
';
$esc = $db->real_escape_string($tpl);
$db->query("INSERT INTO doc_format_master (doc_name,doc_desc,doc_raw_format,active,created_at,updated_at) VALUES ('FITNESS CERTIFICATE','FITNESS CERTIFICATE','$esc',1,NOW(),NOW())");
$dfId = (int) $db->insert_id;
$inputs = [
['Suffering Diseases Name','DISEASES','text',''],
['Since From','SINCE','date',date('d/m/Y')],
['Rest From Date','rest_from_date','date',date('d/m/Y')],
['Rest To Date','rest_to_date','date',date('d/m/Y')],
['Duty Start Date','resume_date','date',date('d/m/Y')],
];
$order = 1;
foreach ($inputs as $in) {
$n = $db->real_escape_string($in[0]);
$c = $db->real_escape_string($in[1]);
$t = $db->real_escape_string($in[2]);
$d = $db->real_escape_string($in[3]);
$db->query("INSERT INTO doc_format_sub (doc_format_id,input_name,input_code,input_type,input_default_value,short_order,active,created_at,updated_at) VALUES ($dfId,'$n','$c','$t','$d',$order,1,NOW(),NOW())");
$order++;
}
echo "Seeded default FITNESS CERTIFICATE template." . PHP_EOL;
}
echo "Doctor document tables ready." . PHP_EOL;