DWE

{{  \Carbon\ Carbon :: parse ( $salesmantarget -> month_year )-> format ( 'F j, Y' )  }}              <?php                  $OldDate  =  strtotime ( $salesmantarget -> month_year );                $NewDate  =  date ( 'M j, Y' ,  $OldDate );                $diff  =  date_diff ( date_create ( date ( "M j, Y" )), date_create ( $NewDate ));                               if ( $diff -> format ( "%R%a days" ) >  0 )           ...

When building connection using mongoose you might get an error saying Current server discovery and monitoring engine is deprecated.  Error:  current Server Discovery and Monitoring engine is deprecated, and will be removed in a future version. To use the new Server Discover and Monitoring engine, pass option { useUnifiedTopology: true } to the MongoClient constructor. So, basically two of the options need to be passed to the mongoose.connect method.  so these are:{ useNewUrlParser: true} and {useUnifiedTopology: true} See the example below: mongoose . connect ( "mongodb://localhost:27017/fruitsDB" , {    useNewUrlParser :   true ,    useUnifiedTopology :   true , }); Here, fruitsDB is the database name. Now, if you run your file say for example app.js, you will not that error again.

Why MongoDB? Answer:  MongoDB stores data in flexible , JSON-like documents. Think like this is json database. What makes everything easy with json database is maping of the object. when you store anything in tables,rows and columns, accessing the data can be little bit challenging, and can be costly process  for your processor. But on the other hand, in the NoSql since everything is stored in mapping of key value pair, it is easier+faster and everything becomes easy  and simple with that. Scalability is challenging in mysql database.  This kind of scaling is super easy  in mongoDB . So it's getting high in demand on scalability. changing schema is so much easy. Drawbacks with mysql and other relational database is:  1) Hard to understand 2) Adding features harder 3) Inefficiant MongoDB solved this problems. who is using mongoDB? Amazon web services, Microsoft Azure, Google Cloud Platform a...

Install this: https://wkhtmltopdf.org/downloads.html then install this two, $ composer require h4cc/wkhtmltopdf-i386 0.12.x $ composer require h4cc/wkhtmltoimage-i386 0.12.x Then, composer require barryvdh/laravel-snappy Then, php artisan vendor:publish --provider= " Barryvdh\Snappy\ServiceProvider " And Now, copy the wkhtmltopdf.exe and wkhtmltoimage.exe files to the above h4cc folder which is present inside vendor folder of laravel. and set the path to snappy.php file-> see the snappy.php file which is given below: [NOTE: see the code which i've commented out. You can run & check every line of code] Route :: get ( '/' ,  function  () {      $data  = [         [              'name' => 'Audi' ,              'logo' => 'audi.jpg' ...

When you create a brand new project you have users table and User model already by default. So, now create another table with model: php artisan make:model Role -m This will create Role model as well as roles table. Now as it is many to many relation. So we need a pivot table. Pivot table naming convention: role_user Here role is written first as because alphabetically r comes before u. and laravel eloquent relationship takes in this way. So, you should remember this always. and use _ in between role and user. like: role_user So, let's create role_user table. php artisan make:migration create_role_user_table --create=role_user naming covention of pivot says that role_user table is singular. users table includes: id name, email pivot table role_user includes: user_id role_id roles table includes: id name migrate it all. Many to Many Relation: Go to User model and write: public function roles(){  r...

Suppose you have two tables: users and posts tables. users table includes: id ,name,email posts table includes: id,title,body, user_id One to many relationship: Go to User model and write: public function posts(){  return $this->hasMany('App\Post'); } Look at the function naming convention. It's plural as it is one to many relationship. Store: $user->posts()->save($post); Here, $user variable comes from findorfail($id). and $post variable has taken the requested data from user. I haven't shown all of this in details here as it is only to understand how one to many relationship actually works. Show: foreach($user->posts as $post){    echo $post->title."<br>"; } Update: $user->posts()->where('id','=',2)->update(['title'=>'your updated title','body'=>'your updated body'); Delete: $user->posts->whereId(1)->delete(); To delete all t...

One to one relationship: Suppose you have two tables users and addresses: Users table: id ,name,email Addresses table: id,name, user_id In the address table the user_id will come from the users table. Be careful about the naming convention. Your Model name is User so table name is users so to get id from users table to addresses table you have to write according to the model name in the field of address like user_id . So to declare one-to-one relationship: Just think that user can have only one address. So,  go to User model and write: public function address(){  return $this->hasOne('App\Address'); } here as this is one to one we are using singular function name which is address(). Store: $user->address()-> save($address); [Here, $user is finding the user by id, and $address is saving the requested address] Show: To show the address name $user->address->name; Update: $address = Address::whereUserId(1)->first(); $address...