function get_intranet_data() { include 'themes/msosocial/odbc_connect.php'; $this->load->helper('html'); $rs_intranet = $db->Execute("select * from INTRANET_ACTCALENDAR WHERE ROWNUM <=12 ORDER BY ID DESC"); //insert data to db mso foreach ($rs_intranet as $row) { dbConvert($row); $intranet_id = $row['id']; $type_cal = $row['actcalendar_type_id']; $type_name = 'อบรม'; if ($type_cal == '7') { $type_name = 'อบรม'; } elseif ($type_cal == '8') { $type_name = 'ประชุม'; } elseif ($type_cal == '9') { $type_name = 'กิจกรรม'; } $rs_check = new content_calendar(); $rs_check->where('intranet_id = "' . $intranet_id . '"')->order_by('id', 'desc')->get(); if (!$rs_check->id) { $rs = new content_calendar(); $rs->title = $row['title']; $rs->detail = $row['detail']; $rs->image = 'no image'; $rs->created = date('Y-m-d H:i:s'); $rs->updated = date('Y-m-d H:i:s'); $rs->module = 'mso'; $rs->category = $row['actcalendar_type_id']; $rs->slug = $type_name; $rs->status = 'approve'; $rs->user_id = 49; $rs->orderlist = 0; $rs->counter = 0; $rs->start_date = date('Y-m-d H:i:s'); $rs->end_date = date('Y-m-d H:i:s'); $rs->intranet_id = $row['id']; $rs->source_data = 'mso'; $rs->place = 'mso'; $rs->save(); } } //set_notify('success', lang('save_data_complete')); //********** $data['rs'] = new content_calendar(); $data['rs']->where("module = 'mso'")->order_by('id desc')->get(); $this->template->append_metadata(js_checkbox('approve')); $this->template->build('admin/index', $data); }
function get_intranet_data() { include 'themes/fundv2/odbc_connect.php'; $this->load->helper('html'); $rs_intranet = $db->Execute("select * from WEB_NEWS WHERE ROWNUM <=12 ORDER BY ID DESC"); //insert data to db mso $count_news_mso = 0; foreach ($rs_intranet as $row) { dbConvert($row); //http://intranet.m-society.go.th/upload/newsletters/ $intranet_id = $row['id']; $rs_check = new Info(); $rs_check->where('intranet_id = "' . $intranet_id . '"')->order_by('id', 'desc')->get(); if (!$rs_check->id) { $rs = new Info(); $rs->title = $row['title']; $rs->detail = $row['detail']; $rs->image = $row['img_title']; $rs->created = date('Y-m-d H:i:s'); $rs->updated = date('Y-m-d H:i:s'); $rs->start_date = date('Y-m-d H:i:s'); $rs->end_date = date('Y-m-d H:i:s'); $rs->module = 'ข่าวประชาสัมพันธ์'; $rs->slug = 'mso'; $rs->status = 'approve'; $rs->user_id = 49; $rs->counter = 0; $rs->intranet_id = $row['id']; $rs->save(); $count_news_mso++; } } //set_notify('success', lang('save_data_complete')); //********** $data['count_news_mso'] = $count_news_mso; $data['get_intranet'] = 'mso'; $data['rs'] = new Info(); $data['rs']->where('module = "ข่าวประชาสัมพันธ์"')->order_by('id', 'desc')->get(); $this->template->append_metadata(js_checkbox('approve')); $this->template->build('admin/index', $data); }
</table> </form> </div><!--#nav-search--> <div style="clear:both; margin-top:15px; margin-bottom:5px;"> </div> <div id='loading' style='display:none;' align="center"><img src="media/images/ajax-loader.gif" /></div> <div id='calendar1'></div> <div style="clear:both; margin-top:15px; margin-bottom:5px;"> </div> <?php $bg_bulet = "#77c705"; foreach ($rs_type as $row_type) { dbConvert($row_type); $bg_bulet = $row_type['color']; ?> <div style="float:left; background-color:<?php echo $bg_bulet; ?> ; width:74px; height:24px;border-radius:4px; -webkit-border-radius:4px;-moz-border-radius:4px; padding:15px 15px 30px 15px; margin-left:15px; text-align:center; font-weight:normal; color:#FFF;"> <?php echo $row_type['name']; ?> </div>
public function testdb() { $this->load->library('adodb'); $row = $this->ado->pageexecute('SELECT * FROM ACT_PROVINCE', 10, 1); //dbConvert($row); foreach ($row as $item) { dbConvert($item); echo $item['province_name'] . '<br />'; } }
<div id="title-blank">ข่าวประชาสัมพันธ์</div> <div id="breadcrumb"><a href="/home/index">หน้าแรก</a> > <span class="b1">ข่าวประชาสัมพันธ์</span></div> <div id="page"> <?php $this->load->helper('html'); foreach ($rs as $row) { dbConvert($row); ?> <div class="media col-lg-6"> <div class="media-left media-middle"> <a href="infos/view_mso/<?php echo $row['id']; ?> " target="_blank" > <?php $file = "http://intranet.m-society.go.th/upload/newsletters/" . $row['img_title']; //$file = 'http://www.domain.com/somefile.jpg'; $file_headers = @get_headers($file); if ($file_headers[0] == 'HTTP/1.1 404 Not Found') { ?> <img src="themes/fundv2/images/NoImg.jpg" width="158" height="110" class="img-pr-news"> <?php } else { ?> <img src="http://intranet.m-society.go.th/upload/newsletters/<?php