/**
* Get list content
* @param type $get
* @return type array
*/
function get_list_content_info($get)
{
$linkid = $this->db_conn();
$output = array();
$cond = '';
$module = mysql_real_escape_string($get['module']);
// echo '<pre>'; print_r($get); die();
if ($module == 'profile') {
$output = $this->_list_profiles($get);
} elseif ($module == 'group') {
$output = $this->_list_groups($get);
} elseif ($module == 'member') {
$output = $this->_list_members($get);
} elseif ($module == 'category') {
$output = $this->_list_category($get);
} else {
if (!isset($get['uid'])) {
$this->print_error(array("status" => "error", "response" => "Undefined uid."));
}
$uid = mysql_real_escape_string($get['uid']);
$page = !isset($get['page']) || !$get['page'] ? 1 : mysql_real_escape_string(urldecode($get['page']));
$limit = !isset($get['limit']) || !$get['limit'] ? 5 : mysql_real_escape_string(urldecode($get['limit']));
/*if($get['module'] == 'all') {
//money total
$sql="select sum(amount) as ttl_expense from m_money e
where e.`uid`=$uid limit $page,$limit";
$rslt = mysql_query($sql,$linkid) or $this->print_error(mysql_error($linkid));
$row = mysql_fetch_array($rslt);
$output['expense_total'] = $row['ttl_expense'];
//reminders
//===============
$time = time();
$cond = ' AND r.remind_time > '.$time;
//===============
$sql = "select c.content_id,r.reminder_id,r.remind_time,r.reminder_name,r.visibility from tbl_reminders r
join m_content c on c.content_id=r.content_id
WHERE r.`uid`='$uid' $cond order by r.remind_time ASC limit $page,$limit";
$rslt = mysql_query($sql,$linkid) or $this->print_error(mysql_error($linkid));
$i=0;
while ($row=mysql_fetch_array($rslt)) {
$data_array[$i]['content_id'] = $row['content_id'];
$data_array[$i]['reminder_id'] = $row['reminder_id'];
$data_array[$i]['reminder_name'] = $this->format_text($row['reminder_name']);
$data_array[$i]['visibility'] = $row['visibility'];
$data_array[$i]['remind_time'] = date("Y-m-d H:i:s",$row['remind_time']);
$i++;
}
$output['reminders'] = $data_array;
//Notes
$sql="select c.content_id,n.note_id,n.note_text,n.visibility,date_format(from_unixtime(c.timestamp),'%b %d, %Y at %h:%i %p') as created_on,fl.file_url,fl.file_type,gp.name,gp.img_url
from tbl_notes n
join m_content c on c.content_id=n.content_id
left join tbl_files fl on fl.file_id = n.file_id
join generic_profile gp on gp.uid = c.uid
where n.`uid`='$uid' order by n.note_id desc limit $page,$limit";
$rslt = mysql_query($sql,$linkid) or $this->print_error(mysql_error($linkid));
$i=0;$data_array=array();
while ($row=mysql_fetch_array($rslt)) {
$data_array[$i]['content_id'] = $row['content_id'];
$data_array[$i]['note_id'] = $row['note_id'];
$data_array[$i]['note_text'] = $this->format_text($row['note_text']);
$data_array[$i]['visibility'] = $row['visibility'];
//$data_array[$i]['timestamp'] = date("Y-m-d H:i:s",$row['timestamp']);
$data_array[$i]['author_name'] = $row['name'];
$data_array[$i]['author_img_url'] = $row['img_url'];
$data_array[$i]['author_created_on'] = $row['created_on'];
//$size=300;$crop=TRUE;
$data_array[$i]['file_url'] = $row['file_url'];//$this->image_serving_url($row['file_url'],$size,$crop,$row['file_type']);
$data_array[$i]['media_type'] = $this->get_file_type($row['file_type']);
$i++;
}
$output['notes'] = $data_array;
// Shoppinglist
$sql = "select c.content_id,sl.shop_list_item_id,sl.item_name,sl.item_qty,sl.shopping_status,sl.units,c.visibility,c.timestamp
from tbl_shoppinglist sl
join m_content c on c.content_id=sl.content_id
where sl.`uid`='$uid' order by sl.shop_list_item_id desc limit $page,$limit";
$rslt = mysql_query($sql,$linkid) or $this->print_error(mysql_error($linkid));
$i=0;$data_array=array();
while ($row=mysql_fetch_array($rslt)) {
$data_array[$i]['content_id'] = $row['content_id'];
$data_array[$i]['shop_list_item_id'] = $row['shop_list_item_id'];
$data_array[$i]['item_name'] = $this->format_text($row['item_name']);
$data_array[$i]['visibility'] = $row['visibility'];
$data_array[$i]['timestamp'] = date("Y-m-d H:i:s",$row['timestamp']);
$data_array[$i]['item_qty'] = $this->format_text($row['item_qty']);
$data_array[$i]['shopping_status'] = $this->format_text($row['shopping_status']);
$data_array[$i]['units'] = $this->format_text($row['units']);
$i++;
}
$output['shoppinglist'] = $data_array;
}
else*/
if ($get['module'] == 'note') {
$rslt = mysql_query("select c.content_id,n.note_id,n.note_text,n.visibility,c.timestamp from tbl_notes n\n\t\t\t\t\t join m_content c on c.content_id=n.content_id\n\t\t\t\t\t where n.`uid`='{$uid}' order by n.note_id desc limit {$page},{$limit}", $linkid) or $this->print_error(mysql_error($linkid));
$i = 0;
$data_array = array();
while ($row = mysql_fetch_array($rslt)) {
$data_array[$i]['content_id'] = $row['content_id'];
$data_array[$i]['note_id'] = $row['note_id'];
$data_array[$i]['note_text'] = $this->format_text($row['note_text']);
$data_array[$i]['visibility'] = $row['visibility'];
$data_array[$i]['timestamp'] = date("Y-m-d H:i:s", $row['timestamp']);
$i++;
}
$output['notes'] = $data_array;
} elseif ($get['module'] == 'money') {
//money total
/*$rslt = mysql_query("select sum(money_amount) as ttl_expense from m_money
where `uid`=$uid limit $page,$limit",$linkid) or $this->print_error(mysql_error($linkid));
$row = mysql_fetch_array($rslt);
$output['expense_total'] = $row['ttl_expense'];
// $output['currency'] = $row['currency'];
if($get['filter_type']=='time') {
if(!isset($get['filter_from'])) $this->print_error(array("status"=>"error","response"=>"Please specify filter from."));
//if(!isset($get['filter_to'])) $this->print_error(array("status"=>"error","response"=>"Please specify filter to."));
$from= strtotime(urldecode($get['filter_from']));
$to= isset($get['filter_to'])? strtotime(urldecode($get['filter_to'])) : time();
$cond .= ' and c.timestamp between '.$from.' and '.$to.' ';
}*/
/*$filter_from_str = urlencode(strtolower($get['filter_from']));
if($get['filter_type']=='value') {
$cond = ' and e.title like "%'.$filter_from_str.'%" or e.desc like "%'.$filter_from_str.'%" ';
}*/
/*$sql="select * from m_money e
join m_content c on c.content_id=e.content_id
where e.uid='$uid' $cond
order by c.timestamp asc
limit $page,$limit";
$rslt = mysql_query($sql,$linkid) or $this->print_error($sql.''.mysql_error($linkid));
if(mysql_errno($linkid)) {
$this->print_error(mysql_error($linkid));
}
else {
$i=0;$data_array=array();
while($row = mysql_fetch_assoc($rslt)) {
$month=date("M",$row['timestamp']);
// $data_array[$month][$i]['expense_id']=$row['expense_id'];
// $data_array[$month][$i]['content_id']=$row['content_id'];
// $data_array[$month][$i]['expense_title']=$row['title'];
// $data_array[$month][$i]['expense_amount']=$row['amount'];
// $data_array[$month]['month_total']+=$row['amount'];
$data_array[$i]['expense_id']=$row['expense_id'];
$data_array[$i]['content_id']=$row['content_id'];
$data_array[$i]['expense_title']=$row['title'];
$data_array[$i]['expense_amount']=$row['amount'];
$data_array[$i]['month']=date("M",$row['timestamp']);;
// $data_array[$i]['visibility']=$row['visibility'];
// $data_array[$i]['currency']=$row['currency'];
// $data_array[$month]['month_total']+=$row['amount'];
$i++;
}
$output['expenses'] = $data_array;
}*/
///======================
$cond = '';
if (!isset($get['uid'])) {
$this->print_error(array("status" => "error", "response" => "Undefined uid."));
}
if (!isset($get['tff'])) {
$this->print_error(array("status" => "error", "response" => "Please specify time filter from."));
}
if (!isset($get['tft'])) {
$this->print_error(array("status" => "error", "response" => "Please specify time filter to."));
}
$group_id = !isset($get['group_id']) || !$get['group_id'] ? '' : mysql_real_escape_string(urldecode($get['group_id']));
$category_id = !isset($get['category_id']) || !$get['category_id'] ? '' : mysql_real_escape_string(urldecode($get['category_id']));
$uid = mysql_real_escape_string(urldecode($get['uid']));
$q = !isset($get['q']) || !$get['q'] ? '' : mysql_real_escape_string(urldecode($get['q']));
if ($q != '') {
$cond .= " AND (m.money_title LIKE '%" . $q . "%')";
}
if ($group_id != '') {
$cond .= " AND m.group_id = '{$group_id}'";
}
if ($category_id != '') {
$cond .= " AND m.category_id = '{$category_id}'";
}
$dt_from = $this->validate_datetime(urldecode($get['tff']), 'from');
$dt_to = $this->validate_datetime(urldecode($get['tft']), 'to');
$tff = isset($get['tff']) ? $dt_from : date("Y-m-d", time() - 60 * 60 * 24 * 30);
//strtotime
$tft = isset($get['tft']) ? $dt_to : date("Y-m-d", time());
$cond .= " and (m.timestamp) between '" . $tff . "' and '" . $tft . "' ";
//========TOTAL QRY======
$sql = "SELECT * FROM m_money m\n\t\t\t\t\t WHERE m.uid='" . $uid . "' {$cond}\n\t\t\t\t\t ORDER BY m.sno DESC";
//ORDER BY m.timestamp desc
$ttl_rslt = mysql_query($sql, $linkid) or $this->print_error(mysql_error($linkid));
$num_rows = mysql_num_rows($ttl_rslt);
$output['total_rows'] = $num_rows;
//==============
$start_row = 0;
if ($num_rows > $limit) {
//=============< Pagination Class>==============
$paginacion = new Paginacion($limit);
//MAX_RECORDS_X_PAGE
$paginacion->setTotalRegs($num_rows);
//count($data)
$paginacion->setCurrentPage($page - 1);
// SET THE CURRENT PAGE
//=============< Pagination Class>==============
// $output['getTotalRegs']=$paginacion->getTotalRegs();
$getTotalPages = $output['pages'] = $paginacion->getTotalPages();
$start_row = $output['start_row'] = $paginacion->getStartRow();
//$output['end_row']=$paginacion->getLastRow();
$output['current_page'] = $paginacion->getCurrentPage() + 1;
if ($paginacion->getCurrentPage() - 1 > -1) {
$output['prev_page'] = $paginacion->getCurrentPage();
}
$p_next = $paginacion->getCurrentPage() + 2;
if ($getTotalPages >= $p_next) {
$output['next_page'] = $p_next;
}
}
$sql = $sql . " LIMIT {$start_row},{$limit}";
// echo '<pre>'.$sql;
$rslt = mysql_query($sql, $linkid) or $this->print_error(mysql_error($linkid));
if (mysql_errno($linkid)) {
$this->print_error(mysql_error($linkid));
} elseif (mysql_num_rows($rslt) == 0) {
$output['response'] = "No items found.";
$this->print_error($output);
} else {
$num_rows = mysql_num_rows($rslt);
$output['num_rows'] = $num_rows;
$i = 0;
$data_array = array();
while ($row = mysql_fetch_assoc($rslt)) {
$data_array[$i]['sno'] = $page + $i;
$data_array[$i]['money_id'] = $row['money_id'];
$data_array[$i]['uid'] = $row['uid'];
$data_array[$i]['lat'] = $row['lat'];
$data_array[$i]['long'] = $row['long'];
$data_array[$i]['visibility'] = $row['visibility'];
$data_array[$i]['money_title'] = $this->format_text($row['money_title']);
$data_array[$i]['money_amount'] = $row['money_amount'];
$data_array[$i]['item_unit_price'] = $row['item_unit_price'];
$data_array[$i]['item_units'] = $row['item_units'];
$data_array[$i]['item_qty'] = $row['item_qty'];
$data_array[$i]['total_price'] = $row['total_price'];
$data_array[$i]['money_flow_direction'] = $row['money_flow_direction'];
$data_array[$i]['file_id'] = $row['file_id'];
$data_array[$i]['category_id'] = $row['category_id'];
$data_array[$i]['modified_on'] = $row['modified_on'];
$data_array[$i]['timestamp'] = $row['timestamp'];
$data_array[$i]['group_id'] = $row['group_id'];
//=========
$month = date("M", strtotime($row['timestamp']));
$tmstmp = strtotime(date("Y-m-d", strtotime($row['timestamp'])));
$quarter_start_dt = $this->this_quarter();
if (strtotime('today') == $tmstmp) {
$data_array[$i]['time_string'] = 'today';
} elseif (strtotime('yesterday') == $tmstmp) {
$data_array[$i]['time_string'] = 'yesterday';
} elseif (strtotime('-1 week') <= $tmstmp) {
$data_array[$i]['time_string'] = 'this_week';
} elseif (strtotime(date("Y-m-1", time())) < $tmstmp) {
$data_array[$i]['time_string'] = 'this_month';
} elseif ($quarter_start_dt < $tmstmp) {
$data_array[$i]['time_string'] = 'this_quarter';
} elseif (strtotime(date("Y-01-01", time())) < $tmstmp) {
$data_array[$i]['time_string'] = 'this_year';
} else {
$data_array[$i]['time_string'] = 'last_year';
}
// $data_array[$i]['month']=$month;
// $data_array[$month]['month_total']+=$row['money_amount'];
++$i;
}
$output['status'] = 'success';
$output['money'] = $data_array;
}
///========================
} elseif ($get['module'] == 'reminder') {
$rslt = mysql_query("select c.content_id,r.reminder_id,r.remind_time,r.reminder_name,r.visibility from tbl_reminders r\n\t\t\t join m_content c on c.content_id=r.content_id\n\t\t\t where r.`uid`='{$uid}' order by r.remind_time ASC limit {$page},{$limit}", $linkid) or $this->print_error(mysql_error($linkid));
$i = 0;
while ($row = mysql_fetch_array($rslt)) {
$data_array[$i]['content_id'] = $row['content_id'];
$data_array[$i]['reminder_id'] = $row['reminder_id'];
$data_array[$i]['reminder_name'] = $this->format_text($row['reminder_name']);
$data_array[$i]['visibility'] = $row['visibility'];
$data_array[$i]['remind_time'] = date("Y-m-d H:i:s", $row['remind_time']);
$i++;
}
$output['reminders'] = $data_array;
} elseif ($get['module'] == 'shoppinglist') {
// Shoppinglist
$sql = "select c.content_id,sl.shop_list_item_id,sl.item_name,sl.item_qty,sl.units,sl.shopping_status,c.visibility,c.timestamp\n\t\t\t\t\t from tbl_shoppinglist sl\n\t\t\t\t\t join m_content c on c.content_id=sl.content_id\n\t\t\t\t\t where sl.`uid`='{$uid}' order by sl.shop_list_item_id desc limit {$page},{$limit}";
$rslt = mysql_query($sql, $linkid) or $this->print_error(mysql_error($linkid));
$i = 0;
$data_array = array();
while ($row = mysql_fetch_array($rslt)) {
$data_array[$i]['content_id'] = $row['content_id'];
$data_array[$i]['shop_list_item_id'] = $row['shop_list_item_id'];
$data_array[$i]['item_name'] = $this->format_text($row['item_name']);
$data_array[$i]['visibility'] = $row['visibility'];
$data_array[$i]['timestamp'] = date("Y-m-d H:i:s", $row['timestamp']);
$data_array[$i]['item_qty'] = $this->format_text($row['item_qty']);
$data_array[$i]['shopping_status'] = $this->format_text($row['shopping_status']);
$data_array[$i]['units'] = $this->format_text($row['units']);
$i++;
}
//$output['lst_qry'] = $sql;
$output['shoppinglist'] = $data_array;
} else {
$output = $this->unknown();
}
}
return $output;
}
