<table cellpadding="0" cellspacing="0" class='contentblock'> <tr> <td class="head"><a href="<?php echo site_url(); ?> company/<?php echo $company['slug']; ?> "><?php echo htmlentitiesX($company['name']); ?> </a></td> </tr> <tr> <td class="logo"> <a href="<?php echo site_url(); ?> company/<?php echo $company['slug']; ?> " title="<?php echo sanitizeX($company['name']); ?> " alt="<?php echo sanitizeX($company['name']); ?> "> <?php if (trim($company['logo'])) { ?>
public function ajax_add($contributionid = "") { if (!$_SESSION['user'] && !$_SESSION['web_user']) { return false; } if (trim($_POST['name'])) { //check if company already exists $sql = "select `id` from `investment_orgs` where `name`=" . $this->db->escape(trim($_POST['name'])); $q = $this->db->query($sql); $investment_org = $q->result_array(); } $err = 0; if (!trim($_POST['name'])) { $err = 1; ?> alertX("<div class='red'>Please input a Name.</div>"); <?php } else { if ($investment_org[0]['id']) { $err = 1; ?> alertX("<div class='red'>Investment organization already exists in the database.</div>"); <?php } else { if (!trim($_POST['description'])) { $err = 1; ?> alertX("<div class='red'>Please input a Investment organization description.</div>"); <?php } else { if (!checkEmail($_POST['email_address'])) { $err = 1; ?> alertX("<div class='red'>Please input a valid E-mail.</div>"); <?php } } } } //save a contribution if ($_SESSION['web_user'] && $_POST['web_edit'] && !$err) { $sql = "insert into `contributions` set \n\t\t\t\t`web_user_id`='" . $_SESSION['web_user']['id'] . "',\n\t\t\t\t`table`='investment_orgs',\n\t\t\t\t`json_data`='" . mysql_real_escape_string(json_encode($_POST)) . "',\n\t\t\t\t`dateadded_ts` = '" . time() . "',\n\t\t\t\t`dateupdated_ts` = '" . time() . "',\n\t\t\t\t`approved` = 0\n\t\t\t"; $this->db->query($sql); ?> alertX("<center>Thanks for the submission. It will be reviewed and approved shortly.</center>"); setTimeout(function(){ self.location = self.location; }, 2000); self.location = self.location; //jQuery("#savebutton").val("Submit"); //jQuery("#company_form *").attr("disabled", true); <?php return false; } if (!$err) { $sql = "insert into `investment_orgs` set "; $arr = array(); foreach ($_POST as $key => $value) { if (!is_array($value) && $key != 'sid') { $arr[] = "`" . $key . "`=" . $this->db->escape(trim($value)); } } if ($_POST['founded']) { $mdy = explode("/", $_POST['founded']); $arr[] = "`found_month` = " . $this->db->escape(trim($mdy[0])); $arr[] = "`found_day` = " . $this->db->escape(trim($mdy[1])); $arr[] = "`found_year` = " . $this->db->escape(trim($mdy[2])); } $sqlext = implode(", ", $arr); $sql .= $sqlext . ", `dateadded`=NOW(), `dateupdated`=NOW()"; $q = $this->db->query($sql); $id = $this->db->insert_id(); $this->slugify($id); //update logo url $logo = $_POST['logo']; if ($logo) { $logo = str_replace("temp/" . $_POST['sid'], $id, $logo); //replace sid with the company id $sql = "update `investment_orgs` set `logo`=" . $this->db->escape($logo) . " where `id`=" . $this->db->escape($id); $this->db->query($sql); //move files $from = dirname(__FILE__) . "/../../media/uploads/investment_orgs/temp/" . $_POST['sid'] . "/logo/" . urldecode(basename($logo)); $folder = dirname(__FILE__) . "/../../media/uploads/investment_orgs/" . $id . "/"; if (!is_dir($folder)) { mkdir($folder, 0777); } $folder = $folder . "logo/"; if (!is_dir($folder)) { mkdir($folder, 0777); } $to = $folder . urldecode(basename($logo)); rename($from, $to); } if (is_array($_POST['p_ids'])) { $sql = "delete from `investment_org_person` where `investment_org_id`=" . $this->db->escape($id); $this->db->query($sql); foreach ($_POST['p_ids'] as $key => $value) { $start_date_ts = strtotime($_POST['p_start_dates'][$key]); $end_date_ts = 0; if ($_POST['p_end_dates'][$key]) { $end_date_ts = strtotime($_POST['p_end_dates'][$key]); } $sql = "insert into `investment_org_person` set \n\t\t\t\t\t`investment_org_id`=" . $this->db->escape($id) . ", \n\t\t\t\t\t`person_id`=" . $this->db->escape($_POST['p_ids'][$key]) . ",\n\t\t\t\t\t`role`=" . $this->db->escape($_POST['p_roles'][$key]) . ",\n\t\t\t\t\t`start_date`=" . $this->db->escape($_POST['p_start_dates'][$key]) . ",\n\t\t\t\t\t`start_date_ts`=" . $this->db->escape($start_date_ts) . ",\n\t\t\t\t\t`end_date`=" . $this->db->escape($_POST['p_end_dates'][$key]) . ",\n\t\t\t\t\t`end_date_ts`=" . $this->db->escape($end_date_ts); $this->db->query($sql); } } if ($_POST['sid']) { $dir = dirname(__FILE__) . "/../../media/uploads/investment_orgs/temp/" . $_POST['sid']; SureRemoveDir($dir, "true"); } if ($contributionid) { $sql = "update `contributions` set `ipc_id`='" . $id . "', `approved`=1 where `id`='" . mysql_real_escape_string($contributionid) . "'"; $q = $this->db->query($sql); } ?> alertX("Successfully Added Investment Organization '<?php echo htmlentitiesX($_POST['name']); ?> '."); //self.location = "<?php echo site_url(); ?> investment_orgs/edit/<?php echo $id; ?> "; <?php if ($contributionid) { ?> self.location = "<?php echo site_url(); ?> contributions"; <?php } else { ?> self.location = "<?php echo site_url(); ?> investment_orgs/add"; <?php } $sql = "insert into `logs` set \n\t\t\t\t`action` = 'added',\n\t\t\t\t`table` = 'investment_orgs',\n\t\t\t\t`ipc_id` = " . $this->db->escape($id) . ",\n\t\t\t\t`name` = " . $this->db->escape(trim($_POST['name'])) . ",\n\t\t\t\t`user_id` = " . $this->db->escape(trim($_SESSION['user']['id'])) . ",\n\t\t\t\t`dateadded_ts` = " . time() . ",\n\t\t\t\t`dateadded` = NOW()\n\t\t\t"; $this->db->query($sql); } ?> jQuery("#savebutton").val("Save"); jQuery("#investment_org_form *").attr("disabled", false); <?php exit; }
if ($investment_orgs[$i]['active'] == 1) { echo "Yes"; } else { echo "No"; } ?> </td> <td>[ <a href="<?php echo site_url(); ?> investment_orgs/edit/<?php echo $investment_orgs[$i]['id']; ?> " >Edit</a> ] [ <a style='color: red; cursor:pointer; text-decoration: underline' onclick='deleteInvestmentOrg("<?php echo htmlentitiesX($investment_orgs[$i]['id']); ?> "); ' >Delete</a> ]</td> </tr> <?php } if ($pages > 0) { ?> <tr> <td colspan="6" class='center font12' > There is a total of <?php echo $cnt; ?> <?php if ($cnt > 1) { echo "records";
$img = '<img src="data::image/jpg;base64,' . $imgdata . '" />'; } else { $img = ""; } ?> <td><?php echo $img; ?> </td> <td><?php echo htmlentitiesX($c['country']); ?> </td> <td><?php echo htmlentitiesX($c['people']); ?> </td> <td><?php echo htmlentitiesX($c['status']); ?> </td> <td><?php echo htmlentitiesX($c['active']); ?> </td> <?php echo "</tr>"; } ?> </table>
</tr> <tr> <th style="width:20px"></th> <th>Date</th> <th>Revised Record</th> <th>Revision By</th> <th>Status</th> <th></th> </tr> <?php $t = count($revisions); for ($i = 0; $i < $t; $i++) { ?> <tr id="tr<?php echo htmlentitiesX($revisions[$i]['id']); ?> " class="row" > <td><?php echo $start + $i + 1; ?> </td> <td> <?php echo "<a href='" . site_url() . $revisions[$i]['table'] . "/revision/" . $revisions[$i]['id'] . "'>" . date("M d, Y H:i:s", $revisions[$i]['dateupdated_ts']) . "</a>"; ?> </td> <td> <?php $sql = "select * from `" . $revisions[$i]['table'] . "` where `id`=" . $this->db->escape($revisions[$i]['ipc_id']); $q = $this->db->query($sql);
if ($people[$i]['active'] == 1) { echo "Yes"; } else { echo "No"; } ?> </td> <td>[ <a href="<?php echo site_url(); ?> people/edit/<?php echo $people[$i]['id']; ?> " >Edit</a> ] [ <a style='color: red; cursor:pointer; text-decoration: underline' onclick='deletePerson("<?php echo htmlentitiesX($people[$i]['id']); ?> "); ' >Delete</a> ]</td> </tr> <?php } if ($pages > 0) { ?> <tr> <td colspan="8" class='center font12' > There is a total of <?php echo $cnt; ?> <?php if ($cnt > 1) { echo "records";
$line .= '"Twitter Username",'; $line .= '"Facebook Page",'; $line .= '"LinkedIn Page",'; $line .= '"Tags",'; $line .= '"Active?",'; $line .= '"Companies",'; $line .= '"Investment Orgs",'; $line .= '"Investments",'; $line .= '"Date Added",'; echo $line . "\n"; for ($i = 0; $i < $t; $i++) { $c = $people[$i]; $line = ""; $line .= '"' . htmlentitiesX($c['name']) . '",'; $line .= '"' . htmlentitiesX($c['description']) . '",'; $line .= '"' . htmlentitiesX($c['email_address']) . '",'; $line .= '"' . htmlentitiesX($c['blog_url']) . '",'; $line .= '"' . htmlentitiesX($c['blog']) . '",'; $line .= '"' . htmlentitiesX($c['twitter_username']) . '",'; $line .= '"' . htmlentitiesX($c['facebook']) . '",'; $line .= '"' . htmlentitiesX($c['linkedin']) . '",'; $line .= '"' . htmlentitiesX($c['tags']) . '",'; $line .= '"' . htmlentitiesX($c['active']) . '",'; $line .= '"' . htmlentitiesX($c['companies']) . '",'; $line .= '"' . htmlentitiesX($c['investment_orgs']) . '",'; $line .= '"' . htmlentitiesX($c['milestones']) . '",'; $line .= '"' . htmlentitiesX(date("M d, Y", strtotime($c['dateadded']))) . '",'; echo $line . "\n"; } } }
if ($companies[$i]['active'] == 1) { echo "Yes"; } else { echo "<a style='color:red'>No</a>"; } ?> </td> <td>[ <a href="<?php echo site_url(); ?> companies/edit/<?php echo $companies[$i]['id']; ?> " >Edit</a> ] [ <a style='color: red; cursor:pointer; text-decoration: underline' onclick='deleteCompany("<?php echo htmlentitiesX($companies[$i]['id']); ?> "); ' >Delete</a> ]</td> </tr> <?php } if ($pages > 0) { ?> <tr> <td colspan="6" class='center font12' > There is a total of <?php echo $cnt; ?> <?php if ($cnt > 1) { echo "records";
<th>Name</th> <th>Type</th> <th>Date Added</th> <th></th> </tr> <?php $t = count($web_users); for ($i = 0; $i < $t; $i++) { $user = getWebUser($web_users[$i]); if (!trim($user['name'])) { continue; } ?> <tr id="tr<?php echo htmlentitiesX($user['id']); ?> " class="row" > <td><?php echo $start + $i + 1; ?> </td> <td> <?php if (trim($user['business_email'])) { echo "<a href='" . site_url() . "webusers/editwebuser/" . $user['id'] . "'>" . $user['business_email'] . "</a>"; } else { if (trim($user['email'])) { echo "<a href='" . site_url() . "webusers/editwebuser/" . $user['id'] . "'>" . $user['email'] . "</a>"; } else { echo "<a href='" . site_url() . "webusers/editwebuser/" . $user['id'] . "'>No email</a>";
} ?> </table> </td> </tr> </table> <?php } ?> </td> <td class='company_right'> <table cellpadding="0" cellspacing="0" class="p100"> <tr> <td class="company_name"> <?php echo htmlentitiesX($person['name']); if ($companies[0]) { ?> <div class='person_role'> <?php echo trim($companies[0]['role']); ?> </div> <div class='person_company'> <?php echo trim($companies[0]['company_name']); ?> </div> <?php } ?>
} ?> </table> </td> </tr> </table> <?php } ?> </td> <td class='company_right'> <table cellpadding="0" cellspacing="0" class="p100"> <tr> <td class="company_name"> <?php echo htmlentitiesX($investment_org['name']); if ($_SESSION['web_user'] || 1) { echo "<div class='edit inline right'><a href='" . site_url() . "editinvestment_org/" . $investment_org['id'] . "/about'>EDIT</div>"; } ?> </td> </tr> <tr> <td class="description"> <div class="description_title">Description</div> <div class="description_contents"><?php echo nl2br($investment_org['description']); ?> </div> </td> </tr>
function e27() { $datefrom = $_GET['datefrom']; $dateto = $_GET['dateto']; if (!trim($datefrom) || !trim($dateto)) { echo "Incomplete parameters!"; exit; } $date = date($dateto); $day = 24 * 60 * 60; $tsnow = strtotime($date); $ts = $tsnow; header('Content-type: application/ms-excel;'); header("Content-Type: application/force-download"); header('Content-Disposition: attachment; filename=e27.xls'); echo '<table border="1">'; $datefrom = strtotime($datefrom) - $day; $datefrom = date("Y-m-d", $datefrom); while (date("Y-m-d", $ts) != $datefrom) { $url = "http://www.e27.sg/" . date("Y/m/d", $ts) . "/feed/"; $rss = @fetch_rss($url); foreach ($rss->items as $key => $value) { //echo "<pre>"; //print_r($value); //echo "</pre>"; //exit(); echo "<tr>"; echo "<td>" . date("M d, Y", strtotime($value['pubdate'])) . "</td>"; echo "<td>" . htmlentitiesX($value['title']) . "</td>"; echo "<td>" . htmlentitiesX($value['dc']['creator']) . "</td>"; echo "</tr>"; } $ts -= $day; } echo "</table>"; //$items = @array_slice($rss->items, 0, 10); }
</td> </tr> <tr class="even"> <td>Twitter:</td> <td> <input type='text' style='width:300px;' name='twitter' value="<?php echo htmlentitiesX($web_user['twitter']); ?> " /> </td> </tr> <tr class="odd"> <td>Homepage:</td> <td> <input type='text' style='width:300px;' name='homepage' value="<?php echo htmlentitiesX($web_user['homepage']); ?> " /> </td> </tr> <?php if (trim($web_user['fb_id']) == "" && trim($web_user['in_id']) == "") { ?> <tr class="even"> <td>Password:</td> <td> <input type='text' style='width:300px;' name='password' placeholder='Input value to change password.' /> </td> </tr> <?php }
</tr> <tr> <th style="width:20px"></th> <th>Date</th> <th>Contribution</th> <th>Contributed By</th> <th>Status</th> <th></th> </tr> <?php $t = count($contributions); for ($i = 0; $i < $t; $i++) { ?> <tr id="tr<?php echo htmlentitiesX($contributions[$i]['id']); ?> " class="row" > <td><?php echo $start + $i + 1; ?> </td> <td> <?php echo "<a href='" . site_url() . $contributions[$i]['table'] . "/contribution/" . $contributions[$i]['id'] . "'>" . date("M d, Y H:i:s", $contributions[$i]['dateadded_ts']) . "</a>"; ?> </td> <td> <?php if ($contributions[$i]['table'] == 'companies') { $table = "Company";
<tr id="tr<?php echo htmlentitiesX($list[$i]['id']); ?> " class="row" > <td><?php echo $start + $i + 1; ?> </td> <td><a href="<?php echo site_url() . $list[$i]['list_type']; ?> /edit/<?php echo $list[$i]['id']; ?> " ><?php echo htmlentitiesX($list[$i]['name']); ?> </a></td> <td> <?php if (is_array($list[$i]['feed'])) { $this->load->view('blogs_rss/feeds', $list[$i]['feed']); } ?> </td> </tr> <?php } if ($pages > 0) { ?> <tr>
<a href='<?php echo $imgfilebig; ?> ' target='_blank'> <img style='border:0px' src="<?php echo $imgfile; ?> " alt="<?php echo htmlentitiesX($screenshots[$i]['title']); ?> " title="<?php echo htmlentitiesX($screenshots[$i]['title']); ?> " /> <div class='title'><?php echo htmlentitiesX($screenshots[$i]['title']); ?> </div> </a> <?php } /* ?> <a><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAM0AAAD NCAMAAAAsYgRbAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5c cllPAAAABJQTFRF3NSmzMewPxIG//ncJEJsldTou1jHgAAAARBJREFUeNrs2EEK gCAQBVDLuv+V20dENbMY831wKz4Y/VHb/5RGQ0NDQ0NDQ0NDQ0NDQ0NDQ 0NDQ0NDQ0NDQ0NDQ0NDQ0NDQ0PzMWtyaGhoaGhoaGhoaGhoaGhoxtb0QGho aGhoaGhoaGhoaGhoaMbRLEvv50VTQ9OTQ5OpyZ01GpM2g0bfmDQaL7S+ofFC6x v3ZpxJiywakzbvd9r3RWPS9I2+MWk0+kbf0Hih9Y17U0nTHibrDDQ0NDQ0NDQ0 NDQ0NDQ0NTXbRSL/AK72o6GhoaGhoRlL8951vwsNDQ0NDQ1NDc0WyHtDTEhD