Laravel Eloquent sum relationship where colum condition

$value = ‘somevalue’;

$someTotal = \App\ModelName::WhereHas(‘relationName’, function($query) use ($value) {
$query->where(‘someColumn’, $value);
})->sum(‘ColumnToSum’);

new database

CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_unicode_ci

ubuntu 14 mysql 5.7

1. wget https://dev.mysql.com/get/mysql-apt-config_0.8.9-1_all.deb

2. dpkg -i mysql-apt-config_0.8.9-1_all.deb

3. apt update

4. apt install mysql-server

5. mysql –version

6. mysql_secure_installation

7. /etc/mysql/mysql.conf.d/mysqld.cnf
– find bind-address and comment it

8. restart mysql

// PHPADMIN

1. apt-get install apache2
2. add-apt-repository ppa:ondrej/php
3. apt-get update
4. apt-get install php

5. apt-get install phpmyadmin php-mbstring php-gettext
6. phpenmod mcrypt
7. phpenmod mbstring
8. systemctl restart apache2

// Secure phpmyadmin

1. nano /etc/apache2/conf-available/phpmyadmin.conf add AllowOverride All after «DirectoryIndex index.php» line.
2. systemctl restart apache2
3. nano /usr/share/phpmyadmin/.htaccess
paste next text

AuthType Basic
AuthName «Restricted Files»
AuthUserFile /etc/phpmyadmin/.htpasswd
Require valid-user

4. htpasswd -c /etc/phpmyadmin/.htpasswd username