/**
* @param FormBuilderInterface $builder
* @param array $options
*/
public function buildForm(FormBuilderInterface $builder, array $options)
{
$colonie = $builder->getData();
$lastDate = $colonie->getDateColonie();
if (!$colonie->getVisites()->isEmpty()) {
$date = $colonie->getVisites()->last()->getDate();
if ($lastDate < $date) {
$lastDate = $date;
}
}
if (!$colonie->getTranshumances()->isEmpty()) {
$date = $colonie->getTranshumances()->last()->getDate();
if ($lastDate < $date) {
$lastDate = $date;
}
}
if (!$colonie->getRecoltes()->isEmpty()) {
$date = $colonie->getRecoltes()->last()->getDate();
if ($lastDate < $date) {
$lastDate = $date;
}
}
if (!$colonie->getRemerages()->isEmpty()) {
$date = $colonie->getRemerages()->last()->getDate();
if ($lastDate < $date) {
$lastDate = $date;
}
}
$startDate = date_add($lastDate, date_interval_create_from_date_string("1 days"));
$startDateFormat = date_format($startDate, "Y-m-d");
$builder->add('dateMort', 'collot_datetime', array('pickerOptions' => array('format' => 'dd/mm/yyyy', 'autoclose' => true, 'startDate' => (string) $startDateFormat, 'endDate' => date("Y-m-d"), 'startView' => 'month', 'minView' => 'month', 'maxView' => 'month', 'todayBtn' => false, 'todayHighlight' => true, 'keyboardNavigation' => true, 'language' => 'fr', 'forceParse' => true, 'pickerReferer ' => 'default', 'pickerPosition' => 'bottom-right', 'viewSelect' => 'month', 'initialDate' => date("Y-m-d")), 'constraints' => new CheckDateMort($colonie), 'read_only' => true, 'attr' => array('input_group' => array('prepend' => '.icon-calendar'))))->add('causes', 'entity', array('class' => 'KGBeekeepingManagementBundle:Cause', 'choice_label' => 'libelle', 'multiple' => true, 'required' => false))->add('autreCause', 'text', array('required' => false, 'constraints' => new CheckCauseMort()));
}
public function indexChef()
{
$filiere = Session::get('user')->filieres[0];
$etudiants_count = Filiere::nbreEtudiantByFiliere($filiere->id);
$enseignants_count = Enseignant::count();
$etudiants = Etudiant::etudiants_plus_3_absences();
$promotions = $filiere->promos;
$promos_count = count($promotions);
$stats_cours = array();
$today = Carbon::now();
$liste = null;
$j = 0;
$absences_count = 0;
if ($promos_count > 0) {
foreach ($promotions as $promotion) {
$absences_count = $absences_count + Filiere::nbreAbsencesByPromo($promotion->id);
}
}
$stats_cours = array();
$today = Carbon::now();
for ($i = 0; $i < 10; $i++) {
$nb = Absence::whereDate('created_at', '=', date("Y-m-d", strtotime($today)))->count();
date_add($today, date_interval_create_from_date_string('-1 days'));
array_push($stats_cours, $nb);
}
return View('app/dashboardChef', ['etudiants_count' => $etudiants_count, 'enseignants_count' => $enseignants_count, 'absences_count' => $absences_count, 'promos_count' => $promos_count, 'etudiants' => $etudiants, 'statistics' => $liste[0], 'promotions' => $promotions, 'filiere' => $filiere, 'statistics' => $stats_cours]);
}
public function depreciated_date()
{
$date = date_create($this->purchase_date);
date_add($date, date_interval_create_from_date_string($this->get_depreciation()->months . ' months'));
return $date;
//date_format($date, 'Y-m-d'); //don't bake-in format, for internationalization
}
function getDates($dayofmonth, $months = 0)
{
$dayofmonth = zeropad($dayofmonth);
$year = date('Y');
$month = date('m');
if (date('d') >= $dayofmonth) {
$date_end = date_create($year . '-' . $month . '-' . $dayofmonth);
$date_start = date_create($year . '-' . $month . '-' . $dayofmonth);
date_add($date_end, date_interval_create_from_date_string('1 月'));
} else {
// Billing day will happen this month, therefore started last month
$date_end = date_create($year . '-' . $month . '-' . $dayofmonth);
$date_start = date_create($year . '-' . $month . '-' . $dayofmonth);
date_sub($date_start, date_interval_create_from_date_string('1 月'));
}
if ($months > 0) {
date_sub($date_start, date_interval_create_from_date_string($months . ' 月'));
date_sub($date_end, date_interval_create_from_date_string($months . ' 月'));
}
# date_sub($date_start, date_interval_create_from_date_string('1 月'));
date_sub($date_end, date_interval_create_from_date_string('1 天'));
$date_from = date_format($date_start, 'Ymd') . "000000";
$date_to = date_format($date_end, 'Ymd') . "235959";
date_sub($date_start, date_interval_create_from_date_string('1 月'));
date_sub($date_end, date_interval_create_from_date_string('1 月'));
$last_from = date_format($date_start, 'Ymd') . "000000";
$last_to = date_format($date_end, 'Ymd') . "235959";
$return['0'] = $date_from;
$return['1'] = $date_to;
$return['2'] = $last_from;
$return['3'] = $last_to;
return $return;
}
function get_comic($comic, $date) {
global $sql;
$res=$sql->query("select gfx, strftime('%s', 'now')-strftime('%s', timestamp) as last from comics_date where comic='$comic' and date='$date'");
if($elem=$sql->fetch_assoc($res)) {
if($elem['gfx'])
return $elem["gfx"];
elseif(!date_is_after($date, date_add(date_get_today(), -60))) {
return null;
}
elseif((!date_is_after($date, date_add(date_get_today(), -2)))&&($elem['last']>24*60*60))
return null;
elseif($elem['last']>60)
return null;
}
$fun="{$comic}_check";
$gfx=$fun($date);
if($gfx)
$gfx_sql="\"$gfx\"";
else
$gfx_sql="null";
$sql->query("insert or replace into comics_date values ('$comic', '$date', $gfx_sql, null, datetime('now'))");
return $gfx;
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
$validation = Validator::make(Input::all(), ['duration' => 'required | integer', 'pace' => 'required | integer', 'dog_friendliness' => 'required | integer', 'comments' => 'required']);
if ($validation->fails()) {
return Redirect::back()->withInput()->withErrors($validation->messages());
}
$walk = new Walk();
$duration = Input::get('duration');
$dog_friendliness = Input::get('dog_friendliness');
$pace = Input::get('pace');
$comments = Input::get('comments');
$start = new DateTime();
$start->setTimezone(new DateTimeZone('America/New_York'));
$dateInterval = new DateInterval('PT' . $duration . 'M');
$finish = date_add($start, $dateInterval);
$walk->start = $start;
$walk->finish = $finish;
$walk->host_id = Auth::user()->id;
$walk->dog_friendliness = $dog_friendliness;
$walk->pace = $pace;
$walk->comments = $comments;
if ($walk->save()) {
return Redirect::route('walk.index');
}
}
protected function execute(InputInterface $input, OutputInterface $output)
{
/** @var EntityManager em */
$em = $this->getContainer()->get('doctrine')->getManager();
$users = $em->getRepository('ESNUserBundle:User')->findBy(array("esner" => 1));
$concerned_users = new ArrayCollection();
/** @var User $user */
foreach ($users as $user) {
/** @var EsnerFollow $follow */
$follow = $user->getFollow();
if ($follow) {
$trial = $follow->getTrialstarted();
$end_trial = $trial;
date_add($trial, date_interval_create_from_date_string('21 days'));
$now = new \DateTime();
if ($end_trial->format('d/m/Y') == $now->format('d/m/Y')) {
$concerned_users->add($user);
}
}
}
/** @var User $concerned_user */
foreach ($concerned_users as $concerned_user) {
$message = \Swift_Message::newInstance()->setSubject('[ESN Lille][ERP] Periode d\'essaie terminé pour ' . $concerned_user->getFullname())->setFrom($this->getContainer()->getParameter('mailer_from'))->setTo($user->getEmail())->setBody($this->getContainer()->get('templating')->render('ESNHRBundle:Emails:trial_ended.html.twig', array('user' => $concerned_user)), 'text/html');
$this->getContainer()->get('mailer')->send($message);
}
}
function getSMA_sub_real($company, $from = "1900-01-01 00:00:00", $to = null, $dataorg = "json", $samplePeriod = 15, $enSignals = false, $host, $db, $user, $pass)
{
$intervalPeriod = $samplePeriod * 1.5;
//from date has to be adjusted for the bollinger bands
$date = date_create($from);
date_add($date, date_interval_create_from_date_string("-{$intervalPeriod} days"));
$fromAdjusted = date_format($date, "Y-m-d");
$dataOhlc = [];
//OHLC data format [timestamp,open,high,low,close,volume]
if ($dataorg == "highchart") {
$dataOhlc = getOHLC($company, $fromAdjusted, $to, "array2", $host, $db, $user, $pass);
} else {
$dataOhlc = getOHLC($company, $fromAdjusted, $to, "array", $host, $db, $user, $pass);
}
//Return if $dataOhlc is null
if ($dataOhlc == [] || $dataOhlc == 0) {
return 0;
}
//Input for SMA functions should be [timestamp,close]
$ctr = 0;
foreach ((array) $dataOhlc as $ohlc) {
$dbreturn[$ctr][0] = $ohlc[0];
//timestamp
$dbreturn[$ctr++][1] = $ohlc[4];
//close
}
return $dbreturn;
}
function groupHasThirdWeekHours($groupInfo)
{
$today = new DateTime();
date_add($today, date_interval_create_from_date_string('14 days'));
$nextWeek = date_format($today, "Y-m-d");
return strcmp($groupInfo['addHrsType'], "week") == 0 && strcmp($nextWeek, $groupInfo['startDate']) > 0 && strcmp($nextWeek, $groupInfo['endDate']) < 0;
}
public function checkValidCode($referCode)
{
$isEnabled = Engine_Api::_()->getApi('settings', 'core')->getSetting('user_referral_enable', 1);
$period = Engine_Api::_()->getApi('settings', 'core')->getSetting('user_referral_trial', 0);
$now = date("Y-m-d H:i:s");
$invite = Engine_Api::_()->invite()->getRowCode($referCode);
//check invite code active
if (isset($invite) && !$invite->active) {
return false;
}
if ($isEnabled && $invite) {
//if exist code then get expire date
if ($period == 1) {
$type = 'day';
} else {
$type = 'days';
}
$expiration_date = date_add(date_create($invite->timestamp), date_interval_create_from_date_string($period . " " . $type));
$nowDate = date_create($now);
if ($period != 0) {
if ($nowDate >= $expirationDate) {
return true;
} else {
return false;
}
} else {
//if code never expired
return true;
}
} else {
return false;
}
}
private function addDaysFromNow($days)
{
$now = date('Y-m-d');
$date = date_create($now);
date_add($date, date_interval_create_from_date_string($days . ' days'));
return date_format($date, 'Y-m-d');
}
public function indexAction(Request $request, SessionInterface $session)
{
Util::checkUserIsLoggedInAndRedirect();
$clientSettings = $session->get('client/settings');
$slaId = $request->get('id');
$dateFrom = $request->get('date_from');
$dateTo = $request->get('date_to');
$issues = $this->getRepository(Sla::class)->getIssues($slaId, $dateFrom, $dateTo);
$dates = array();
$succeeded = array();
$breached = array();
$dateTemporary = new \DateTime($dateFrom, new \DateTimeZone($clientSettings['timezone']));
while (date_format($dateTemporary, 'Y-m-d') <= $dateTo) {
$dates[] = date_format($dateTemporary, 'Y-m-d');
$succeeded[end($dates)] = 0;
$breached[end($dates)] = 0;
date_add($dateTemporary, date_interval_create_from_date_string('1 days'));
}
while ($issues && ($issue = $issues->fetch_array(MYSQLI_ASSOC))) {
if ($issue['sla_value'] >= 0) {
$succeeded[substr($issue['stopped_date'], 0, 10)]++;
} else {
$breached[substr($issue['stopped_date'], 0, 10)]++;
}
}
$data = array('dates' => $dates, 'succeeded' => $succeeded, 'breached' => $breached);
return new JsonResponse($data);
}
public function historico_acceso($data, $limit = -1, $offset = -1)
{
$fecha = date_create(date('Y-m-j'));
date_add($fecha, date_interval_create_from_date_string('-1 month'));
$data['fecha_inicial'] = date_format($fecha, 'm');
$data['fecha_final'] = $data['fecha_final'] = date('m');
$this->db->select("AES_DECRYPT(h.email,'{$this->key_hash}') AS email", FALSE);
$this->db->select('p.id_perfil, p.perfil, p.operacion');
$this->db->select('u.nombre,u.apellidos');
$this->db->select('h.ip_address, h.user_agent, h.id_usuario');
$this->db->select("( CASE WHEN h.fecha = 0 THEN '' ELSE DATE_FORMAT(FROM_UNIXTIME(h.fecha),'%d-%m-%Y %H:%i:%s') END ) AS fecha", FALSE);
$this->db->from($this->historico_acceso . ' As h');
$this->db->join($this->usuarios . ' As u', 'u.id = h.id_usuario', 'LEFT');
$this->db->join($this->perfiles . ' As p', 'u.id_perfil = p.id_perfil', 'LEFT');
//gmt_to_local( $timestamp, 'UM1', TRUE) )
if ($data['fecha_inicial'] and $data['fecha_final']) {
$this->db->where("( CASE WHEN h.fecha = 0 THEN '' ELSE DATE_FORMAT(FROM_UNIXTIME(h.fecha),'%m') END ) = ", $data['fecha_inicial']);
$this->db->or_where("( CASE WHEN h.fecha = 0 THEN '' ELSE DATE_FORMAT(FROM_UNIXTIME(h.fecha),'%m') END ) = ", $data['fecha_final']);
}
if ($limit != -1) {
$this->db->limit($limit, $offset);
}
$this->db->order_by('h.fecha', 'desc');
$login = $this->db->get();
if ($login->num_rows() > 0) {
return $login->result();
} else {
return FALSE;
}
$login->free_result();
}
function getDates($dayofmonth, $months = 0)
{
$dayofmonth = zeropad($dayofmonth);
$year = date('Y');
$month = date('m');
if (date('d') > $dayofmonth) {
// Billing day is past, so it is next month
$date_end = date_create($year . '-' . $month . '-' . $dayofmonth);
$date_start = date_create($year . '-' . $month . '-' . $dayofmonth);
date_add($date_end, date_interval_create_from_date_string('1 month'));
} else {
// Billing day will happen this month, therefore started last month
$date_end = date_create($year . '-' . $month . '-' . $dayofmonth);
$date_start = date_create($year . '-' . $month . '-' . $dayofmonth);
date_sub($date_start, date_interval_create_from_date_string('1 month'));
}
if ($months > 0) {
date_sub($date_start, date_interval_create_from_date_string($months . ' month'));
date_sub($date_end, date_interval_create_from_date_string($months . ' month'));
}
// date_sub($date_start, date_interval_create_from_date_string('1 month'));
date_sub($date_end, date_interval_create_from_date_string('1 day'));
$date_from = date_format($date_start, 'Ymd') . '000000';
$date_to = date_format($date_end, 'Ymd') . '235959';
date_sub($date_start, date_interval_create_from_date_string('1 month'));
date_sub($date_end, date_interval_create_from_date_string('1 month'));
$last_from = date_format($date_start, 'Ymd') . '000000';
$last_to = date_format($date_end, 'Ymd') . '235959';
$return = array();
$return['0'] = $date_from;
$return['1'] = $date_to;
$return['2'] = $last_from;
$return['3'] = $last_to;
return $return;
}
public function notify_payment()
{
$this->load->model('client_model');
$this->load->model('bill_model');
$received_data = $this->input->post();
$user_name = $this->session->userdata('username');
$get_email = $this->client_model->get_email_id($user_name);
$get_balance = $this->bill_model->get_balance($received_data["invoice"], $get_email);
$balance = floatval($get_balance[0]['balance']) - floatval($received_data["mc_gross_1"]);
// echo $get_balance[0]['balance']."<br/>".$received_data["mc_gross_1"]."<br/>".$balance;
$data = array("transaction_id" => $received_data["txn_id"], "gateway" => "Paypal", 'bill_id' => $received_data["invoice"], "user_email" => $get_email, "credit" => $received_data["mc_gross_1"], "vat" => $received_data['mc_gross_2'], "balance" => $balance, "transaction_date_time" => $received_data["payment_date"]);
$this->bill_model->insert_transaction($data);
$partial_status = 0;
$bill_due_date = $this->bill_model->bill_due_date($received_data["invoice"]);
if ($balance > 0) {
$date = date_create($bill_due_date[0]['bill_due_date']);
date_add($date, date_interval_create_from_date_string("15 days"));
$bill_date = date_format($date, "Y-m-d");
$data = array("bill_due_date" => $bill_date, "bill_allow_partial" => 0, "bill_to_paid" => $bill_due_date[0]["bill_to_paid"] + $received_data["mc_gross_1"], 'bill_due_amount' => $balance, "partial_status" => 1);
$data1 = array("status" => 1);
$this->bill_model->update_bill($data, $received_data["invoice"]);
$this->bill_model->update_bill_service($data1, $received_data["invoice"]);
} else {
$data = array("bill_to_paid" => $bill_due_date[0]["bill_to_paid"] + $received_data["mc_gross_1"], 'bill_due_amount' => $balance, "bill_status" => 1);
$data1 = array("status" => 1);
$this->bill_model->update_bill($data, $received_data["invoice"]);
$this->bill_model->update_bill_service($data1, $received_data["invoice"]);
}
$data = array("transaction_id" => $received_data["txn_id"], "gateway" => "Paypal", 'bill_id' => $received_data["invoice"], "balance" => $balance, "credit" => $received_data["mc_gross_1"], "transaction_date_time" => $received_data["payment_date"]);
$this->session->set_userdata($data);
redirect('/client/view_bill_details/' . $received_data["invoice"]);
}
public function check_due_date($date)
{
echo $date;
$query = $this->db->query('SELECT * FROM rent_details')->result_array();
//exit();
foreach ($query as $key) {
$due_date = $key['rent_due_date'];
$rent = $key['rent'];
$id = $key['id'];
$rent_balance = $key['rent_balance'];
$new_rent_balance = $rent_balance + $rent;
$new_date = date_create($due_date);
date_add($new_date, date_interval_create_from_date_string("30 days"));
$new_rent_due_date = date_format($new_date, "Y-m-d");
echo $new_rent_due_date;
$date1 = date_create($date);
$date2 = date_create($due_date);
$diff = date_diff($date1, $date2);
$dif = $diff->format("%a");
if ($dif == 0) {
if ($new_rent_balance <= 0) {
$this->db->query("UPDATE rent_details SET rent_due = '0' WHERE id ='" . $id . "'");
# code...
} else {
$this->db->query("UPDATE rent_details SET rent_due = '" . $new_rent_balance . "' WHERE id ='" . $id . "'");
}
$this->db->query("UPDATE rent_details SET rent_balance = '" . $new_rent_balance . "' WHERE id ='" . $id . "'");
$this->db->query("UPDATE rent_details SET rent_due_date = '" . $new_rent_due_date . "' WHERE id ='" . $id . "'");
} else {
//$this->db->query('UPDATE rent_details SET rent_due = '0'');
}
}
}
/**
* @test
*/
public function setDateTimeAllowsForMockingTheCurrentTime()
{
$simulatedCurrentTime = new \DateTime();
date_add($simulatedCurrentTime, new \DateInterval('P1D'));
$context = $this->contextFactory->create(array('currentDateTime' => $simulatedCurrentTime));
$this->assertEquals($simulatedCurrentTime, $context->getCurrentDateTime());
}
public function testCreateVehicle()
{
$problem = $this->initWithProblem();
$vehicle = new stdClass();
$startlocation = new stdClass();
$startlocation->Coordinate = new stdClass();
$startlocation->Coordinate->Latitude = "62.254622";
$startlocation->Coordinate->Longitude = "25.787020";
$startlocation->Coordinate->System = "WGS84";
$endlocation = new stdClass();
$endlocation->Coordinate = new stdClass();
$endlocation->Coordinate->Latitude = "62.254622";
$endlocation->Coordinate->Longitude = "25.787020";
$endlocation->Coordinate->System = "WGS84";
$vehicle = new stdClass();
$vehicle->Name = "Vehicle1";
$vehicle->StartLocation = $startlocation;
$vehicle->EndLocation = $endlocation;
$vehicle->RelocationType = "None";
$timeWindow = new stdClass();
$now = new DateTime();
$timeWindow->Start = $now->format('Y-m-d H:i:s');
$end = date_add($now, date_interval_create_from_date_string('12 hours'));
$timeWindow->End = $end->format('Y-m-d H:i:s');
$vehicle->TimeWindows = $timeWindow;
$vehicle->Capacities = array(array("Amount" => 100, "Name" => "Weight"));
$resp = $this->api->navigate(getLink($problem, "create-vehicle"), $vehicle);
$v = $this->api->navigate($resp);
$this->assertEquals("Vehicle1", $v->Name);
unset($api);
}
public function finanzas()
{
$user = \Auth::User();
$now = new \DateTime();
$lasth_month = date_add($now, date_interval_create_from_date_string("-1 months"));
$now = new \DateTime();
$last_last_month = date_add($now, date_interval_create_from_date_string("-2 months"));
$now = new \DateTime();
//\DB::select("delete from comisiones where periodo <> extract(year_month from ?) and periodo <> extract(year_month from ?) and periodo <> extract(year_month from ?)", [$now, $lasth_month, $last_last_month]);
if (!$user->isContabilidad) {
$distribuidores = [];
$subdistribuidores = [];
if ($user->isAdmin) {
$distribuidores = \DB::table('users')->get();
foreach ($distribuidores as $distribuidor) {
$subdistribuidores[$distribuidor->name] = \DB::table('subdistribuidores')->where('emailDistribuidor', $distribuidor->email)->get();
}
} else {
$subdistribuidores = \DB::table('subdistribuidores')->where('emailDistribuidor', $user->email)->get();
}
$periodos = \DB::select("select distinct periodo from comisiones order by periodo desc");
return view('/finanzas', array('user' => $user, 'subdistribuidores' => $subdistribuidores, 'distribuidores' => $distribuidores, 'periodos' => $periodos));
} else {
$distribuidores = \DB::table('users')->where('name', '<>', 'OFICINA')->get();
foreach ($distribuidores as $distribuidor) {
$subdistribuidores[$distribuidor->name] = \DB::table('subdistribuidores')->where('emailDistribuidor', $distribuidor->email)->get();
}
$periodos = \DB::select("select distinct periodo from comisiones order by periodo desc");
return view('/finanzas', array('user' => $user, 'subdistribuidores' => $subdistribuidores, 'distribuidores' => $distribuidores, 'periodos' => $periodos));
}
}
public static function store()
{
self::check_logged_in(array("asiakas", "tyontekija", "johtaja"));
$params = $_POST;
$palvelu = Palvelu::find($params['palvelu_id']);
$aloitusaika = strtotime($params['paiva'] . ' ' . $params['kellonaika']);
list($tunnit, $minuutit, $sekunnit) = sscanf($palvelu->kesto, '%d:%d:%d');
$kesto = new DateInterval(sprintf('PT%dH%dM', $tunnit, $minuutit));
$lopetusaika = date_timestamp_get(date_add(new DateTime('@' . $aloitusaika), $kesto));
$attributes = array('asiakas_id' => $params['asiakas_id'], 'palvelu_id' => $params['palvelu_id'], 'tyontekija_id' => $params['tyontekija_id'], 'toimitila_id' => $params['toimitila_id'], 'aloitusaika' => date('Y-m-d H:i', $aloitusaika), 'lopetusaika' => date('Y-m-d H:i', $lopetusaika), 'on_peruutettu' => NULL);
$varaus = new Varaus($attributes);
$errors = $varaus->errors();
// tarkistetaan resurssien ja asiakkaan saatavuus varausajalle
if (count($errors) == 0) {
$errors = $varaus->check_overlaps();
}
if (count($errors) > 0) {
$tyontekijat = Tyontekija::all();
$palvelut = Palvelu::all();
$toimitilat = Toimitila::all();
$asiakkaat = Asiakas::all();
View::make('varaus/varaus_lisaa.html', array('errors' => $errors, 'varaus' => $varaus, 'tyontekijat' => $tyontekijat, 'palvelut' => $palvelut, 'toimitilat' => $toimitilat, 'asiakkaat' => $asiakkaat));
} else {
$varaus->save();
Redirect::to('/', array('message' => 'Varaus tallennettu.'));
}
}
public function show()
{
//nuvarande månad
$d = "20" . $this->year . "-" . $this->monthNr . "-01";
$date = date_create($d);
//nästa månad
$nextdate = date_add($date, date_interval_create_from_date_string('1 month'));
$next = "y=" . date_format($nextdate, "y") . "&m=" . date_format($nextdate, "n");
//föregående månad
$prevdate = date_sub($date, date_interval_create_from_date_string('2 months'));
$prev = "y=" . date_format($prevdate, "y") . "&m=" . date_format($prevdate, "n");
$html = <<<EOT
<header>
<a class="left navsquare" href="?p=calendar&{$prev}">❮</a>
<a class="right navsquare" href="?p=calendar&{$next}">❯</a>
<h2 class="strokeme">{$this->month} 20{$this->year}</h2>
<img class="header" src="img/calendar/{$this->getMonthImage()}"
alt="image of the month"></header>
<section>\t
{$this->calendarTable()}
{$this->showHollidays()}
</section>
EOT;
return $html;
}
function processWalking($results, $fileRow)
{
global $csvData;
global $sqlDB;
global $plat;
//this is where I'm going to do things
foreach ($results as $result) {
$startDate = $result['DateBegan'];
$endDate = $result['DateStopped'];
$diff = date_diff($startDate, $endDate);
$days = $diff->format("%a");
$currentDate = $result['DateBegan'];
$formattedDate = date_format($currentDate, 'm/d/y');
$tempData = array();
while ($currentDate <= $endDate) {
$dayDate = $formattedDate . ' ' . "00:00:00";
$endDay = $formattedDate . ' ' . "23:59:59";
$querry = "SELECT TOP 1 RecID FROM vPhoneData1\n\t\t\t\tWHERE (TaskSetName = '1 PING' or TaskSetName =\n\t\t\t\t '3 REPORT CGI_OR_H2RL') AND LocalTimetag1 > ? and\n\t\t\t\t LocalTimetag1 < ? and cast(FORMDATA as varchar(max)) like\n\t\t\t\t '%" . $plat . "%'";
$stmt = sqlsrv_prepare($sqlDB, $querry, array(&$dayDate, &$endDay));
sqlsrv_execute($stmt);
$fetched = sqlsrv_fetch_array($stmt);
if (!empty($fetched)) {
$formattedDate = date_format($currentDate, 'm/d/y');
$fileRow['Survey Dt'] = $formattedDate;
$fileRow['Completed By'] = $result['TechName'];
$fileRow['Instrument'] = $result['Instrument'];
$fileRow['Rate'] = $result['RateCode'];
$fileRow['Survey Method'] = 'WALK';
$tempData[] = $fileRow;
}
$currentDate = date_add($currentDate, date_interval_create_from_date_string('1 days'));
$formattedDate = date_format($currentDate, 'm/d/y');
$fetched = null;
}
if (!empty($tempData)) {
$daycount = count($tempData);
if ($result[6] > 0) {
$dailyTotal = floor($result[6] / $daycount);
$firstTotal = $dailyTotal + $result[6] % $daycount;
$isFirst = TRUE;
} else {
$dailyTotal = 0;
}
foreach ($tempData as $tempRow) {
if ($isFirst === TRUE) {
$tempRow['Quantity'] = $firstTotal;
$isFirst = FALSE;
} elseif ($dailyTotal > 0) {
$tempRow['Quantity'] = $dailyTotal;
} else {
$tempRow['Quantity'] = 0;
}
if ($tempRow['Quantity'] > 0) {
$csvData[] = $tempRow;
}
}
}
}
}
function myCompare($orderedOn)
{
global $datex;
$orderedOn = date_create($orderedOn);
if (date_add($datex, date_interval_create_from_date_string("-96 hours")) >= $orderedOn) {
return "ThisExpired";
}
}
public function getLRLastNoticeDate($lrCreated)
{
$lastContactDate = clone $lrCreated;
date_add($lastContactDate, date_interval_create_from_date_string('5 days'));
$weekendDays = Utils::countWeekendDays($lrCreated->getTimeStamp(), $lastContactDate->getTimeStamp());
date_add($lastContactDate, date_interval_create_from_date_string($weekendDays . ' days'));
return $lastContactDate->format('Y-m-d');
}
/**
* @test
*/
public function setDateTimeAllowsForMockingTheCurrentTime()
{
$simulatedCurrentTime = new \DateTime();
date_add($simulatedCurrentTime, new \DateInterval('P1D'));
$contentContext = new \TYPO3\TYPO3\Domain\Service\ContentContext('live');
$contentContext->setCurrentDateTime($simulatedCurrentTime);
$this->assertEquals($simulatedCurrentTime, $contentContext->getCurrentDateTime());
}
function createTimeWindowWithDuration($duration)
{
$timeWindow = new stdClass();
$now = new DateTime();
$timeWindow->Start = $now->format('Y-m-d H:i:s');
$end = date_add($now, date_interval_create_from_date_string($duration . ' hours'));
$timeWindow->End = $end->format('Y-m-d H:i:s');
return $timeWindow;
}
/**
* Выборка операций за период
*/
public function testFillForPeriod()
{
$dateStart = new DateTime(date('Y-m-01'));
$dateEnd = date_add(clone $dateStart, new DateInterval('P1M'));
$op = $this->helper->makeOperation();
$operationCollection = new OperationCollection($op->getUser());
$operationCollection->setPeriodStartDate($dateStart)->setPeriodEndDate($dateEnd)->fill();
$this->assertNotEquals(0, count($operationCollection->getOperations()));
}
/**
* Time constructor.
*/
public function __construct()
{
$this->currentDateTime = date("Y-m-d h:i:s");
$this->currentDate = date("Y-m-d");
$this->currentTime = date("h:i:s");
$date = date_create($this->currentDate);
date_add($date, date_interval_create_from_date_string('6 days'));
$this->accessTokenExpirationDate = date_format($date, 'Y-m-d') . ' ' . $this->currentTime;
}
public function addHoliday($date_from, $date_to = '', $calendar_id)
{
global $wpdb;
global $blog_id;
$blog_prefix = $blog_id . "_";
if ($blog_id == 1) {
$blog_prefix = "";
}
if ($date_to == '') {
//check if this day already exists
$numrows = $wpdb->query($wpdb->prepare("SELECT * FROM " . $wpdb->base_prefix . $blog_prefix . "booking_holidays WHERE holiday_date =%s AND calendar_id= %d", $date_from, $calendar_id));
if ($numrows > 0) {
return 0;
} else {
$wpdb->query($wpdb->prepare("INSERT INTO " . $wpdb->base_prefix . $blog_prefix . "booking_holidays (holiday_date,calendar_id) VALUES(%s,%d)", $date_from, $calendar_id));
$lastId = $wpdb->insert_id;
//check if there are reservation for that date
$checkQry = $wpdb->prepare("SELECT * FROM " . $wpdb->base_prefix . $blog_prefix . "booking_reservation r INNER JOIN " . $wpdb->base_prefix . $blog_prefix . "booking_slots s ON s.slot_id = r.slot_id WHERE s.slot_date = %s AND r.calendar_id = %d", $date_from, $calendar_id);
$checkRows = $wpdb->query($checkQry);
if ($checkRows > 0) {
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->base_prefix . $blog_prefix . "booking_slots SET slot_active = %d WHERE slot_date=%s AND calendar_id = %d", 0, $date_from, $calendar_id));
} else {
$wpdb->query($wpdb->prepare("DELETE FROM " . $wpdb->base_prefix . $blog_prefix . "booking_slots WHERE slot_date = %s AND calendar_id= %d", $date_from, $calendar_id));
}
return $lastId;
}
} else {
$arrNewIds = array();
$datefromnum = str_replace("-", "", $date_from);
$datetonum = str_replace("-", "", $date_to);
$date = date_create($date_from);
while ($datefromnum <= $datetonum) {
$dateformat = date_format($date, 'Y-m-d');
//check if this day already exists
$holidayCheck = $wpdb->query($wpdb->prepare("SELECT * FROM " . $wpdb->base_prefix . $blog_prefix . "booking_holidays WHERE holiday_date =%s AND calendar_id= %d", $dateformat, $calendar_id));
if ($holidayCheck == 0) {
$wpdb->query($wpdb->prepare("INSERT INTO " . $wpdb->base_prefix . $blog_prefix . "booking_holidays (holiday_date,calendar_id) VALUES(%s,%d)", $dateformat, $calendar_id));
array_push($arrNewIds, $wpdb->insert_id);
//check if there are reservation for that date
$check = $wpdb->query($wpdb->prepare("SELECT * FROM " . $wpdb->base_prefix . $blog_prefix . "booking_reservation r INNER JOIN " . $wpdb->base_prefix . $blog_prefix . "booking_slots s ON s.slot_id = r.slot_id WHERE s.slot_date = %s AND r.calendar_id = %d", $dateformat, $calendar_id));
if ($check > 0) {
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->base_prefix . $blog_prefix . "booking_slots SET slot_active = %d WHERE slot_date=%s AND calendar_id = %d", 0, $dateformat, $calendar_id));
} else {
$wpdb->query($wpdb->prepare("DELETE FROM " . $wpdb->base_prefix . $blog_prefix . "booking_slots WHERE slot_date = %s AND calendar_id=%d", $dateformat, $calendar_id));
}
}
if (function_exists("date_add")) {
date_add($date, date_interval_create_from_date_string('1 days'));
} else {
date_modify($date, '+1 day');
}
//date_modify($date, '+1 day');
$datefromnum = date_format($date, 'Ymd');
}
return $arrNewIds;
}
}
function getMACD($company, $from = "1900-01-01 00:00:00", $to = null, $dataorg = "json", $host, $db, $user, $pass)
{
$macd = [];
$intervalPeriod = 55;
//from date has to be adjusted for the bollinger bands
$date = date_create($from);
date_add($date, date_interval_create_from_date_string("-{$intervalPeriod} days"));
$fromAdjusted = date_format($date, "Y-m-d");
$dataOhlc = [];
//OHLC data format [timestamp,open,high,low,close,volume]
if ($dataorg == "highchart") {
$dataOhlc = getOHLC($company, $fromAdjusted, $to, "array2", $host, $db, $user, $pass);
} else {
$dataOhlc = getOHLC($company, $fromAdjusted, $to, "array", $host, $db, $user, $pass);
}
//Return if $dataOhlc is null
if ($dataOhlc == [] || $dataOhlc == 0) {
return 0;
}
//Input for SMA functions should be [timestamp,close]
$ctr = 0;
foreach ($dataOhlc as $ohlc) {
if ($dataorg == "json") {
$dbreturn[$ctr][0] = $ohlc[0];
//timestamp
$dbreturn[$ctr][1] = $ohlc[4];
//close
} elseif ($dataorg == "highchart") {
$dbreturn[$ctr][0] = $ohlc[0];
//timestamp
$dbreturn[$ctr][1] = $ohlc[4];
//close
} elseif ($dataorg == "array") {
//TODO: create code for organizing an array data output
} else {
$dbreturn[$ctr][0] = $ohlc[0];
//timestamp
$dbreturn[$ctr][1] = $ohlc[4];
//close
}
$ctr++;
}
if ($dataorg == "json") {
//echo json_encode($dbreturn);
$macd = codesword_macd($dbreturn);
//echo json_encode($ema);
} elseif ($dataorg == "highchart") {
$macd = codesword_macd($dbreturn);
} elseif ($dataorg == "array") {
//TODO: create code for organizing an array data output
} else {
//json
$macd = codesword_macd($dbreturn);
}
echo json_encode($macd);
}
