grim-reapper

<?php

$totals = DB::table('subscribers')
    ->addSelect(DB::raw('count(*) as all'))
    ->addSelect(DB::raw("sum(case when status = 'confirmed' then 1 else 0 end) as confirmed"))
    ->addSelect(DB::raw("sum(case when status = 'unconfirmed' then 1 else 0 end) as unconfirmed"))
    ->addSelect(DB::raw("sum(case when status = 'cancelled' then 1 else 0 end) as cancelled"))
    ->addSelect(DB::raw("sum(case when status = 'bounced' then 1 else 0 end) as bounced"))
    ->addSelect(DB::raw("sum(case when status = 'inactive' then 1 else 0 end) as inactive"))
    ->get();

grim-reapper

Laravel Developer - Interview Exercise

• Setup a fresh Laravel 5.8 application.
• Use Tailwind CSS as the CSS framework.
  • CDN version is fine.
  • Bonus points if installed via NPM.
• Create a new contact page at /contact.
• Create a contact form on the page.
• The form should be built as a Vue component.
• The form should submit via ajax.

grim-reapper

Model::

  /*Select*/
  select('col1','col2')
  ->select(array('col1','col2'))
  ->select(DB::raw('businesses.*, COUNT(reviews.id) as no_of_ratings, IFNULL(sum(reviews.score),0) as rating'))  
  ->addSelect('col3','col4')
  ->distinct() // distinct select
  
  /*From*/

grim-reapper

var keyMatch = function(o,r){

    var c  = 0;
    var nO = {};

    Object.keys(o).forEach(function(k){
        c++;
        no[k] = k.match(r) ? o[k] : void 0;
    });

grim-reapper

<?php 
public function replicateWithRelations(QuestionCategory $questioncategory)
    {
        $newCategory = $questioncategory->replicate();
        $newCategory->name = "Kopyası: ".$questioncategory->name;
        $newCategory->push();

        $questioncategory->relations = [];

        //load relations on EXISTING MODEL

grim-reapper

<?php
namespace App\Traits;

/**
 * Allows saving models without triggering observers
 */
trait SaveQuietly
{
	/**
	 * Save model without triggering observers on model

grim-reapper

/**
* Swap the elements in an array at indexes x and y.
*
* @param (a) The array.
* @param (x) The index of the first element to swap.
* @param (y) The index of the second element to swap.
* @return {Array} The input array with the elements swapped.
*/
var swapArrayElements = function (a, x, y) {
  if (a.length === 1) return a;

grim-reapper

<?php

// Converts a number into a short version, eg: 1000 -> 1k
// Based on: http://stackoverflow.com/a/4371114
function number_format_short( $n, $precision = 1 ) {
	if ($n < 900) {
		// 0 - 900
		$n_format = number_format($n, $precision);
		$suffix = '';
	} else if ($n < 900000) {

grim-reapper

# List all containers (only IDs)
docker ps -aq

# Stop all running containers
docker stop $(docker ps -aq)

# Remove all containers, maybe we need -f| --force option for force delete running container
docker rm $(docker ps -aq)

# Remove all images

grim-reapper

<?php
function time2str($ts) {
    if(!ctype_digit($ts)) {
        $ts = strtotime($ts);
    }
    $diff = time() - $ts;
    if($diff == 0) {
        return 'now';
    } elseif($diff > 0) {
        $day_diff = floor($diff / 86400);