/**
* 添加回复
*/
public static final function append()
{
$online = front::online();
if (!$online->user_id) {
die('Permission Denied!');
}
//需要登录
$time = time();
while (isset($_SERVER['REQUEST_METHOD']) && $_SERVER['REQUEST_METHOD'] === 'POST') {
$post = array('doc_id' => isset($_POST['doc_id']) ? $_POST['doc_id'] : '', 'email' => isset($_POST['email']) ? $_POST['email'] : '', 'content' => isset($_POST['content']) ? $_POST['content'] : '', 'ip' => get_onlineip(), 'create_date' => date('Y-m-d', $time), 'create_time' => date('H:i:s', $time));
//$post['content'] = htmlentities($content , ENT_COMPAT ,'utf-8') ;
//pecho($post);
if (!empty($error)) {
break;
}
$doc_remark = new self();
$doc_remark->doc_remark_id = null;
$doc_remark->struct($post);
$doc_remark->insert('', 'doc_remark_id');
if ($doc_remark->doc_remark_id) {
$doc = new doc();
$doc->doc_id = $doc_remark->doc_id;
$doc->last_remark = date('Y-m-d H:i:s', $time);
$doc->update();
}
//print_r ( $doc_remark);
header('Location: ?' . $_GET['query']);
return;
}
}
appmod_use('aka/siswa', 'aka/kelas', 'aka/pelajaran', 'aka/rapor');
$opt = gpost('opt');
$cid = gpost('cid', 0);
/* Load App libraries */
require_once DBFILE;
require_once LIBDIR . 'common.php';
require_once MODDIR . 'date.php';
$dept = gpost('departemen');
$departemen = departemen_r($dept);
$proses = proses_r($pros, $dept);
// cell($a,$w=0,$c=1,$r=1,$al='',$b=-1,$bg='',$s='',$atr='')
$pros = gpost('proses');
$query = mysql_query("SELECT aka_mutasi.tanggal,aka_mutasi.departemen, aka_mutasi.keterangan, aka_siswa.nisn,aka_siswa.nama, aka_jenismutasi.nama as njenis \n\t\t\t\t\t\t\tFROM aka_mutasi\n\t\t\t\t\t\t\tJOIN aka_siswa ON aka_siswa.replid=aka_mutasi.replid\n JOIN aka_jenismutasi ON aka_jenismutasi.replid=aka_mutasi.replid\n WHERE aka_mutasi.departemen='{$dept}'");
$token = doc_decrypt($token);
$doc = new doc();
$doc->dochead("Laporan Mutasi Siswa " . gets('kelompok'), 7);
$doc->nl();
$doc->row_blank(7);
//$t=dbQSql($token);
$no = 1;
$doc->head('No{C}', '@Tanggal', '@NISN', '@Angkatan', '@Nama', '@Jenis Mutasi', '@Keterangan');
while ($r = mysql_fetch_array($query)) {
$doc->nl();
$doc->cell($no++, 20, 'c');
$doc->cell(fftgl($r['tanggal']), 80);
$doc->cell($r['nisn'], 30);
$doc->cell($r['siswa'], 80);
$doc->cell($r['njenis'], 50);
$doc->cell($r['keterangan'], 50);
}
function getKeywordValue()
{
$keywords = '';
if (!self::isEmpty() && SJB_Settings::getSettingByName('get_keyword_from_file')) {
$fileId = $this->getComplexParent() . ":" . $this->property_info['id'] . ":" . $this->complexEnum . "_" . $this->object_sid;
$fileInfo = SJB_UploadFileManager::getUploadedFileInfo($fileId);
if ($fileInfo) {
$uploadManager = new SJB_UploadFileManager();
$uploadManager->setFileGroup("files");
$fileUrl = $uploadManager->getUploadedFileLink($fileId, $fileInfo, true);
$fileExtension = substr(strrchr($fileInfo['saved_file_name'], "."), 1);
if (file_exists($fileUrl)) {
switch ($fileExtension) {
case 'doc':
$doc = new doc();
$doc->read($fileUrl);
$keywords = preg_replace('/[\\n\\r]/', '', strip_tags($doc->parse()));
break;
case 'docx':
$keywords = SJB_HelperFunctions::docx2text($fileUrl);
$keywords = preg_replace('/[\\n\\r]/', '', strip_tags(html_entity_decode($keywords)));
break;
case 'xls':
case 'xlsx':
$fileInfo['tmp_name'] = $fileUrl;
$fileObj = new SJB_ImportFileXLS($fileInfo);
$fileObj->parse();
$data = $fileObj->getData();
$keywords = '';
foreach ($data as $val) {
$val = array_unique($val);
$val = array_diff($val, array(''));
$keywords .= implode(' ', $val);
}
$keywords = preg_replace("/[[:punct:]^\\s]/ui", " ", $keywords);
break;
case 'pdf':
$outFilename = str_replace("." . $fileExtension, '.txt', $fileUrl);
exec("pdftotext {$fileUrl} {$outFilename}");
if (file_exists($outFilename)) {
$keywords = file_get_contents($outFilename);
$keywords = preg_replace('/[\\n\\r]/', '', strip_tags(html_entity_decode($keywords)));
unlink($outFilename);
}
break;
case 'txt':
$keywords = file_get_contents($fileUrl);
$keywords = preg_replace('/[\\n\\r]/', '', strip_tags(html_entity_decode($keywords)));
break;
}
}
}
}
return $keywords;
}
<?php
require_once APPMOD . 'psb/proses.php';
/* Load App libraries */
require_once DBFILE;
require_once LIBDIR . 'common.php';
require_once MODDIR . 'date.php';
$dept = gpost('departemen');
$departemen = departemen_r($dept);
$pros = gpost('proses');
$proses = proses_r($pros, $dept);
// cell($a,$w=0,$c=1,$r=1,$al='',$b=-1,$bg='',$s='',$atr='')
$cid = gets('token');
$query = mysql_query("SELECT * FROM psb_kelompok WHERE proses='{$pros}'");
$token = doc_decrypt($token);
$doc = new doc();
$doc->cell_format('border:1,align:c');
$doc->nl();
$doc->cell('<img src="logo.png">', 100, '', 2);
$doc->cell('<b>: ' . strtoupper($siswa['nama']) . '</b>', 0, '', 4);
/*
$doc->dochead("Data Kelompok Pendaftaran ".gets('kelompok'),7);
$doc->nl();
*/
$doc->row_blank(7);
$bcolor = array("#86c2ff", "#ffb129", "#00fa29", "#ffcf0d", "#00eb27", "#89bc02", "#ff8001");
$kapasitas = dbFetch("kapasitas", "psb_proses", "W/replid='{$pros}'");
$nsiswa = dbSRow("psb_calonsiswa", "W/proses='{$pros}' AND status<>0");
$barw = 300;
?>
echo $row->getPath();
?>
" target="_blank"><label class="btn-default">下载</label></a></td>
</tr>
<?php
}
}
?>
</table>
<table class="table table-bordered" style="width: 60%" id="002">
<?php
if ($num2 == 0) {
echo "<lable>暂无文档！</lable>";
} else {
$row = new doc();
for ($i = 0; $i < $num2; $i++) {
$row->initDoc($re2[$i]);
?>
<tr>
<td style="width:80%;"><?php
echo $row->getName();
?>
</td>
<td><a href="<?php
echo $row->getPath();
?>
" target="_blank"><label class="btn-default">下载</label></a></td>
</tr>
<?php
<?php
appmod_use('aka/siswa', 'aka/kelas', 'aka/pelajaran', 'aka/rapor');
// cell($a,$w=0,$al='',$c=1,$r=1,$b=-1,$bg='',$s='',$atr='')
$token = gets('token');
$db = siswa_db_byID($token, 'nisn,kelamin,tmplahir,tgllahir,alamat,telpon');
$db->field("mst_agama.agama as nagama");
$db->joinother("aka_siswa", "agama", "mst_agama");
$t = $db->query();
$siswa = dbFA($t);
$doc = new doc(1);
$doc->dochead("DATA SISWA", 4);
$doc->nl();
$doc->cell('<b>' . strtoupper($siswa['nama']) . '</b>', 0, '', 4, 1, 'b');
$doc->nl(5);
$doc->cell('', 0, '', 3);
$lw = 120;
$doc->nl();
$doc->cell('Departemen', $lw, '');
$doc->cell(': ' . $siswa['ndepartemen'], 0, '', 2);
$img = '<img src="photo/siswa.php?id=' . $siswa['replid'] . '" width="120px" />';
$doc->cell($img, 200, 'r', 1, 10);
$doc->nl();
$doc->cell('NIS', $lw, '');
$doc->cell(': ' . $siswa['nis'], 0, '', 2);
$doc->nl();
$doc->cell('NISN', $lw, '');
$doc->cell(': ' . $siswa['nisn'], 0, '', 2);
$doc->nl();
$doc->cell('', 0, '', 3);
$doc->nl();
// Query
$db = siswa_db_byID($cid);
$siswa = $db->gofetch();
$kls = $siswa['idkelas'];
if ($sna != "") {
$db->field("(" . $sna . ") as TNRAPOR");
} else {
$db->field("0 as TNRAPOR");
}
if ($npeni > 0) {
$db->field("((" . $sna . ")/" . $npeni . ") as AVGRAPOR");
} else {
$db->field("0 as AVGRAPOR");
}
$t = $db->query();
$doc = new doc();
$doc->dochead("LAPORAN HASIL BELAJAR SISWA", 6);
$doc->row_blank(6);
$doc->nl();
$doc->cell('<b>NAMA</b>', 100, '', 2);
$doc->cell('<b>: ' . strtoupper($siswa['nama']) . '</b>', 0, '', 4);
$doc->nl();
$doc->cell('<b>NIS</b>', 100, '', 2);
$doc->cell('<b>: ' . $siswa['nis'] . '</b>', 0, '', 4);
$doc->nl();
$doc->cell('<b>KELAS</b>', 100, '', 2);
$doc->cell('<b>: ' . $siswa['nkelas'] . '</b>', 0, '', 4);
$doc->nl();
$doc->cell('', 40);
$doc->cell('', 60);
$doc->cell('', 0, '', 4);
require_once MODDIR . 'date.php';
define('IMGDIR', ROTDIR . 'images/');
$dept = gpost('departemen');
$departemen = departemen_r($dept);
$proses = proses_r($pros, $dept);
// cell($a,$w =0,$c=1,$r=1,$al='',$b=-1,$bg='',$s='',$atr='')
$cid = gets('token');
$pros = gpost('proses');
$query = mysql_query("SELECT * FROM psb_proses WHERE departemen='{$dept}'");
$token = doc_decrypt($token);
/*
$gb = mysql_query("SELECT nama,fname FROM rep_file WHERE replid=13")
$data = mysql_fetch_assoc($gb)
$gambar = $data[fname];
*/
$doc = new doc();
$doc->dochead("Data Periode Penerimaan " . gets('kelompok'), 9);
$doc->nl();
$doc->row_blank(9);
$doc->nl();
$doc->cell('<b>NAMA</b>', 100, '', 9);
//$t=dbQSql($token);
$no = 1;
$doc->head('No{C}', '@Periode Penerimaan', '@Kode Awalan', '@Angkatan', '@Kapasitas', '@Calon Siswa', '@Siswa diterima', '@Status', 'Keterangan');
while ($r = dbFA($query)) {
$q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE proses = '" . $r['replid'] . "'");
$n = mysql_num_rows($q);
$q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE proses = '" . $r['replid'] . "' AND status<>0");
$n1 = mysql_num_rows($q);
$doc->nl();
$doc->cell($no++, 20, 'c');
function doc2text($filename)
{
$doc = new doc();
$doc->read($filename);
return $doc->parse();
}
if (!$in) {
$a = $s == 1 ? 0 : $d;
}
return $res;
}
$dept = gpost('departemen');
$departemen = departemen_r($dept);
$pros = gpost('proses');
$proses = proses_r($pros, $dept);
$kel = gpost('kelompok');
$kelompok = kelompok_r($kel, $pros);
$cid = gets('token');
$query = mysql_query("SELECT * FROM psb_calonsiswa WHERE replid='{$cid}' LIMIT 0,1");
//$query = mysql_query("SELECT * FROM psb_calonsiswa WHERE proses='$pros' AND kelompok='$kel' ORDER BY nopendaftaran");
$token = doc_decrypt($token);
$doc = new doc();
$doc->dochead('Pendataan Calon Siswa', 100);
//$doc->nl();
//$doc->row_blank(5);
//$t=dbQSql($token);
$no = 1;
$doc->head('@Nomor Pendaftaran{2}', '@Nama{2}', '@Uang Pangkal{R,2}', 'Discount{C,1,3}', 'Denda{R,2}', 'Uang pangkal net{R,2,90px}', 'Angsuran{R}');
$doc->head('Subsidi{R}', 'Saudara{R}', 'Tunai{R}', '!x bulan{R}');
while ($r = dbFA($query)) {
$doc->nl();
//$doc->cell($no++,20,'c');
$doc->cell($r['nopendaftaran'], 90, 'r');
$doc->cell($r['nama']);
$doc->cell(fRp($r['sumpokok']), 90, 'r');
$doc->cell(fRp($r['disctb']), 90, 'r');
$doc->cell(fRp($r['discsaudara']), 90, 'r');
<?php
appmod_use('aka/siswa', 'aka/kelas', 'aka/pelajaran', 'aka/rapor');
// cell($a,$w=0,$c=1,$r=1,$al='',$b=-1,$bg='',$s='',$atr='')
$token = gets('token');
$token = doc_decrypt($token);
$doc = new doc();
$doc->dochead("Data Siswa Angkatan " . gets('angkatan'), 5);
$doc->row_blank(5);
$t = dbQSql($token);
$no = 1;
$doc->head('No{C}', '@!NIS', '@!NISN', '@nama', 'Tempat Tanggal lahir');
while ($r = dbFA($t)) {
$doc->nl();
$doc->cell($no++, 40, 'c');
$doc->cell($r['nis'], 50);
$doc->cell($r['nisn'], 80);
$doc->cell($r['nama'], 0);
$doc->cell($r['tmplahir'] . ', ' . fftgl($r['tgllahir']), 170);
}
$doc->end();
/**
* 添加关系
*/
public static final function append()
{
$error = array();
$online = front::online();
$get = array('s_type' => isset($_GET['s_type']) ? $_GET['s_type'] : '', 't_type' => isset($_GET['t_type']) ? $_GET['t_type'] : '', 's_id' => isset($_GET['s_id']) ? (int) $_GET['s_id'] : '0', 't_id' => isset($_GET['t_id']) ? (int) $_GET['t_id'] : '0');
$s_list = null;
if ($get['s_type'] == 'channel') {
$s_list = channel::get_channel_select(0, 0, $get['s_id'], null, null);
} elseif ($get['s_type'] == 'address') {
$s_lists = address::selects('address_id as id,name', null, array('user_id' => $online->user_id), array('ORDER BY address_id DESC'), array('id', 'column|table=address' => 'name'));
if ($s_lists) {
$s_list = make_option($s_lists, $get['s_id']);
}
} elseif ($get['s_type'] == 'book') {
$s_lists = book::selects('book_id as id,concat_ws(\',\',create_date,item_txt,remark,ccy,amount,otype) as name', null, array('user_id' => $online->user_id), array('ORDER BY create_date DESC,book_id DESC'), array('id', 'column|table=book' => 'name'));
if ($s_lists) {
$s_list = make_option($s_lists, $get['s_id']);
}
} elseif ($get['s_type'] == 'diary') {
$s_lists = diary::selects('diary_id as id,title as name', null, array('user_id' => $online->user_id), array('ORDER BY diary_id DESC'), array('id', 'column|table=diary' => 'name'));
if ($s_lists) {
$s_list = make_option($s_lists, $get['s_id']);
}
} elseif ($get['s_type'] == 'doc') {
$s_lists = doc::selects('doc_id as id,title as name', null, array('user_id' => $online->user_id), array('ORDER BY doc_id DESC'), array('id', 'column|table=doc' => 'name'));
if ($s_lists) {
$s_list = make_option($s_lists, $get['s_id']);
}
} elseif ($get['s_type'] == 'site') {
$s_lists = site::selects('site_id as id,title as name', null, array('user_id' => $online->user_id), array('ORDER BY site_id DESC'), array('id', 'column|table=site' => 'name'));
if ($s_lists) {
$s_list = make_option($s_lists, $get['s_id']);
}
} elseif ($get['s_type'] == 'user') {
$s_lists = user::selects('user_id as id,username as name', null, array('user_id' => $online->user_id), array('ORDER BY user_id DESC'), array('id', 'column|table=user' => 'name'));
if ($s_lists) {
$s_list = make_option($s_lists, $get['s_id']);
}
} else {
}
$t_list = null;
if ($get['t_type'] == 'channel') {
$t_list = channel::get_channel_select(0, 0, $get['t_id'], null, null);
} elseif ($get['t_type'] == 'address') {
$t_lists = address::selects('address_id as id,name', null, array('user_id' => $online->user_id), array('ORDER BY address_id DESC'), array('id', 'column|table=address' => 'name'));
if ($t_lists) {
$t_list = make_option($t_lists, $get['t_id']);
}
} elseif ($get['t_type'] == 'book') {
$t_lists = book::selects('book_id as id,concat_ws(\',\',create_date,item_txt,remark,ccy,amount,otype) as name', null, array('user_id' => $online->user_id), array('ORDER BY create_date DESC,book_id DESC'), array('id', 'column|table=book' => 'name'));
if ($t_lists) {
$t_list = make_option($t_lists, $get['t_id']);
}
} elseif ($get['t_type'] == 'diary') {
$t_lists = diary::selects('diary_id as id,title as name', null, array('user_id' => $online->user_id), array('ORDER BY diary_id DESC'), array('id', 'column|table=diary' => 'name'));
if ($t_lists) {
$t_list = make_option($t_lists, $get['t_id']);
}
} elseif ($get['t_type'] == 'doc') {
$t_lists = doc::selects('doc_id as id,title as name', null, array('user_id' => $online->user_id), array('ORDER BY doc_id DESC'), array('id', 'column|table=doc' => 'name'));
if ($t_lists) {
$t_list = make_option($t_lists, $get['t_id']);
}
} elseif ($get['t_type'] == 'site') {
$t_lists = site::selects('site_id as id,title as name', null, array('user_id' => $online->user_id), array('ORDER BY site_id DESC'), array('id', 'column|table=site' => 'name'));
if ($t_lists) {
$t_list = make_option($t_lists, $get['t_id']);
}
} elseif ($get['t_type'] == 'user') {
$t_lists = user::selects('user_id as id,username as name', null, array('user_id' => $online->user_id), array('ORDER BY user_id DESC'), array('id', 'column|table=user' => 'name'));
if ($t_lists) {
$t_list = make_option($t_lists, $get['t_id']);
}
} else {
}
// 表单处理
while (isset($_SERVER['REQUEST_METHOD']) && $_SERVER['REQUEST_METHOD'] === 'POST') {
// 数据消毒
$post = array('s_type' => isset($_POST['s_type']) ? $_POST['s_type'] : '', 't_type' => isset($_POST['t_type']) ? $_POST['t_type'] : '', 's_id' => isset($_POST['s_id']) ? (int) $_POST['s_id'] : '0', 't_id' => isset($_POST['t_id']) ? (int) $_POST['t_id'] : '0', 'user_id' => $online->user_id);
if (!$post['s_type']) {
$error['s_type'] = '请选择源类型';
}
if (!$post['t_type']) {
$error['t_type'] = '请选择目标类型';
}
if (!$post['s_id']) {
$error['s_id'] = '请选择源内容';
}
if (!$post['t_id']) {
$error['t_id'] = '请选目标内容';
}
if (!$error['t_id']) {
if ($post['s_type'] == $post['t_type'] && $post['s_id'] == $post['t_id']) {
$error['t_id'] = '不能和自己关联';
}
}
if (!$error['t_id']) {
$related_id = self::selects('related_id', null, array('user_id' => $online->user_id, 's_id' => $post['s_id'], 's_type' => $post['s_type'], 't_id' => $post['t_id'], 't_type' => $post['t_type']), null, array('column' => 'related_id'));
if (!$related_id) {
$related_id = self::selects('related_id', null, array('user_id' => $online->user_id, 's_id' => $post['t_id'], 's_type' => $post['t_type'], 't_id' => $post['s_id'], 't_type' => $post['s_type']), null, array('column' => 'related_id'));
}
if ($related_id) {
$error['t_id'] = '目标内容已经关联，请重新选择';
}
}
if (!empty($error)) {
break;
}
// 数据入库
$related = new self();
$related->related_id = null;
$related->struct($post);
$related->insert();
$error = '添加成功';
front::view2('error.tpl', compact('error'));
return;
}
$types = array('address' => '地址', 'book' => '账本', 'channel' => '分类', 'diary' => '日志', 'doc' => '文章', 'site' => '网址', 'user' => '用户');
front::view2(__CLASS__ . '.' . 'form.tpl', compact('post', 'get', 'error', 'types', 's_list', 't_list'));
}
<?php
appmod_use('aka/siswa', 'aka/kelas', 'aka/pelajaran', 'aka/rapor');
// Query
$sql = gpost('pagesql');
$t = mysql_query($sql);
$doc = new doc(1);
$doc->colnum = 1;
$doc->dochead("JURNAL UMUM", $doc->colnum);
$doc->row_blank($doc->colnum);
$doc->nl();
$doc->cell('<b>NAMA</b>', 100, '', 2);
$doc->cell('<b>: ' . strtoupper($siswa['nama']) . '</b>', 0, '', 4);
/*
$doc->nl();
$doc->cell('<b>NIS</b>',100,'',2);
$doc->cell('<b>: '.$siswa['nis'].'</b>',0,'',4);
$doc->nl();
$doc->cell('<b>KELAS</b>',100,'',2);
$doc->cell('<b>: '.$siswa['nkelas'].'</b>',0,'',4);
$doc->nl();
$doc->cell('',40);
$doc->cell('',60);
$doc->cell('',0,'',4);
$doc->cell_format('border:1,align:c');
$doc->nl(30);
$doc->cell('<b>NO</b>',40);
$doc->cell('<b>MATA PELAJARAN</b>',0,'',2);
<?php
//appmod_use('aka/siswa','aka/kelas','aka/pelajaran','aka/rapor');
// cell($a,$w=0,$c=1,$r=1,$al='',$b=-1,$bg='',$s='',$atr='')
$token = gets('token');
$token = doc_decrypt($token);
$doc = new doc();
$doc->dochead("Data Siswa Kelas " . gets('kelas'), 5);
$doc->nl();
$doc->cell("Tahun Ajaran " . gets('tahunajaran'), 0, 'c', 5, 1);
$doc->row_blank(5);
$t = dbQSql($token);
$no = 1;
$doc->head('No{C}', '@!NIS', '@!NISN', '@nama', 'Tempat Tanggal lahir');
while ($r = dbFA($t)) {
$doc->nl();
$doc->cell($no++, 40, 'c');
$doc->cell($r['nis'], 50);
$doc->cell($r['nisn'], 80);
$doc->cell($r['nama'], 0);
$doc->cell($r['tmplahir'] . ', ' . fftgl($r['tgllahir']), 170);
}
$doc->end();
