Beispiel #1
0
 public function listUnused(Foretag $foretag)
 {
     global $db;
     $sql = "SELECT bildUrl FROM " . Lag::TABLE . " WHERE foretag_id = " . $foretag->getId();
     $res = $db->query($sql);
     $sql2 = "\n\t\t\tSELECT id \n\t\t\tFROM " . self::TABLE . " \n\t\t\tWHERE 1 = 1\n\t\t";
     $res = $db->query($sql);
     while ($data = mysql_fetch_assoc($res)) {
         $sql2 .= " AND img NOT LIKE '%" . $data["bildUrl"] . "' ";
     }
     return self::listByIds($db->valuesAsArray($sql2));
 }
<?php

/* ajax call 
 * krillo 2012-07-24
 */
require_once $_SERVER["DOCUMENT_ROOT"] . "/php/init.php";
error_reporting(E_ALL);
ini_set('display_errors', '1');
$campaingMemberCode = mb_convert_case(urldecode($_REQUEST["compcampcode"]), MB_CASE_LOWER, "UTF-8");
$campaingMemberCode = trim($campaingMemberCode);
//trim whitespaces
$campaingMemberCode = trim($campaingMemberCode, '"');
//trim "
$validCampaingMemberCodes = Foretag::getValidCampaignMemberCodes();
$ret = -1;
foreach ($validCampaingMemberCodes as $companyId => $value) {
    if ($value['campaignMemberCode'] == $campaingMemberCode) {
        $ret = $companyId;
    }
}
echo $ret;
Beispiel #3
0
<?php

include $_SERVER["DOCUMENT_ROOT"] . "/php/init.php";
Security::demand(USER);
$foretag = Foretag::loadById($_POST["fid"]);
$foretag->gaMedI($_POST["nyckel"]);
header("Location: " . $urlHandler->getUrl("Foretag", URL_VIEW, $foretag->getId()));
Beispiel #4
0
 public function setForetag(Foretag $foretag)
 {
     if ($this->foretag) {
         Security::demand(ADMIN);
     }
     $this->foretag = $foretag;
     $this->foretag_id = $foretag->getId();
 }
Beispiel #5
0
 unset($lag_stegtotal_cache);
 if (count($tl) != 0) {
     array_multisort($tl, SORT_DESC);
 }
 $tm = array();
 if (empty($foretag_ids)) {
     $foretag_ids = array();
     foreach ($tf as $foretag) {
         $foretag_ids[] = $foretag["id"];
     }
 }
 $sql = "SELECT foretag_id, medlem_id, aNamn FROM " . Foretag::KEY_TABLE . " f INNER JOIN " . Medlem::TABLE . " m ON f.medlem_id=m.id WHERE medlem_id > 0 AND foretag_id IN (" . implode(",", $foretag_ids) . ")";
 $res = $db->query($sql);
 while ($row = mysql_fetch_array($res)) {
     try {
         $tForetag = Foretag::loadById($row["foretag_id"]);
         $medlem_id = $row["medlem_id"];
         $medlem_anamn = $row["aNamn"];
     } catch (Exception $e) {
         // Foretag doesn't exist (we check this just in case)
         continue;
     }
     if (!empty($medlem_id)) {
         $stegindex = Medlem::getStegIndexForMedlemId($medlem_id, $tForetag);
         if ($tForetag != null && $stegindex != null && strtotime($tForetag->getSlutDatum()) >= $slutDatum_ts) {
             $tm[] = array("stegindex" => $stegindex, "namn" => $medlem_anamn, "id" => $medlem_id);
         }
     }
 }
 unset($tForetag);
 unset($medlem_stegtotal_cache);
Beispiel #6
0
<?php

require $_SERVER["DOCUMENT_ROOT"] . "/php/init.php";
switch ($_POST["typ"]) {
    case "anamn":
        echo Medlem::ledigtAnvandarnamn(utf8_encode($_POST["varde"])) ? "1" : "0";
        break;
    case "epost":
        echo Medlem::ledigEpost($_POST["varde"]) ? "1" : "0";
        break;
    case "foretagsnyckel":
        $result = Foretag::giltigForetagsnyckel($_POST["varde"]);
        if ($result === true) {
            echo "1";
        } else {
            if ($result == Foretag::FN_OGILTIG) {
                echo "OGILTIG";
            } else {
                if ($result == Foretag::FN_UPPTAGEN) {
                    echo "UPPTAGEN";
                }
            }
        }
        break;
        // added by krillo 11-01-18
    // added by krillo 11-01-18
    case "kampanjkod":
        $varde = mb_convert_case(utf8_encode(urldecode($_POST["varde"])), MB_CASE_LOWER, "UTF-8");
        $result = Order::giltigKampanjkod($varde);
        if ($result === true) {
            echo "1";
Beispiel #7
0
 public static function getForetagItems(Foretag $foretag, $days = 7)
 {
     if (defined('TRUNCATE_OLDER_THAN')) {
         $days = TRUNCATE_OLDER_THAN;
     }
     $feeds = array();
     $dates = self::getDateArray($days);
     foreach ($dates as $key => $date) {
         global $USER;
         if ($foretag->getStegTotal($date) > 0) {
             $feeditem = new FeedItem("foretagssteg", null, $USER);
             $feeditem->setDatum(strtotime($date));
             $feeds[] = $feeditem;
         }
     }
     return $feeds;
 }
    }
    $kommun = Kommun::loadById($order->kid);
    $kontotyp = '';
    //legacy or not used right now
    $maffcode = '';
    //legacy or not used right now
    $medlem = new Medlem($order->email, $order->anamn, $kommun, $order->sex, $order->fname, $order->lname, $kontotyp, $maffcode);
    $medlem->setEpostBekraftad(1);
    //medlem valid from start
    $medlem->setLevelId(1);
    //pro from start
    $medlem->confirm($order->pass);
    $medlem->setForetagsnyckel_temp($order->nyckel);
    $medlem->setForetagsnyckel($order->nyckel);
    //krillo 2013-08-29 if the users email the same as the buyers - set her as foretagsadmin in db (mm_medlem:fadmin)
    $foretag = Foretag::loadByForetagsnyckel($order->nyckel);
    $payer_email = $foretag->getPayerEmail();
    if ($payer_email == $order->email) {
        $reset = $foretag->resetAllFadmin();
        if ($reset) {
            $fid = $foretag->getId();
            $medlem->setFadmin($fid, false);
        }
    }
    $medlem->commit();
    //clear mm_medlem in cache, force to reload from the updated db
    global $db;
    $db->removeBufferObject('Medlem', $medlem->getId());
    $medlem->loggaIn($order->email, $order->pass, true);
}
header("Location: " . '/pages/minsida.php?mmForetagsnyckel=' . $order->nyckel);
Beispiel #9
0
<?php

include $_SERVER["DOCUMENT_ROOT"] . "/php/init.php";
$smarty = new MMSmarty();
$smarty->assign("pagetitle", "Lista företag");
$foretagList = Foretag::listAll();
$smarty->assign("foretagList", $foretagList);
$smarty->display('listforetag.tpl');
#!/usr/bin/php
<?php 
define('ROOT', dirname(__FILE__) . "/../public_html");
chdir(ROOT);
require_once ROOT . "/php/init.php";
echo date('Y-m-d h:i:s') . " [INFO] Start:  End and save competition data on monday cron script. \n";
Misc::logMotiomera("Start:  End and save competition data on monday cron script ", 'INFO');
Foretag::saveAndEndForetagsTavling();
Misc::logMotiomera("End end and save competition data on monday cron script \n", 'INFO');
?>

require $_SERVER["DOCUMENT_ROOT"] . "/php/init.php";
Security::demand(ADMIN);
if (!empty($_GET['action'])) {
    switch ($_GET['action']) {
        case 'kundnummer':
            echo date('Y-m-d h:i:s') . " [INFO] Start kundnummer from admin by " . $ADMIN->getANamn() . ". See logfile\n";
            Misc::logMotiomera("Start kundnummer from admin by  " . $ADMIN->getANamn(), 'INFO');
            Order::hamtaNyaKundnummer();
            Order::liftTillaggOrderStatus();
            Misc::logMotiomera("End kundnummer from admin \n", 'INFO');
            break;
        case 'pdf':
            echo date('Y-m-d h:i:s') . " [INFO] Start create PDF-files from admin by " . $ADMIN->getANamn() . ". See logfile\n";
            Misc::logMotiomera("Start create PDF-files from admin by " . $ADMIN->getANamn(), 'INFO');
            Foretag::skapaFiler();
            Misc::logMotiomera("End create PDF-files from admin \n", 'INFO');
            break;
        case 'ftp':
            echo date('Y-m-d h:i:s') . " [INFO] Start put PDF-files on FTP from admin by " . $ADMIN->getANamn() . ". See logfile\n";
            Misc::logMotiomera("Start put PDF-files on FTP from admin by " . $ADMIN->getANamn(), 'INFO');
            Foretag::uploadOrderFilesFTP();
            Misc::logMotiomera("End put PDF-files on FTP from admin \n", 'INFO');
            break;
        default:
            echo '<h3>Det är fel paramatrar!</h3>';
            break;
    }
} else {
    echo '<h3>Det saknas paramatrar!</h3>';
}
Beispiel #12
0
/**
 * Description: set the fadmin
 * The data is returned as a jason object in the format below:
 *
 * Date: 2013-09-02
 * Author: Kristian Erendi
 * URI: http://reptilo.se
 */
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
require_once $_SERVER["DOCUMENT_ROOT"] . "/php/init.php";
$req = new stdClass();
!empty($_REQUEST['mm_id']) ? $req->mm_id = addslashes($_REQUEST['mm_id']) : ($req->mm_id = '');
!empty($_REQUEST['fid']) ? $req->fid = addslashes($_REQUEST['fid']) : ($req->fid = '');
$response['success'] = 0;
try {
    $foretag = Foretag::loadById($req->fid);
    $reset = $foretag->resetAllFadmin();
    if ($reset) {
        $medlem = Medlem::loadById($req->mm_id);
        $medlem->setFadmin($req->fid);
        $medlem->commit();
        $response['success'] = $req->mm_id;
    }
} catch (Exception $exc) {
    $response['error'] = $exc->getTraceAsString();
}
echo json_encode($response);
die;
Beispiel #13
0
 public static function loadForetagsBildblock(Foretag $foretag, $antal = 20)
 {
     global $db, $USER;
     $lowest_id = 0;
     $bilder = array();
     $foretag_id = $foretag->getId();
     // hämta 10 senaste bilderna (baserat på fotoalbum som specifikt gett tillstånd till företaget att se bilderna)
     //	*, mm_fotoalbumbild.id AS id
     $sql = $db->query("\tSELECT\n\t\t\t\t\t\t\t\tmm_fotoalbum.*, mm_fotoalbumbild.*,\n\t\t\t\t\t\t\t\tmm_medlem.fnamn, mm_medlem.anamn, mm_medlem.enamn, mm_medlem.avatar_filename, \n\t\t\t\t\t\t\t\tmm_fotoalbumbild.id AS id\n\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\tmm_fotoalbum, mm_fotoalbumbild, mm_medlem, mm_foretagsnycklar\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\tmm_fotoalbumbild.fotoalbum_id = mm_fotoalbum.id\n\t\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\tmm_fotoalbum.medlem_id = mm_medlem.id\n\t\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\tmm_foretagsnycklar.medlem_id = mm_medlem.id\n\t\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\tmm_foretagsnycklar.foretag_id = {$foretag_id}\n\t\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\tmm_fotoalbum.tilltrade_foretag = 'ja'\n\t\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\tmm_fotoalbum.tilltrade = 'alla'\n\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\tmm_fotoalbumbild.id DESC\n\t\t");
     list($lowest_id, $bilder) = FotoalbumBild::processRowsBildblock($antal / 2, $lowest_id, $bilder, $sql);
     // hämta 10 slumpade bilder
     if (count($bilder) == $antal / 2) {
         // det finns iallafall 10 bilder, så försök hitta några till (slumpade)
         $sql = $db->query("\tSELECT\n\t\t\t\t\t\t\t\tmm_fotoalbum.*, mm_fotoalbumbild.*,\n\t\t\t\t\t\t\t\tmm_medlem.fnamn, mm_medlem.anamn, mm_medlem.enamn, mm_medlem.avatar_filename, \n\t\t\t\t\t\t\t\tmm_fotoalbumbild.id AS id\n\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\tmm_fotoalbum, mm_fotoalbumbild, mm_medlem, mm_foretagsnycklar\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\tmm_fotoalbumbild.fotoalbum_id = mm_fotoalbum.id\n\t\t\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\t\tmm_fotoalbum.medlem_id = mm_medlem.id\n\t\t\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\t\tmm_foretagsnycklar.medlem_id = mm_medlem.id\n\t\t\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\t\tmm_foretagsnycklar.foretag_id = {$foretag_id}\n\t\t\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\tmm_fotoalbum.tilltrade_foretag = 'ja'\n\t\t\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t\tmm_fotoalbum.tilltrade = 'alla'\n\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\t\tmm_fotoalbumbild.id < {$lowest_id}\n\t\t\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\t\t\tRAND()\n\t\t\t");
         list($lowest_id, $bilder) = FotoalbumBild::processRowsBildblock($antal, $lowest_id, $bilder, $sql);
     }
     if (count($bilder) > 0) {
         // slumpa ordningen
         shuffle($bilder);
         return $bilder;
     } else {
         return false;
     }
 }
Beispiel #14
0
    //return to checkout
    $url = $SETTINGS["url"] . '/pages/skapaforetag.php?nbr=0';
    header('Location: ' . $url);
    exit;
} else {
    //do a price check to avoid javascript hacking
    $noFraud = Order::priceCheck($req->RE03, $req->RE04, $req->exmoms, $req->freight, $req->total, $req->incmoms, $req->discount);
    if ($noFraud) {
        //javascript prices match to local calculation
        //everthing looks fine sofar, create the company
        $kommun = Kommun::loadById(150);
        //Use Ale - legacy
        $foretagLosen = Foretag::skapaLosen();
        //a new is created in api/order if a purchase is made
        $isValid = 0;
        $foretag = new Foretag($req->delCompany, $kommun, $foretagLosen, $req->startdatum, $req->channel, $req->campcode, $isValid, $req->weeks);
        //param "Order::isValid" and is set to 0 - i.e. not a valid order yet
        $foretag->setTempLosenord($foretagLosen);
        //a new is created in api/order if a purchase is made. Store this one!
        $foretag->setPayerCompanyName($req->company);
        $foretag->setPayerName($req->fname . ' ' . $req->lname);
        $foretag->setPayerFName($req->fname);
        $foretag->setPayerLName($req->lname);
        $req->street = $req->street1;
        !empty($req->street2) ? $req->street = $req->street . ' ;; ' . $req->street2 : null;
        !empty($req->street3) ? $req->street = $req->street . ' ;; ' . $req->street3 : null;
        $foretag->setPayerAddress($req->street);
        $foretag->setPayerCo($req->co);
        $foretag->setPayerZipCode($req->zip);
        $foretag->setPayerCity($req->city);
        $foretag->setPayerEmail($req->email);
Beispiel #15
0
 /**
  * Försöker logga in med epost och lösenord.
  * Om det lyckas så sparas data om vem som är inloggad, och ett Medlems-objekt returneras
  *
  * @global  $db
  * @param type $epost
  * @param type $losenord
  * @param type $cookie
  * @return boolean
  * @throws MedlemException 
  */
 public static function loggaIn($epost, $losenord, $cookie = false)
 {
     global $db;
     $epost = Security::secure_postdata($epost);
     $losenord = Security::secure_postdata($losenord);
     if ($epost == "" || $losenord == "") {
         return false;
     }
     $sql = "SELECT id\n\t\t\t\tFROM " . self::classToTable(get_class()) . " \n\t\t\t\tWHERE epost='{$epost}'";
     $id = $db->value($sql);
     if ($id == "") {
         throw new MedlemException('E-postadressen kunde inte hittas', -13);
     }
     $medlem = Medlem::loadById($id);
     if ($medlem->epostBekraftad == 0) {
         throw new MedlemException('Kontot ej aktiverat', -15);
     }
     $losenordKrypterat = Security::encrypt_password($id, $losenord);
     if ($losenordKrypterat == $medlem->getLosenord()) {
         // Lyckad inloggning
         $sessionId = self::generateSessionId();
         $medlem->setSenastInloggad();
         $medlem->setSessionId($sessionId);
         $medlem->commit();
         $_SESSION["mm_mid"] = $id;
         $_SESSION["mm_sid"] = $sessionId;
         if ($cookie) {
             setcookie("mm_mid", $id, time() + 60 * 60 * 24 * 30, "/");
             setcookie("mm_sid", $sessionId, time() + 60 * 60 * 24 * 30, "/");
         }
         //if foretags_id in db, try to log in as foretagsadmin
         $fId = $medlem->getFadmin();
         if ($fId > 0) {
             $foretag = Foretag::loadById($fId);
             $foretag->doubleLogIn($fId);
         }
         // if levelId is set (ie, the member used to be a pro), it gets reset to zero, and an exception is thrown (which leads to to the user being redirected to the buy page)
         if ($medlem->getPaidUntil() < date("Y-m-d")) {
             // && $medlem->getLevelId() > 0) {   //old stuff removed by krillo 2011-01-19,  always lock them out
             $level = $medlem->getLevelId();
             //$medlem->setLevelId(0);
             //$medlem->commit();
             throw new MedlemException('Medlemskap har gått ut', -19, $level);
         }
         return true;
     } else {
         throw new MedlemException("Felaktigt lösenord", -5);
     }
 }
Beispiel #16
0
 public function harMedlemTilltrade($medlem)
 {
     if (Security::authorized(USER) == false) {
         // icke inloggad besökare
         if ($this->getTilltrade() == "alla") {
             return true;
         } else {
             return false;
         }
     }
     // alla har tillträde
     if ($this->getTilltrade() == "alla") {
         return true;
     }
     // ägare har självklart tilltrade till sina egna album
     if ($this->isAgare()) {
         return true;
     }
     // gå igenom användarens grupper och se om nån av dem har direkt tillträde
     $grupper = Grupp::listByMedlem($medlem);
     if ($grupper != null) {
         foreach ($grupper as $grupp) {
             if ($this->harGruppTilltrade($grupp->getId(), $this->getId()) == true) {
                 // tillträde via grupp
                 return true;
             }
         }
     }
     // om ALLA grupper har tillgång,
     // hämta alla användarens grupper OCH ägarens grupper och se om de båda är medlemmar i samma grupp
     if ($this->getTilltradeAllaGrupper() == "ja") {
         $agare_grupper = Grupp::listByMedlem($this->getMedlem());
         if ($grupper != null && $agare_grupper != null) {
             foreach ($grupper as $grupp) {
                 foreach ($agare_grupper as $agare_grupp) {
                     if ($agare_grupp->getId() == $grupp->getId()) {
                         // gemensam grupp
                         return true;
                     }
                 }
             }
         }
     }
     // ta reda på om ägaren av fotoalbumet och besökaren är medlemmar i samma företag
     // samt om företagsmedlemmar har tilltrade till detta fotoalbum
     $foretag = Foretag::loadByMedlem($medlem);
     if ($foretag != null) {
         $foretag_id = $foretag->getId();
     }
     $medlem_foretag = Foretag::loadByMedlem($this->getMedlem());
     if ($medlem_foretag != null) {
         $medlem_foretag_id = $medlem_foretag->getId();
     }
     if ($foretag != null && $medlem_foretag != null && $foretag_id == $medlem_foretag_id && $this->harForetagTilltrade() == true) {
         return true;
     }
     return false;
 }
<?php

require $_SERVER["DOCUMENT_ROOT"] . "/php/init.php";
Security::demand(ADMIN);
if (!empty($_GET['date'])) {
    $date = $_GET['date'];
    if (is_numeric($date) && strlen($date) == 8) {
        echo "This is executed via Foretag::saveAndEndForetagsTavling(" . $date . ") \nSee also the logfile, /usr/local/motiomera/log/motiomera.log \n\n";
        Misc::logMotiomera("Manual start of 'End and save competition data' started from Admin by " . $ADMIN->getANamn() . ", Date: " . $date, 'INFO');
        Foretag::saveAndEndForetagsTavling($date);
    } else {
        echo '<h3>Det verkar vara fel format på datumet!</h3>';
    }
} else {
    echo '<h3>Det saknas paramatrar!</h3>';
}
?>

Beispiel #18
0
<?php

/* ajax call - return all active companys for the actual date
 * krillo 2012-09-07
 */
require_once $_SERVER["DOCUMENT_ROOT"] . "/php/init.php";
error_reporting(E_ALL);
ini_set('display_errors', '1');
!empty($_REQUEST['date']) ? $date = $_REQUEST['date'] : ($date = 'false');
//get all active companys, make checkboxes
$compArray = Foretag::getAllActiveCompanys($date);
$checkbox = '
<script type="text/javascript">
  jQuery(document).ready(function(){
  
   $("#all").click(function(event) {
      var all = $("#all:checked").val();
      if(all === undefined){
        $("[type=checkbox]").attr("checked", false);
      } else {
        $("[type=checkbox]").attr("checked", true);

      }  
    });
  });
</script>';
$checkbox .= '<table id=""><tr>';
$checkbox .= '<td><input type="checkbox" value="alla" id="all" name="all-companys" checked></td><td colspan="2"><label for="all">Alla eller ingen</label></td><tr/>';
$checkbox .= '<tr><th></th><th>Id</th><th>#</th><th>Företagsnamn</th><th>Tävlingsdatum</th><tr/>';
foreach ($compArray as $id => $comp) {
    $checkbox .= '<tr>
Beispiel #19
0
<?php

include $_SERVER["DOCUMENT_ROOT"] . "/php/init.php";
include '../php/libs/php-ofc-library/open-flash-chart.php';
$medlemGraf = array();
$mabraGraf = array();
if (!empty($_GET['lid'])) {
    $lag = Lag::loadById($_GET['lid']);
} elseif (!empty($_GET['fid'])) {
    $foretag = Foretag::loadById($_GET['fid']);
} elseif (!empty($_GET['gid'])) {
    $klubb = Grupp::loadById($_GET['gid']);
} else {
    if ($_GET["id"] > 0) {
        $medlem = Medlem::loadById($_GET["id"]);
    } else {
        $medlem = $USER;
    }
}
$max_steg = 0;
$y_labels = array();
// generate some random data
srand((double) microtime() * 1000000);
$bar = new bar_outline(100, '#00ADDF', '#4AABCB');
$data = array();
$veckodagar = array("Måndag", "Tisdag", "Onsdag", "Torsdag", "Fredag", "Lördag", "Söndag");
$x_labels = array();
for ($i = -7; $i <= 0; $i++) {
    if (isset($medlem)) {
        $steg = Steg::getTotalStegByDay($i, $medlem);
    } elseif (isset($lag)) {
Beispiel #20
0
 public static function getTopplistaForetag($limit = null)
 {
     global $db;
     $l = "";
     //limiter
     if ($limit != null) {
         $l = " LIMIT {$limit}";
     }
     $sql = "SELECT sum(steg) AS steg, a.id FROM mm_foretag a, mm_foretagsnycklar b, mm_steg c \n\t\t\tWHERE c.medlem_id = b.medlem_id\n\t\t\tAND a.id = b.foretag_id \n\t\t\tGROUP BY a.id ORDER BY steg DESC" . $l;
     $foretagList = $db->valuesAsArray($sql);
     //$foretagList = Foretag::listAll();
     $topplista = array();
     foreach ($foretagList as $row) {
         if ($row['id'] != 0) {
             $topplista[] = Foretag::loadById($row['id']);
         }
     }
     //ksort($topplista);
     $topplista = array_reverse($topplista);
     /* $topplista2 = array();
        foreach($topplista as $pos){
        foreach($pos as $ftag)
        $topplista2[] = $ftag;
        } */
     return $topplista;
 }
Beispiel #21
0
         }
         if (strlen($antal) > 0) {
             $antal = substr($antal, 0, strlen($antal) - 1);
         }
         //Order::krilloLogToFile("refid: $refId, kampanjkod: $kampanjkod, antal: $antal");
         //$objekt->genereraLag();
         $order->gorUppslag($kampanjkod, $antal);
         //send the order
     } else {
         throw new OrderException("", -1);
     }
     break;
 case isset($_REQUEST["typ"]) && $_REQUEST["typ"] == "foretag_again":
     // renewal of company contest
     $typ = "foretag_again";
     $objekt = Foretag::loadById($_REQUEST["fid"]);
     $kontotyp = "RE04";
     $antal = $objekt->getAntalAnstallda();
     $order = new Order($typ, $objekt, $kontotyp, $antal, $kanal, $compAffCode, 0);
     $order->setForetag($objekt);
     $order->setCompanyName($objekt->getNamn());
     $order->commit();
     $order->gorUppslag();
     break;
 default:
     $errMess = "Felaktig ordertyp ";
     if (isset($_REQUEST["typ"])) {
         $errMess = $errMess . "  ->" . $_REQUEST["typ"] . "<-";
     }
     throw new OrderException($errMess, -1);
     break;
Beispiel #22
0
!empty($_REQUEST['city']) ? $order->city = $_REQUEST['city'] : ($order->city = '');
!empty($_REQUEST['country']) ? $order->country = $_REQUEST['country'] : ($order->country = '');
$order->street = $order->street1;
!empty($order->street2) ? $order->street = $order->street . ' ' . $order->street2 : null;
!empty($order->street3) ? $order->street = $order->street . ' ' . $order->street3 : null;
$redirPage = $SETTINGS["url"] . "/pages/foretag_kampanj.php?anamn=" . $order->anamn . "&mailone=" . $order->email . '&firstname=' . $order->fname . '&lastname=' . $order->lname . '&co=' . $order->co . '&phone=' . $order->phone . '&street1=' . $order->street1 . '&street2=' . $order->street2 . '&street3=' . $order->street3 . '&zip=' . $order->zip . '&city=' . $order->city;
if ($order->compcampcode == '' or $order->email == '' or $order->fname == '' or $order->lname == '') {
    Misc::logMotiomera("Error action/medlem_foretagskod.php  Fält saknas!  \n Params:\n" . print_r($order, true) . "\n ", 'ERROR');
    $redirPage .= "&msg=fields_missing";
    header('Location: ' . $redirPage);
}
$companyId = Foretag::getCompanyIdByCampaignMemberCode($order->compcampcode);
if (is_numeric($companyId) && $companyId > 0) {
    //everthing looks fine sofar, create the user
    try {
        $foretag = Foretag::loadById($companyId);
        $kommun = Kommun::loadById($order->kid);
        $kontotyp = '';
        //legacy or not used right now
        $maffcode = '';
        //legacy or not used right now
        $medlem = new Medlem($order->email, $order->anamn, $kommun, $order->sex, $order->fname, $order->lname, $kontotyp, $maffcode);
        $medlem->confirm($order->pass);
        $medlem->setAddress($order->street);
        $medlem->setCo($order->co);
        $medlem->setZip($order->zip);
        $medlem->setCity($order->city);
        $medlem->setPhone($order->phone);
        $medlem->setCountry($order->country);
        $medlem->setEpostBekraftad(1);
        //medlem valid
Beispiel #23
0
<?php

require_once $_SERVER["DOCUMENT_ROOT"] . "/php/init.php";
Security::demand(USER);
$smarty = new MMSmarty();
$smarty->assign("pagetitle", "Redigera fotoalbum");
// hämta information om fotoalbumet vi ska ändra
$fotoalbum = Fotoalbum::loadById($_GET["fid"]);
if (!$fotoalbum->isAgare()) {
    // Besökaren äger INTE detta album
    $urlHandler->redirect("Fotoalbum", "URL_LIST");
    exit;
}
$smarty->assign("fotoalbum", $fotoalbum);
$smarty->assign("fid", $_GET["fid"]);
$grupper = Grupp::listByMedlem($USER);
$foretag = Foretag::loadByMedlem($USER);
if ($foretag) {
    if ($fotoalbum->harForetagTilltrade($foretag->getId(), $fotoalbum->getId())) {
        $smarty->assign("foretag_checked", "checked");
    }
}
$smarty->assign("grupper", $grupper);
$smarty->assign("foretag", $foretag);
$smarty->display('fotoalbumandra.tpl');
Beispiel #24
0
            //print_r($allaLag);
            //get all members for the submitted company
            //Deltagartoppen  no limit - all members (-1)
            $allCompMembArray = Tavling::getResultAllMembers($tid, -1, $fid);
            //print_r($allCompMembArray);
            //get all members for the whole contest    Deltagartoppen
            //if the member ranks lower than DELTAGARTOPPEN_MAX then add her the the array
            $allMembArray = Tavling::getResultAllMembers($tid, DELTAGARTOPPEN_MAX);
            //print_r($allMembArray);
            $lagArray = Tavling::getResultTeam($tid);
            //get all the teams with median  Lagtoppen
            //print_r($foretagLagArray);
            $allForetagArray = Tavling::getResultCompany($tid, FORETAGSTOPPEN_MAX);
            //get all companys average   Foretagstoppen
            //print_r($allForetagArray);
            $foretag = Foretag::loadById($fid);
            break;
        default:
            throw new UserException('Något har gått fel', 'Prova igen senare eller rapportera felet till support@motiomera.se');
            break;
    }
}
$smarty->assign("foretagArray", $foretagArray);
$smarty->assign("allaLag", $allaLag);
$smarty->assign("foretagLagArray", $foretagLagArray);
$smarty->assign("allCompMembArray", $allCompMembArray);
$smarty->assign("allMembArray", $allMembArray);
$smarty->assign("lagArray", $lagArray);
$smarty->assign("allForetagArray", $allForetagArray);
//these two highlites the user on tavlingsresultat.php !?!?
$smarty->assign("tavlingsresultatsidan", true);
Beispiel #25
0
         $aktivitet = Aktivitet::loadById($_POST["id"]);
         $aktivitet->setNamn($_POST["namn"]);
         $aktivitet->setEnhet($_POST["enhet"]);
         $aktivitet->setVarde($_POST["varde"]);
         $aktivitet->setBeskrivning($_POST["beskrivning"]);
         $aktivitet->setSvarighetsgrad($_POST['svarighetsgrad']);
         $aktivitet->commit();
     }
     $urlHandler->redirect("Aktivitet", URL_ADMIN_LIST);
     break;
 case "mergeorder":
     //added by krillo 090908
     $foretagIdFrom = $_POST['foretagid_from'];
     $foretagIdTo = $_POST['foretagid_to'];
     if ($foretagIdFrom > 0 && $foretagIdTo > 0) {
         $status = Foretag::mergeOrderNycklar($foretagIdFrom, $foretagIdTo);
         $urlHandler->redirect("MergeOrder", "URL_ADMIN_MERGE", $status);
     } else {
         $urlHandler->redirect("MergeOrder", "URL_ADMIN_MERGE", "missing_params");
     }
     break;
 case "medlem":
     $passmsg = '';
     $medlem = Medlem::loadById($_POST["medlem_id"]);
     //probably not used any more - krillo 2010-07-29
     if (!empty($_POST['sendPassword'])) {
         try {
             Medlem::nyttLosen($medlem->getEpost());
         } catch (MedlemException $e) {
             if ($e->getCode() == -17) {
                 throw new UserException("Felaktig e-postadress", "E-postadressen är inte knuten till något konto.");
Beispiel #26
0
 public function setForetag(Foretag $foretag)
 {
     $this->foretag = $foretag;
     $this->foretag_id = $foretag->getId();
 }
Beispiel #27
0
<?php

include $_SERVER["DOCUMENT_ROOT"] . "/php/init.php";
$felInloggString = 'Användarnamnet eller lösenordet är felaktigt.<br />Prova att logga in igen om du tror att du har skrivit fel.<br /><br/>' . '<a href="../pages/foretaglogin.php">Tillbaka</a>';
if (isset($FORETAG)) {
    // Redan inloggad
    header("Location: /pages/foretag.php");
}
$remember = isset($_POST["autologin"]) ? true : false;
try {
    $status = Foretag::loggaIn($_POST["username"], $_POST["password"], $remember);
} catch (ForetagException $e) {
    if ($e->getCode() == -5) {
        throw new UserException("Felaktig inloggning", $felInloggString);
    } else {
        if ($e->getCode() == -15) {
            throw new UserException("Kontot ej aktiverat", "Du måste aktivera ditt konto för att kunna logga in.");
        } else {
            if ($e->getCode() == -19) {
                $urlHandler->redirect("Medlem", URL_BUY, $e->getMedlemId());
            }
        }
    }
}
if (!isset($status) || !$status) {
    // Felaktigt inlogg
    throw new UserException("Felaktig inloggning", $felInloggString);
} else {
    $foretag = Foretag::getInloggad();
    $urlHandler->redirect("Foretag", URL_EDIT);
}
Beispiel #28
0
} else {
    $limit = 40;
}
if (!empty($_GET['sort'])) {
    $sort = $_GET['sort'];
} else {
    $sort = "id";
}
//only get field when search is set
if (!empty($_GET['search'])) {
    $search = $_GET['search'];
    $field = $_GET["field"];
} else {
    $search = null;
    $field = null;
}
$listForetag = Foretag::listForetag($offset, $limit, $field, $search, $way, $showValid);
$smarty->assign("search", $search);
$smarty->assign("offset", $offset);
$smarty->assign("way", $way);
$smarty->assign("limit", $limit);
$smarty->assign("field", $field);
$smarty->assign("checked", $checked);
$smarty->assign("searchOpt", array("namn" => "Företagsnamn", "id" => "Id", "epost" => "E-Mail"));
if ($field == null) {
    //just to keep dropdown in sync with last search
    $field = "id";
}
$smarty->assign("searchSel", $field);
$smarty->assign("listForetag", $listForetag);
$smarty->display('listforetag.tpl');
Beispiel #29
0
<?php

require $_SERVER["DOCUMENT_ROOT"] . "/php/init.php";
$smarty = new AdminSmarty();
$foretag = Foretag::loadById($_GET["fid"]);
$smarty->assign("foretag", $foretag);
$smarty->display('editforetag.tpl');
Beispiel #30
0
             if (count($grupper) == 1) {
                 $grupp = Grupp::loadById($grupper[0]);
                 $tilltrade = "Gruppen " . $grupp->getNamn();
             } else {
                 $tilltrade = "Följande grupper: <strong>";
                 for ($x = 0; $x < count($grupper); $x++) {
                     $grupp = Grupp::loadById($grupper[$x]);
                     $tilltrade .= $grupp->getNamn() . ", ";
                 }
                 $tilltrade = substr($tilltrade, 0, strlen($tilltrade) - 2);
                 $tilltrade .= "</strong>";
             }
         }
     }
     if ($quiz->harForetagTilltrade() == true) {
         $foretag = Foretag::loadByMedlem($quiz->getMedlem());
         if ($grupper != null || $quiz->getTilltradeAllaGrupper() == "ja") {
             // både grupper och företag har tillgång
             $tilltrade .= " samt företaget <strong>" . $foretag->getNamn() . "</strong>";
         } else {
             // endast företag har tillgång
             $tilltrade = "Endast företaget <strong>" . $foretag->getNamn() . "</strong>";
         }
     }
     if (isset($foretag) || $grupper != null || $quiz->getTilltradeAllaGrupper() == "ja") {
         $tilltrade .= " har tillträde till detta quiz";
     } else {
         $tilltrade = "Ingen har tillträde till detta quiz";
     }
     $smarty->assign("tilltrade", $tilltrade);
 }