jblac

<?php
    
    $sql = "SELECT o.name AS objects_name, o.desc AS objects_desc FROM objects AS o WHERE MATCH(o.name, o.desc) AGAINST ('tak')
    UNION ALL(SELECT c.name AS communes_about, c.about AS communes_about WHERE MATCH (c.name, c.about) AGAINST ('tak'))
    UNION ALL(SELECT d.name AS district_name, d.about AS district_about FROM district AS d WHERE MATCH (d.name, d.about) AGAINST ('tak'))";

jblac

[RuntimeException]                                                                                                                                  
  Could not load package ztec/security-active_directory in http://packagist.org: [UnexpectedValueException] Could not parse version constraint v4.0-stable

{
    "hash": "814f8948fa759aad6359a64fb416a9fb",
    "packages": [
        {
            "package": "doctrine/common",
            "version": "2.3.x-dev",
            "source-reference": "605b1b8b5a7bc8daf9111fb35483e5708e30de35",

jblac

Loading composer repositories with package information
Installing dependencies from lock file
Warning: Your lock file is in a deprecated format. It will most likely take a *long* time for composer to install dependencies, and may cause dependency solving issues.
Warning: The lock file is not up to date with the latest changes in composer.json. You may be getting outdated dependencies. Run update to update them.
Your requirements could not be resolved to an installable set of packages.

  Problem 1
    - symfony/monolog-bundle 2.1.x-dev requires monolog/monolog >=1.0,<1.3-dev -> satisfiable by monolog/monolog 1.0.0, monolog/monolog 1.0.1, monolog/monolog 1.0.2, monolog/monolog 1.1.0, monolog/monolog 1.2.0, monolog/monolog 1.2.1.
    - symfony/monolog-bundle 2.1.x-dev requires monolog/monolog >=1.0,<1.3-dev -> satisfiable by monolog/monolog 1.0.0, monolog/monolog 1.0.1, monolog/monolog 1.0.2, monolog/monolog 1.1.0, monolog/monolog 1.2.0, monolog/monolog 1.2.1.
    - Can only install one of: monolog/monolog 1.0.

jblac

var loc = location.pathname.replace(/\/([^.]+)\//g,'');
			var current = $nav.find('a[href="'+loc+'"]');
			
			if(current.parent().parent().is('#nav')){
				current.addClass('active');
			}else{
				current.parent().parent().parent().find('a').eq(0).addClass('active').next().show();
				current.addClass('active');
	
			}

jblac

var loc = location.pathname.replace(/\/([^.]+)\//g,'');
			var current = $nav.find('a[href="'+loc+'"]');
			
			if(current.parent().parent().is('#nav')){
				current.addClass('active');
			}else{
				current.parent().parent().parent().find('a').eq(0).addClass('active').next().show();
				current.addClass('active');
	
			}

jblac

role_hierarchy:
        ROLE_SALES_REP:
            - ROLE_USER
            - ROLE_CAN_SEARCH
        ROLE_COLLECTIONS_REP:
            - ROLE_USER
            - ROLE_CAN_SEARCH
        ROLE_TEAM_LEAD:
            - ROLE_USER
            - ROLE_TIMECLOCK_MANAGER

jblac

        $beg = date('Y-m-d 00:00:00', strtotime($beg)); //Fixed the bug
        $fin = date('Y-m-d 23:59:59', strtotime($fin));

        $dql = "SELECT DISTINCT(u.id) AS agent_id FROM EcsTimeclockBundle:TimeClock t
                LEFT JOIN t.noteBy u WHERE t.daydate BETWEEN :beg AND :fin AND u.employeejob = :tpe";

        $query = $this->em->createQuery($dql);
        $query->setParameters(array('beg' => $beg, 'fin' => $fin, 'tpe' => $type));

jblac

<VirtualHost *:80>
	ServerName railsapp.dev
	ServerAlias www.railsapp.dev
	DocumentRoot /var/www/railsapp/public/
	RailsEnv development
	<Directory var/www/railsapp/public>
		Allow from all
		Options -MultiViews
	</Directory>
</VirtualHost>

jblac

$dql = "SELECT p.postDate, co.company_name,
                COUNT(*) AS `postDatesScheduled`,
                COUNT(IF(c.postDateChargedStatus_id > 1, 1, NULL)) AS `postDateReady`,
                SUM( IF(c.postDateChargedStatus_id = 6, 1, NULL)) AS `postDatesCharged`,
                SUM( IF(c.`fwCompletionDate`, 1, NULL)) AS `postDatesComplete`,
                SUM( authOnlyAmount ) AS `fwPotential`,
                SUM( IF(p.`fwfAuthed`, p.`authOnlyAmount`, NULL)) AS `fwCharged`,
                SUM( IF(c.`fwCompletionDate`, p.`authOnlyAmount`, NULL)) AS `fwCapt`
                FROM customer c
                JOIN Purchase p ON p.customer_Id = c.Id

jblac

$rsm = new ResultSetMapping();
        $rsm->addScalarResult('postDate', 'postDate');
        $rsm->addScalarResult('company_name', 'company_name');
        $rsm->addScalarResult('postDatesScheduled', 'postDatesScheduled');
        $rsm->addScalarResult('postDateReady', 'postDateReady');
        $rsm->addScalarResult('postDatesCharged', 'postDatesCharged');
        $rsm->addScalarResult('postDatesComplete', 'postDatesComplete');
        $rsm->addScalarResult('fwPotential', 'fwPotential');
        $rsm->addScalarResult('fwCharged', 'fwCharged');
        $rsm->addScalarResult('fwCapt', 'fwCapt');