public function index() { $memid = $_SESSION["MEMBER_id"]; $DbPre = C('DB_PREFIX'); //个人信息 $user_info = M('Members')->where("ID=" . $memid)->find(); $this->assign('user_info', $user_info); //收藏记录 $sql = 'select b.* from ' . $DbPre . 'topic_collect a left join ' . $DbPre . 'topic b using(topic_id) where user_id=' . $memid . ' order by a.collect_time'; $collection = M()->query($sql); $this->assign('collect', $collection); //账号绑定 $OauthMember = M('OauthMember'); $lock['qq'] = $OauthMember->where("status=1 and _from='qq' and lock_to_id=" . $memid)->count(); $lock['sina'] = $OauthMember->where("status=1 and _from='sina' and lock_to_id=" . $memid)->count(); $this->assign('lock', $lock); //消息列表 $this->assign('mesComment', $count1 = getMes($memid, 'topic_comment')); $this->assign('mesAnswer', $count2 = getMes($memid, 'topic_answer')); $this->assign('mesCollect', $count3 = getMes($memid, 'topic_collect')); $this->assign('mesCount', intval($count1 && count($count1)) + intval($count2 && count($count2)) + intval($count3 && count($count3))); $this->display(':center'); }
function get_an_column_history($id_interest, $id_country, $last_update, $days) { $sql = "SELECT total_user, date \n FROM " . DB_FACEBOOK_PREFIX . "record_country_interest_3_1\n WHERE id_country = \$1\n AND id_interest = \$2\n AND DATE_SUB(STR_TO_DATE('\$3', '%Y-%m-%d'),INTERVAL \$4 DAY) <= date\n ORDER BY 2 ASC;\n "; $que = db_query($sql, array($id_country, $id_interest, $last_update, $days)); $seriesData = array(); //Estadística vertical. Cantidad de usuarios que posee en Facebook $seriesDataMin = 0; //Número mínimo de usuarios $seriesDataMax = 0; //Número máximo de usuarios $xAxisCategories = array(); //Estadística horizontal. Fechas de los datos $ban = 1; //Bandera $cont = 1; $_num_rango = 3; $_num_discard = mysql_num_rows($que) - $_num_rango * floor(mysql_num_rows($que) / $_num_rango); while ($fila = mysql_fetch_assoc($que)) { if ($_num_discard-- > 0) { continue; } if ($cont % $_num_rango == 0) { //Formatear fecha $auxformat = explode("-", $fila['date']); $dia = $auxformat[2]; $mes = getMes($auxformat[1], 'short'); $year = $semister_year = substr($auxformat[0], 2, 2); $seriesData[] = $fila['total_user']; $xAxisCategories[] = "'" . $dia . " " . $mes . "'"; if ($ban == 1) { $seriesDataMin = $fila['total_user']; $seriesDataMax = $fila['total_user']; $ban = 0; } else { if ($fila['total_user'] < $seriesDataMin) { $seriesDataMin = $fila['total_user']; } else { if ($fila['total_user'] > $seriesDataMax) { $seriesDataMax = $fila['total_user']; } } } } $cont++; } return array('series_data' => implode(',', $seriesData), 'series_data_min' => $seriesDataMin, 'series_data_max' => $seriesDataMax, 'x_axis' => implode(',', $xAxisCategories)); }
function owloo_format_date($fecha) { $auxformat = explode("-", $fecha); $dia = $auxformat[2]; $mes = getMes($auxformat[1], 'short'); $anho = $auxformat[0]; return $dia . '-' . $mes . '-' . $anho; }
$qry = $qry . " FROM owoo_tweet_data"; $qry = $qry . " WHERE owloo_user_id = '" . $update_id . "' AND owloo_tweet_date >= '" . get_twitter_date_30_day($update_id, 'owoo_tweet_data', 'owloo_user_id', 'owloo_tweet_date') . "'"; $qry = $qry . " group by owloo_tweet_date, owloo_user_id"; $qry = $qry . " Order by owloo_tweet_date Desc"; $qry = $qry . " Limit 0, 30) T Order by owloo_tweet_date ASC "; $qrydata = mysql_query($qry); $valoverall = ''; $xAxisCategories = ""; $seriesDataMin = 0; $seriesDataMax = 0; $ban = 1; while ($fetchdata = mysql_fetch_array($qrydata)) { //Formatear fecha $auxformat = explode("-", $fetchdata['owloo_tweet_date']); $dia = $auxformat[2]; $mes = getMes($auxformat[1], 'short'); if ($ban == 1) { $valoverall .= $fetchdata["count"]; $xAxisCategories .= "'" . $dia . " " . $mes . "'"; $seriesDataMin = $fetchdata["count"]; $seriesDataMax = $fetchdata["count"]; $ban = 0; } else { $valoverall .= ',' . $fetchdata["count"]; $xAxisCategories .= ",'" . $dia . " " . $mes . "'"; if ($fetchdata["count"] < $seriesDataMin) { $seriesDataMin = $fetchdata["count"]; } else { if ($fetchdata["count"] > $seriesDataMax) { $seriesDataMax = $fetchdata["count"]; }
function getKloutHistory30Array($id_profile) { $current_klout_data = NULL; $qry = $qry . " SELECT * "; $qry = $qry . " FROM " . DB_TWITTER_PREFIX . "klout_tw_data_record"; $qry = $qry . " WHERE owloo_user_id = \$1"; $qry = $qry . " ORDER BY date ASC"; $qry = $qry . " LIMIT 1"; $que = db_query_tw($qry, array($id_profile)); if ($fila = mysql_fetch_assoc($que)) { $current_klout_data['score'] = owlooFormatPorcent($fila['score'], NULL, 3, '.', ''); $current_klout_data['day_change'] = owlooFormatPorcent($fila['day_change']); $current_klout_data['week_change'] = owlooFormatPorcent($fila['week_change']); $current_klout_data['month_change'] = owlooFormatPorcent($fila['month_change']); $current_klout_data['bucket'] = $fila['bucket']; } else { return array(); } $qry = ""; $qry = $qry . " SELECT score, date"; $qry = $qry . " FROM " . DB_TWITTER_PREFIX . "klout_tw_data_record"; $qry = $qry . " WHERE owloo_user_id = \$1"; $qry = $qry . " ORDER BY date ASC"; $qry = $qry . " LIMIT 0 , 30"; $que = db_query_tw($qry, array($id_profile)); $seriesData = array(); //Estadística vertical. Cantidad de seguidores $seriesDataMin = 0; //Número mínimo de seguidores $seriesDataMax = 0; //Número máximo de seguidores $xAxisCategories = array(); //Estadística horizontal. Fechas de los datos $ban = 1; //Bandera $cont_num_data = mysql_num_rows($que); while ($fila = mysql_fetch_assoc($que)) { //Formatear fecha $auxformat = explode("-", $fila['date']); $dia = $auxformat[2]; $mes = getMes($auxformat[1], 'short'); $year = $semister_year = substr($auxformat[0], 2, 2); $score = owlooFormatPorcent($fila['score']); $seriesData[] = $score; $xAxisCategories[] = $dia . ' ' . $mes . ' ' . $year; if ($ban == 1) { $seriesDataMin = $score; $seriesDataMax = $score; $ban = 0; } else { if ($score < $seriesDataMin) { $seriesDataMin = $score; } else { if ($score > $seriesDataMax) { $seriesDataMax = $score; } } } } return array('series_data' => implode(',', $seriesData), 'series_data_min' => $seriesDataMin, 'series_data_max' => $seriesDataMax, 'x_axis' => implode(',', $xAxisCategories), 'current_klout_data' => $current_klout_data); }
function getHistory30Array($id_page, $fb_page_likes_last_update) { $sql = 'SELECT likes, talking_about, date FROM facebook_pages_likes_talking_about WHERE id_page = $1 AND DATE_SUB(STR_TO_DATE(\'$2\', \'%Y-%m-%d\'),INTERVAL 30 DAY) <= date ORDER BY date ASC; '; $que = db_query($sql, array($id_page, $fb_page_likes_last_update)); $seriesData = ""; //Estadística vertical. Cantidad de usuarios que posee en Facebook $seriesData_talking_about = ""; //Estadística vertical. Cantidad de usuarios que posee en Facebook $seriesDataMin = 0; //Número mínimo de usuarios $seriesDataMax = 0; //Número máximo de usuarios $seriesDataMin_talking_about = 0; //Número mínimo de usuarios $seriesDataMax_talking_about = 0; //Número máximo de usuarios $xAxisCategories = ""; //Estadística horizontal. Fechas de los datos $ban = 1; //Bandera $cont = 1; $_num_rango = 1; $_num_discard = mysql_num_rows($que) - $_num_rango * floor(mysql_num_rows($que) / $_num_rango); while ($fila = mysql_fetch_assoc($que)) { if ($_num_discard-- > 0) { continue; } if ($cont % $_num_rango == 0) { //Formatear fecha $auxformat = explode("-", $fila['date']); $dia = $auxformat[2]; $mes = getMes($auxformat[1], 'short'); if ($ban == 1) { $seriesData .= $fila['likes']; $seriesData_talking_about .= $fila['talking_about']; $xAxisCategories .= "'" . $dia . " " . $mes . "'"; $seriesDataMin = $fila['likes']; $seriesDataMax = $fila['likes']; $seriesDataMin_talking_about = $fila['talking_about']; $seriesDataMax_talking_about = $fila['talking_about']; $ban = 0; } else { $seriesData .= ',' . $fila['likes']; $seriesData_talking_about .= ',' . $fila['talking_about']; $xAxisCategories .= ",'" . $dia . " " . $mes . "'"; if ($fila['likes'] < $seriesDataMin) { $seriesDataMin = $fila['likes']; } else { if ($fila['likes'] > $seriesDataMax) { $seriesDataMax = $fila['likes']; } } if ($fila['talking_about'] < $seriesDataMin_talking_about) { $seriesDataMin_talking_about = $fila['talking_about']; } else { if ($fila['talking_about'] > $seriesDataMax_talking_about) { $seriesDataMax_talking_about = $fila['talking_about']; } } } } $cont++; } $step_1 = 1; if ($cont - 1 > 11) { $step_1 = 2; } if ($cont - 1 > 21) { $step_1 = 3; } $likes = array('series_data' => $seriesData, 'series_data_min' => $seriesDataMin, 'series_data_max' => $seriesDataMax, 'x_axis' => $xAxisCategories, 'step' => $step_1); $talking_about = array('series_data' => $seriesData_talking_about, 'series_data_min' => $seriesDataMin_talking_about, 'series_data_max' => $seriesDataMax_talking_about, 'x_axis' => $xAxisCategories, 'step' => $step_1); return array('likes' => $likes, 'talking_about' => $talking_about); }
// $fechaFin = $fecha." 23:59:59"; $fechaInicio = "2016-04-05 00:00:00"; $fechaFin = "2016-04-05 23:59:59"; $formatEnv = "Y-m-d"; $fechaEnv = date($formatEnv, $timestamp); $body = ""; $diaSemForm = "N"; $mesForm = "n"; $diaForm = "j"; $anioForm = "Y"; $diaSemEnvio = date($diaSemForm, $timestamp); $mesEnvio = date($mesForm, $timestamp); $diaEnvio = date($diaForm, $timestamp); $anioEnvio = date($anioForm, $timestamp); $diaSemana = getDia($diaSemEnvio); $mes = getMes($mesEnvio); $seleccionar = consultaNoticiasEnvio($fechaInicio, $fechaFin); $fueNombreAnterior = ""; /* foreach ($seleccionar as $valor) { $fueNombre= $valor['fueNombre']; $notTitulo= $valor['notTitulo']; $notContenido= $valor['notContenido']; $notAutor= $valor['notAutor']; $notEnlace= $valor['notEnlace']; echo $fueNombre; $fuenteIgual = strcmp ( $fueNombre , $fueNombreAnterior ); if ($fuenteIgual == 0) { $mostrarFuente = ""; } else {
break; case "11": return "NOV"; break; case "12": return "DIC"; break; } } if (!isset($_REQUEST["d"])) $_REQUEST["d"] = date("d/m"); $dia = intval(substr($_REQUEST["d"], 0, 2)); $mes = intval(substr($_REQUEST["d"], 3, 2)); if ($dia < 10) $left = 22; else $left = 17; $im = imagecreatefromjpeg($_SERVER["DOCUMENT_ROOT"]."/images/home_cal.jpg"); $color = imagecolorallocate($im, 255, 255, 255); $fuente = "NeoSan copy.ttf"; imagettftext($im, 7, 0, getLeftMes($mes), 24, $color, $fuente, getMes($mes)); imagettftext($im, 12, 0, $left, 39, $color, $fuente, $dia); imagejpeg($im); imagedestroy($im); ?>
function getHistory30Array($id_profile) { $qry = ""; $qry = $qry . " SELECT media, followed_by, follows, date"; $qry = $qry . " FROM " . DB_INSTAGRAM_PREFIX . "record"; $qry = $qry . " WHERE id_profile = \$1 AND date >= '" . get_instagram_date_for_days($id_profile, 30) . "'"; $qry = $qry . " ORDER BY date ASC , followed_by DESC"; $qry = $qry . " LIMIT 0 , 35"; $que = db_query($qry, array($id_profile)); $_followers_valor_anterior = -1; $_followers_suma_crecimiento = 0; $_following_valor_anterior = -1; $_following_suma_crecimiento = 0; $_count_suma_crecimiento = 0; $accumulate_down = 0; $seriesData = array(); //Estadística vertical. Cantidad de seguidores $seriesDataMin = NULL; //Número mínimo de seguidores $seriesDataMax = NULL; //Número máximo de seguidores $xAxisCategories = array(); //Estadística horizontal. Fechas de los datos $daily_followers_grow_seriesData = array(); //Estadística vertical. Cantidad de seguidores $daily_followers_grow_seriesDataMin = NULL; //Número mínimo de seguidores $daily_followers_grow_seriesDataMax = NULL; //Número máximo de seguidores $daily_followers_grow_xAxisCategories = array(); //Estadística horizontal. Fechas de los datos $daily_following_grow_seriesData = array(); //Estadística vertical. Cantidad de seguidores $daily_following_grow_seriesDataMin = NULL; //Número mínimo de seguidores $daily_following_grow_seriesDataMax = NULL; //Número máximo de seguidores $daily_following_grow_xAxisCategories = array(); //Estadística horizontal. Fechas de los datos $ban = 1; //Bandera $cont_num_data = mysql_num_rows($que); while ($fila = mysql_fetch_assoc($que)) { //Formatear fecha $auxformat = explode("-", $fila['date']); $dia = $auxformat[2]; $mes = getMes($auxformat[1], 'short'); $year = substr($auxformat[0], 2, 2); $seriesData[] = $fila['followed_by']; $xAxisCategories[] = $dia . ' ' . $mes . ' ' . $year; if ($ban == 1) { $seriesDataMin = $fila['followed_by']; $seriesDataMax = $fila['followed_by']; $_followers_valor_anterior = $fila['followed_by']; $_following_valor_anterior = $fila['follows']; $ban = 0; } else { if ($fila['followed_by'] < $seriesDataMin) { $seriesDataMin = $fila['followed_by']; } else { if ($fila['followed_by'] > $seriesDataMax) { $seriesDataMax = $fila['followed_by']; } } if ($fila['followed_by'] - $_followers_valor_anterior < 0) { $accumulate_down += $_followers_valor_anterior - $fila['followed_by']; } $followers_daily_grow = $fila['followed_by'] - $_followers_valor_anterior; $following_daily_grow = $fila['follows'] - $_following_valor_anterior; $daily_followers_grow_seriesData[] = $followers_daily_grow; $daily_followers_grow_xAxisCategories[] = $dia . ' ' . $mes . ' ' . $year; $daily_following_grow_seriesData[] = $following_daily_grow; $daily_following_grow_xAxisCategories[] = $dia . ' ' . $mes . ' ' . $year; if (count($daily_followers_grow_seriesData) == 1) { //Primera vez $daily_followers_grow_seriesDataMin = $followers_daily_grow; $daily_followers_grow_seriesDataMax = $followers_daily_grow; $daily_following_grow_seriesDataMin = $following_daily_grow; $daily_following_grow_seriesDataMax = $following_daily_grow; } else { if ($followers_daily_grow < $daily_followers_grow_seriesDataMin) { $daily_followers_grow_seriesDataMin = $followers_daily_grow; } else { if ($followers_daily_grow > $daily_followers_grow_seriesDataMax) { $daily_followers_grow_seriesDataMax = $followers_daily_grow; } } if ($following_daily_grow < $daily_following_grow_seriesDataMin) { $daily_following_grow_seriesDataMin = $following_daily_grow; } else { if ($following_daily_grow > $daily_following_grow_seriesDataMax) { $daily_following_grow_seriesDataMax = $following_daily_grow; } } } $_followers_suma_crecimiento += $followers_daily_grow; $_following_suma_crecimiento += $following_daily_grow; $_count_suma_crecimiento++; $_followers_valor_anterior = $fila['followed_by']; $_following_valor_anterior = $fila['follows']; } } $average_growth = array('followers' => NULL, 'following' => NULL); if ($_count_suma_crecimiento > 0) { $average_growth = array('followers' => owlooFormatPorcent($_followers_suma_crecimiento / $_count_suma_crecimiento), 'following' => owlooFormatPorcent($_following_suma_crecimiento / $_count_suma_crecimiento)); } return array('followers' => array('series_data' => implode(',', $seriesData), 'series_data_min' => $seriesDataMin, 'series_data_max' => $seriesDataMax, 'x_axis' => implode(',', $xAxisCategories), 'accumulate_down' => $accumulate_down), 'daily_followers_grow' => array('series_data' => implode(',', $daily_followers_grow_seriesData), 'x_axis' => implode(',', $daily_followers_grow_xAxisCategories), 'min_change_of_followers_on' => $daily_followers_grow_seriesDataMin, 'max_change_of_followers_on' => $daily_followers_grow_seriesDataMax, 'avg_change_per_day' => $average_growth['followers']), 'daily_following_grow' => array('series_data' => implode(',', $daily_following_grow_seriesData), 'x_axis' => implode(',', $daily_following_grow_xAxisCategories), 'min_change_of_following_on' => $daily_following_grow_seriesDataMin, 'max_change_of_following_on' => $daily_following_grow_seriesDataMax, 'avg_change_per_day' => $average_growth['following'])); }
function getHistory30Array($id_page, $fb_page_likes_last_update) { $sql = 'SELECT likes, talking_about, date FROM ' . DB_FACEBOOK_PREFIX . 'pages_likes_talking_about WHERE id_page = $1 AND DATE_SUB(STR_TO_DATE(\'$2\', \'%Y-%m-%d\'),INTERVAL 30 DAY) <= date ORDER BY date ASC; '; $que = db_query($sql, array($id_page, $fb_page_likes_last_update)); $_likes_valor_anterior = -1; $_likes_suma_crecimiento = 0; $_count_suma_crecimiento = 0; $accumulate_down = 0; $seriesData = array(); //Estadística vertical. Cantidad de usuarios que posee en Facebook $seriesData_talking_about = array(); //Estadística vertical. Cantidad de usuarios que posee en Facebook $seriesDataMin = NULL; //Número mínimo de usuarios $seriesDataMax = NULL; //Número máximo de usuarios $seriesDataMin_talking_about = NULL; //Número mínimo de usuarios $seriesDataMax_talking_about = NULL; //Número máximo de usuarios $xAxisCategories = array(); //Estadística horizontal. Fechas de los datos $daily_likes_grow_seriesData = array(); //Estadística vertical. Cantidad de seguidores $daily_likes_grow_seriesDataMin = NULL; //Número mínimo de seguidores $daily_likes_grow_seriesDataMax = NULL; //Número máximo de seguidores $daily_likes_grow_xAxisCategories = array(); //Estadística horizontal. Fechas de los datos $ban = 1; //Bandera $cont = 1; $_num_rango = 1; $_num_discard = mysql_num_rows($que) - $_num_rango * floor(mysql_num_rows($que) / $_num_rango); while ($fila = mysql_fetch_assoc($que)) { if ($_num_discard-- > 0) { continue; } if ($cont % $_num_rango == 0) { //Formatear fecha $auxformat = explode("-", $fila['date']); $dia = $auxformat[2]; $mes = getMes($auxformat[1], 'short'); $year = substr($auxformat[0], 2, 2); $fila['talking_about'] = owlooFormatPorcent($fila['talking_about'], $fila['likes'], 2, '.', ''); $seriesData[] = $fila['likes']; $seriesData_talking_about[] = $fila['talking_about']; $xAxisCategories[] = $dia . ' ' . $mes . ' ' . $year; if ($ban == 1) { $seriesDataMin = $fila['likes']; $seriesDataMax = $fila['likes']; $seriesDataMin_talking_about = $fila['talking_about']; $seriesDataMax_talking_about = $fila['talking_about']; $_likes_valor_anterior = $fila['likes']; $ban = 0; } else { if ($fila['likes'] < $seriesDataMin) { $seriesDataMin = $fila['likes']; } else { if ($fila['likes'] > $seriesDataMax) { $seriesDataMax = $fila['likes']; } } if ($fila['talking_about'] < $seriesDataMin_talking_about) { $seriesDataMin_talking_about = $fila['talking_about']; } else { if ($fila['talking_about'] > $seriesDataMax_talking_about) { $seriesDataMax_talking_about = $fila['talking_about']; } } $likes_daily_grow = $fila['likes'] - $_likes_valor_anterior; $daily_likes_grow_seriesData[] = $likes_daily_grow; $daily_likes_grow_xAxisCategories[] = $dia . ' ' . $mes . ' ' . $year; if (count($daily_likes_grow_seriesData) == 1) { //Primera vez $daily_likes_grow_seriesDataMin = $likes_daily_grow; $daily_likes_grow_seriesDataMax = $likes_daily_grow; } else { if ($likes_daily_grow < $daily_likes_grow_seriesDataMin) { $daily_likes_grow_seriesDataMin = $likes_daily_grow; } else { if ($likes_daily_grow > $daily_likes_grow_seriesDataMax) { $daily_likes_grow_seriesDataMax = $likes_daily_grow; } } } $_likes_suma_crecimiento += $likes_daily_grow; $_count_suma_crecimiento++; $_likes_valor_anterior = $fila['likes']; } } $cont++; } $step_1 = 1; if ($cont - 1 > 11) { $step_1 = 2; } if ($cont - 1 > 21) { $step_1 = 3; } $average_growth_likes = NULL; if ($_count_suma_crecimiento > 0) { $average_growth_likes = owlooFormatPorcent($_likes_suma_crecimiento / $_count_suma_crecimiento, NULL, 2); } $likes = array('series_data' => implode(',', $seriesData), 'series_data_min' => $seriesDataMin, 'series_data_max' => $seriesDataMax, 'x_axis' => implode(',', $xAxisCategories), 'accumulate_down' => $accumulate_down, 'step' => $step_1); $daily_likes_grow = array('series_data' => implode(',', $daily_likes_grow_seriesData), 'x_axis' => implode(',', $daily_likes_grow_xAxisCategories), 'series_data_min' => $daily_likes_grow_seriesDataMin, 'series_data_max' => $daily_likes_grow_seriesDataMax, 'avg_change_per_day' => $average_growth_likes); $talking_about = array('series_data' => implode(',', $seriesData_talking_about), 'series_data_min' => $seriesDataMin_talking_about, 'series_data_max' => $seriesDataMax_talking_about, 'avg_change_per_day' => count($seriesData_talking_about) > 0 ? owlooFormatPorcent(array_sum($seriesData_talking_about) / count($seriesData_talking_about), NULL, 2) : 0, 'x_axis' => implode(',', $xAxisCategories), 'step' => $step_1); return array('likes' => $likes, 'daily_likes_grow' => $daily_likes_grow, 'talking_about' => $talking_about); }
function get_audience_history($id_country, $last_update, $days) { $sql = "SELECT total_user, date \n FROM facebook_record_country_3_1\n WHERE id_country = \$1 \n AND DATE_SUB(STR_TO_DATE('\$2', '%Y-%m-%d'),INTERVAL \$3 DAY) <= date\n ORDER BY 2 ASC;\n "; $que = db_query($sql, array($id_country, $last_update, $days)); $seriesData = ""; //Estadística vertical. Cantidad de usuarios que posee en Facebook $seriesDataMin = 0; //Número mínimo de usuarios $seriesDataMax = 0; //Número máximo de usuarios $xAxisCategories = ""; //Estadística horizontal. Fechas de los datos $ban = 1; //Bandera $cont = 1; $_num_rango = 15; $_num_discard = mysql_num_rows($que) - $_num_rango * floor(mysql_num_rows($que) / $_num_rango); while ($fila = mysql_fetch_assoc($que)) { if ($_num_discard-- > 0) { continue; } if ($cont % $_num_rango == 0) { //Formatear fecha $auxformat = explode("-", $fila['date']); $dia = $auxformat[2]; $mes = getMes($auxformat[1], 'short'); if ($ban == 1) { $seriesData .= $fila['total_user']; $xAxisCategories .= "'" . $dia . " " . $mes . "'"; $seriesDataMin = $fila['total_user']; $seriesDataMax = $fila['total_user']; $ban = 0; } else { $seriesData .= ',' . $fila['total_user']; $xAxisCategories .= ",'" . $dia . " " . $mes . "'"; if ($fila['total_user'] < $seriesDataMin) { $seriesDataMin = $fila['total_user']; } else { if ($fila['total_user'] > $seriesDataMax) { $seriesDataMax = $fila['total_user']; } } } } $cont++; } return array('series_data' => $seriesData, 'series_data_min' => $seriesDataMin, 'series_data_max' => $seriesDataMax, 'x_axis' => $xAxisCategories); }
/** * Generate doc and download. * * @param int $id * @return \Illuminate\Http\Response */ public function download($id) { $poder = Poder::findOrFail($id); $phpWord = new PhpWord(); $template = public_path() . "/download/poderespecial.docx"; $file = public_path() . "/download/" . $poder->id . "-" . $poder->poderante . ".docx"; $download = $phpWord->loadTemplate($template); $d_fecha = new DateTime($poder->fecha); $s_fecha = new DateTime($poder->fecha_siniestro); $download->setValue('dia_fecha', $d_fecha->format("d")); $download->setValue('mes_fecha', getMes($d_fecha->format("m"))); $download->setValue('ano_fecha', trim(valorEnLetras((int) $d_fecha->format("Y")))); $download->setValue('poderante', strtoupper($poder->poderante)); $download->setValue('dni', $poder->dni); $download->setValue('direccion', strtoupper($poder->direccion)); $download->setValue('localidad', $poder->localidad); $download->setValue('demandado', strtoupper($poder->demandado)); $download->setValue('aseguradora', strtoupper($poder->aseguradora)); $download->setValue('fecha_siniestro', $s_fecha->format("d") . "." . $s_fecha->format("m") . "." . $s_fecha->format("Y")); $download->setValue('dominio_siniestro', $poder->dominio_siniestro); $download->setValue('direccion_siniestro', strtoupper($poder->direccion_siniestro)); $download->setValue('localidad', $poder->localidad); $download->saveAs($file); $headers = array('Content-Type: application/docx'); return response()->download($file, $poder->id . "-" . $poder->poderante . ".docx", $headers); }
function getHistory30Array($page_id, $country_id, $fb_page_likes_last_update, $days = 30) { $sql = 'SELECT likes, date FROM ' . DB_FACEBOOK_PREFIX . 'page_local_fans_country WHERE id_page = $1 AND id_country = $2 AND DATE_SUB(STR_TO_DATE(\'$3\', \'%Y-%m-%d\'),INTERVAL $4 DAY) <= date ORDER BY date ASC; '; $que = db_query($sql, array($page_id, $country_id, $fb_page_likes_last_update, $days)); $seriesData = array(); //Estadística vertical. Cantidad de usuarios que posee en Facebook $seriesDataMin = NULL; //Número mínimo de usuarios $seriesDataMax = NULL; //Número máximo de usuarios $xAxisCategories = array(); //Estadística horizontal. Fechas de los datos $ban = 1; //Bandera $cont = 1; $_num_rango = 1; $_num_discard = mysql_num_rows($que) - $_num_rango * floor(mysql_num_rows($que) / $_num_rango); while ($fila = mysql_fetch_assoc($que)) { if ($_num_discard-- > 0) { continue; } if ($cont % $_num_rango == 0) { //Formatear fecha $auxformat = explode("-", $fila['date']); $dia = $auxformat[2]; $mes = getMes($auxformat[1], 'short'); $year = substr($auxformat[0], 2, 2); $seriesData[] = $fila['likes']; $xAxisCategories[] = $dia . ' ' . $mes . ' ' . $year; if ($ban == 1) { $seriesDataMin = $fila['likes']; $seriesDataMax = $fila['likes']; $ban = 0; } else { if ($fila['likes'] < $seriesDataMin) { $seriesDataMin = $fila['likes']; } else { if ($fila['likes'] > $seriesDataMax) { $seriesDataMax = $fila['likes']; } } } } $cont++; } $step_1 = 1; if ($cont - 1 > 11) { $step_1 = 2; } if ($cont - 1 > 21) { $step_1 = 3; } $likes = array('series_data' => implode(',', $seriesData), 'series_data_min' => $seriesDataMin, 'series_data_max' => $seriesDataMax, 'x_axis' => implode(',', $xAxisCategories), 'step' => $step_1); return $likes; }
function dataExtenso($dt) { $da = explode('/', $dt); return $da[0] . ' de ' . getMes($da[1]) . ' de ' . $da[2]; }