$isExists = $mysql->field('count(1) as ct')->where(array('sku' => '"' . $_ary->sku . '"', 'lotid' => array('"' . $_ary->lotid . '"', '=', 'and'), 'supplyid' => array('"' . $_ary->supplyid . '"', '=', 'and')))->select('yy_reports'); if ((int) $isExists[0]['ct'] == 0) { $data = array('sku' => $_ary->sku, 'lotid' => $_ary->lotid, 'spec' => $_ary->spec, 'cdname' => $_ary->cdname, 'cdcode' => $_ary->cdcode, 'supplyid' => $_ary->supplyid, 'spname' => $_ary->spname, 'spcode' => $_ary->spcode, 'picpath' => $_ary->picpath); $mysql->insert('yy_reports', $data); return true; } return false; } public function appendDataToMySql($ary) { foreach ($ary as $s) { $filename = $s; $file_extension = end(explode('.', $filename)); if ($file_extension == 'json') { $filename = $this->_config['report']['jsonpath'] . '/' . $filename; $json_string = file_get_contents($filename); //Mysql if ($this->setData($json_string)) { //echo $this->_config['msgs.success']; copy($filename, $this->_config['report']['bak'] . $s); unlink($filename); } else { // } } } } } $ary = CommonFactory::Create()->getDir($configs['report']['jsonpath']); $append = new Append($configs); $append->appendDataToMySql($ary);
$htmlData = $_POST['content']; } } $htmlData = htmlspecialchars($htmlData); $smarty->assign(array('htmlData' => $htmlData)); $smarty->template_dir = $template_dir; $smarty->display('add.tpl'); if ($_POST) { $str = ob_get_contents(); $outpath = 'news/' . date('Ymd'); //.DIRECTORY_SEPARATOR.date('m').DIRECTORY_SEPARATOR.date('d'); if (!is_dir($outpath)) { mkdir($outpath); chmod($outpath, 0777); } $num = CommonFactory::Create()->random(10); $outfilename = $outpath . DIRECTORY_SEPARATOR . '' . $num . '.html'; $fp = @fopen($outfilename, 'w'); if (!$fp) { //Show_Error_Message( ERROR_WRITE_FILE ); echo 'error'; exit; } fwrite($fp, $str); fclose($fp); ob_end_clean(); $data = array('title' => $_POST['title'], 'subtitle' => $_POST['subtitle'], 'content' => $_POST['content']); AdminNewsFactory::intance()->setData($data); //@header ( "Location: ../../admin/news/msgs?msg=ok" ); echo "<script>self.location.href='../../admin/news/msgs?msg=ok&goto=admin/news/list';</script>"; }