Related questions

Additional data in foreach

2018-09-25 13:51 slickness imported from Stackoverflow

In my show function in which you can watch every single group, I load all articles with the same tags. And the article with the most votes will be displayed separately at the top. In addition, I indicate the average rating of the items in this group. This is how my function looks like:

public function show($id)
    {
        $group = group::find($id);

            $tagIdArray = $group->tags->pluck('id')->all();

            $mostvotedarticle = Article::where('type', 4)->whereIn('privacy', [1, 3])
                ->whereHas('tags', function($query) use ($tagIdArray) {
                    $query->whereIn('tags.id', $tagIdArray);
                }, '>=', count($tagIdArray))
                ->orderByVotes()->first();

            $articledown = Article::where('status', 1)->whereHas('tags', function($query) use ($tagIdArray) {
                $query->whereIn('tags.id', $tagIdArray);
            }, '>=', count($tagIdArray))->downVotesAll()->count();

            $articleup = Article::where('status', 1)->whereHas('tags', function($query) use ($tagIdArray) {
                $query->whereIn('tags.id', $tagIdArray);
            }, '>=', count($tagIdArray))->upVotesAll()->count();

            $ratio = null;

            if($articleup + $articledown == 0) {
                $ratio = 0;
            } else {
                $ratio = ($articleup*100)/($articleup + $articledown);
            }

        return view('singlegroup',compact('groups','mostvotedarticle', 'ratio'));
    }

On a overview page, the individual groups are displayed with a foreach loop:

@foreach ($groups as $group)
        {{$group->name}}                      
        <img src="-----load mostvotedarticle that is in this group------" alt="" />
        <div class="progress-bar-primary" style="width:{{$ratio}}%;">
@endforeach

How can I have the mostvotedarticle and group ratings displayed in the foreach loop?

This is my previous index function:

public function index()
    {
        $user = Auth::user();
        $groups = $user->groups()->latest()->with('tags')->paginate(20);

        return view('groups', compact('groups'));
    }

See also questions close to this topic

  • Is it possible to submit an array of objects?

    I'm using Laravel 5.3, and I'm having trouble submitting arrays of objects to my controller. Is it possible? And if not, is there a workaround so that I can submit multiple objects at once?

    Example request:

    let req = {
    'data[]': [
        { id: 1, name: 'test1' },
        { id: 2, name: 'test2' }
    ]
};

    Then, to test, I simply returned the contents of the request:

    public function testArray(Request $request) {
    return response()->json($request->all());
}

    And got this result:

    data: [
    "[object Object]",
    "[object Object]"
]
  • How to make wifidog GET response from Laravel

    I have wifidog installed on a TP-LINK (openwrt 18.06.2)

    I have wifidog-auth-laravel installed on a OVH Debian github /wifidog/wifidog-auth-laravel)

    If I use curl, chrome and wget; I get the pong response for the authetication url

    But if wifidog attempts to get the pong response I get a 301 Permanantly moved response.

    How can that be?

    [7][Mon May 20 13:44:54 2019][5977](centralserver.c:302) Level 1: Connecting to auth server example.com:80
[7][Mon May 20 13:44:54 2019][5977](centralserver.c:331) Level 1: Successfully connected to auth server example.com:80
[7][Mon May 20 13:44:54 2019][5977](centralserver.c:141) Unlocking config
[7][Mon May 20 13:44:54 2019][5977](centralserver.c:141) Config unlocked
[7][Mon May 20 13:44:54 2019][5977](centralserver.c:147) Connected to auth server
[6][Mon May 20 13:44:54 2019][5977](wd_util.c:116) AUTH_ONLINE status became ON
[7][Mon May 20 13:44:54 2019][5977](simple_http.c:77) Sending HTTP request to auth server: [GET /ping/?gw_id=EC086B35444C&sys_uptime=1820&sys_memfree=6096&sys_load=0.70&wifidog_uptime=3 HTTP/1.0
User-Agent: WiFiDog 1.2.1
Host: example.com

]

[7][Mon May 20 13:44:54 2019][5977](simple_http.c:87) Reading response
[7][Mon May 20 13:44:54 2019][5977](simple_http.c:111) Read 725 bytes
[7][Mon May 20 13:44:54 2019][5977](simple_http.c:124) HTTP Response from 

Server: [HTTP/1.1 301 Moved Permanently
Date: Mon, 20 May 2019 13:44:54 GMT
Server: Apache/2.4.25 (Debian)
Location: http://example.com/ping?gw_id=EC086B35444C&sys_uptime=1820&sys_memfree=6096&sys_load=0.70&wifidog_uptime=3
Content-Length: 415
Connection: close
Content-Type: text/html; charset=iso-8859-1

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>301 Moved Permanently</title>
</head><body>
<h1>Moved Permanently</h1>
<p>The document has moved <a href="http://example.com/ping?gw_id=EC086B35444C&amp;sys_uptime=1820&amp;sys_memfree=6096&amp;sys_load=0.70&amp;wifidog_uptime=3">here</a>.</p>
<hr>
<address>Apache/2.4.25 (Debian) Server at example.com Port 80</address>
</body></html>
]
[4][Mon May 20 13:44:54 2019][5977](ping_thread.c:191) Auth server did NOT say Pong!
[7][Mon May 20 13:44:54 2019][5977](firewall.c:140) Marking auth server down
  • How can i display the chart if i have choose an id in a foreach dropdown list 
    I want to choose the kind of coffee in a dropdown list and through that it should display or show the statistics in a chart. I have 3 tables.

    CREATE TABLE coffee ( coffeeId integer(20) NOT NULL, coffeeName varchar(20), );

    INSERT INTO coffee (coffeeId, coffeeName) VALUES (1, 'Arabica');

    CREATE TABLE coffee_roast ( roastId integer(20) NOT NULL, coffeeId intger(20) NOT NULL );

    INSERT INTO coffee_roast (roastId, coffeeId) VALUES (1, 1), (2, 1);

    CREATE TABLE coffee_temperature ( temperatureId int(20) NOT NULL, roastId int(20) NOT NULL, sensor01 int(11) NOT NULL, sensor02 int(11) NOT NULL, sensor03 int(11) NOT NULL, time double NOT NULL );

    INSERT INTO coffee_temperature (temperatureId, roastId, sensor01, sensor02, sensor03, time) VALUES (1, 1, 5, 1, 3, 1555482717.2457275), (2, 1, 7, 10, 8, 1555482720.2929125), (3, 1, 13, 15, 14, 1555482723.3680384), (4, 2, 298, 295, 299, 1555483129.2842128), (5, 2, 297, 297, 295, 1555483132.6669202), (6, 2, 299, 298, 298, 1555483135.71512);

    /* Database connection settings */

    $mysqli = new mysqli($host,$user,$pass,$db) or die($mysqli->error);

 $time = '';
$sensor01 = '';
$sensor02 = '';
$sensor03 = '';

//query to get data from the table
$sql = "SELECT * FROM `coffee_temperature` ";
$result = mysqli_query($mysqli, $sql);

//loop through the returned data
while ($row = mysqli_fetch_array($result)) {

    $time = $time . '"'. $row['time'].'",';
    $sensor01 = $sensor01 . '"'. $row['sensor01'].'",';
    $sensor02 = $sensor02 . '"'. $row['sensor02'] .'",';
    $sensor03 = $sensor03 . '"'. $row['sensor03'] .'",';
}

 $time = trim($time.",");
$sensor01 = trim($sensor01,",");
$sensor02 = trim($sensor02,",");
$sensor03 = trim($sensor03,",");

    ?>

    var ctx = document.getElementById("chart").getContext('2d'); var myChart = new Chart(ctx, { type: 'line', data: { labels: [], datasets: [{ label: 'Sensor01', data: [], backgroundColor: 'transparent', borderColor:'rgba(255,99,132)', borderWidth: 3 }, { label: 'Sensor02', data: [], backgroundColor: 'transparent', borderColor:'rgba(0,255,255)', borderWidth: 3 }, { label: 'Sensor03', data: [], backgroundColor: 'transparent', borderColor:'rgba(255, 246, 143, 1)', borderWidth: 3 }] }, options: { responsive: true, scales:{ yAxes: [{beginAtZero: false, setinterval: 3000}], xAxes: [{autoskip: true, maxTicketsLimit: 20}] }, tooltips:{mode: 'index'}, legend:{display: true, position: 'bottom', labels: {fontColor: 'black', fontSize: 16}} } }); Choose Coffee Bean Statistics @foreach($roast as $key => $roast) coffee_id }}">{{ $roast->coffeeName }} @endforeach

  • How to find custom field name to write a wp all import php function

    I need to set to null or 0 the price field from the XMl if a fiel called Trattativa_riservata=SI. If is NO, it leaves the price value as is from the XML. Someone can help me?

  • How to increase the performance of a partial match lookup function?

    The current performance of this function is to slow, currently I am working with a list of 500+ item codes on sheet1. The function searches in a range of 200 000 + items on sheet2 to find all matches including partial matches. This means that we include a wildcards before and after the lookup criteria to find all matches.

    Currently it takes over 15 mins to complete. Is there a better method to do this? To get this under 5 mins?

    Function ConcatIf(ByVal compareRange As Range, ByVal xCriteria As Variant, _
                        Optional ByVal stringsRange As Range, Optional Delimiter As String) As String

    Application.Calculation = xlCalculationManual
    Application.ScreenUpdating = False
    Application.DisplayStatusBar = False
    Application.EnableEvents = False
    ActiveSheet.DisplayPageBreaks = False

    Dim i As Long, j As Long, criteriaMet As Boolean

    Set compareRange = Application.Intersect(compareRange, _
                    compareRange.Parent.UsedRange)

    If compareRange Is Nothing Then Exit Function
    If stringsRange Is Nothing Then Set stringsRange = compareRange
    Set stringsRange = compareRange.Offset(stringsRange.Row - _ 
    compareRange.Row, stringsRange.Column - compareRange.Column)

        For i = 1 To compareRange.Rows.Count
            For j = 1 To compareRange.Columns.Count
               If (Application.CountIf(compareRange.Cells(i, j), _ 
    xCriteria)= 1) Then
                    ConcatIf = ConcatIf & Delimiter & _
    CStr(stringsRange.Cells(i, j))
                End If

            Next j
        Next i
        ConcatIf = Mid(ConcatIf, Len(Delimiter) + 1)

    Application.Calculation = xlCalculationAutomatic
    Application.ScreenUpdating = True
    Application.DisplayStatusBar = True
    Application.EnableEvents = True
    ActiveSheet.DisplayPageBreaks = True

End Function

    Example:

    +500 ITEM CODES 

    Sheet1:  

BCD  
CDF  
XLMH  
XPT  
ZPY

    200 000 + FULL ITEM CODES 

    Sheet2:  

FDBCDGH  
HSGDBCDSU  
GFD-CDFGDTR  
SBGCDFHUD  
GKJYCDFFDS  
DDFGFDXLMHGFD  
SDGXLMHSDFS  
SDGVSDXLMHFAMN  
DDDSXPTDFGFD  
JUYXPTFADS  
DDDFFZPYDGDFDF

    Outcome should be:

    Sheet1: 

    COLUMN A - COLUMN B  
BCD - FDBCDGH,HSGDBCDSU  
CDF - GFD-CDFGDTR,SBGCDFHUD,GKJYCDFFDS  
XLMH - DDFGFDXLMHGFD,SDGXLMHSDFS,SDGVSDXLMHFAMN  
XPT - DDDSXPTDFGFD,JUYXPTFADS  
ZPY - DDDFFZPYDGDFDF
  • Why the configuration setting 'cfg_file_path' is returning FALSE value with function ini_get() and returning proper value with function get_cfg_var()?

    I'm using PHP 7.3.5 on my laptop that runs on Windows 10 Home Single Language 64-bit operating system.

    I've installed the latest version of XAMPP installer on my laptop which has installed the Apache/2.4.39 (Win64) and PHP 7.3.5

    I executed below code and see the output in my web browser :

    <?php 
    echo 'Value using get_cfg_var() : '.get_cfg_var ('cfg_file_path');
    echo '<br>'; 
    echo 'Value using ini_get() : '.ini_get('cfg_file_path');

    echo '<br>';

    echo 'Value using get_cfg_var() : '.get_cfg_var ('display_errors');
    echo '<br>'; 
    echo 'Value using ini_get() : '.ini_get('display_errors');

    echo '<br>';

    echo 'Value using get_cfg_var() : '.get_cfg_var ('post_max_size');
    echo '<br>'; 
    echo 'Value using ini_get() : '.ini_get('post_max_size');
?>

    The output of above code is as below :

    Value using get_cfg_var() : C:\xampp\php\php.ini
Value using ini_get() :
Value using get_cfg_var() : 1
Value using ini_get() : 1
Value using get_cfg_var() : 8M
Value using ini_get() : 8M

    My question is why I'm getting FALSE value when I use the configuration setting cfg_file_path with the built-in function ini_get()?

    As per my knowledge both of the built-in functions ini_get() and get_cfg_var() are used to get the value of a configuration option/configuration setting. Actually, this is working fine when I tried other configuration settings(viz. display_errors and post_max_size) with both these functions.

    Then why it's not working with ini_get() and work properly with get_cfg_var() for configuration option cfg_file_path?

    I also noticed that, from the output of phpinfo() that I got into my browser I could see the settings display_errors and post_max_size but not the setting cfg_file_path. Why so?

    Why the setting cfg_file_path is not getting displayed in the output of phpinfo()? Where does it exist?

    Someone please clear all of my above doubts.

    Thank You.

  • Displaying multiple products with foreach loop with different rows in db

    I have an application with Orders. So in the db there is a record with TableID Date, Time, ProductID and how many times that product is ordered. When a product is ordered but its on the same table and date and time it should be on the same receipt. but it displays different(See photos). I already order them by date and time. but when i group it by TableNr it doesnt display multiple items from the same tableNr (see 2nd photo)

    Photo 1: enter image description here

    Photo 2: enter image description here

    db

    <?php

  $checkbestelling = "SELECT *, gerecht.Prijs*bestelling.Aantal AS Totaalprijs FROM  bestelling 
    LEFT JOIN menuitem ON bestelling.MenuItemID = menuitem.MenuItemID
    LEFT JOIN gerecht ON gerecht.GerechtID = menuitem.GerechtID ORDER BY Datum, Tijd ASC";
    foreach ($db->query($checkbestelling) as $bestellingen){ 
    ?>

 <div class="col-lg-4" style="margin-bottom:25px;">
        <div class="card mb-5 mb-lg-0">
          <div class="card-body">
            <h5 class="card-title text-muted text-uppercase text-center">Tafel <?php echo $bestellingen["Tafel"];?></h5>
            <h6 class="card-price text-center"><span class="period">Datum: <?php echo date("d-m-Y", strtotime($bestellingen["Datum"]));?></span></h6>
            <h6 class="card-price text-center"><span class="period">Tijd: <?php echo $bestellingen["Tijd"];?></span></h6>
            <hr>
           <ul class="list-group list-group-flush text-center">
            <li class="list-group-item nb">Product: <?php echo $bestellingen["Gerecht"];?></li>
            <li class="list-group-item nb">Aantal: <?php echo $bestellingen["Aantal"];?></li>
              <li class="list-group-item nb">Prijs: €<?php echo $bestellingen["Totaalprijs"];?></li>         
            </ul>
            <button type="button" class="btn btn-lg btn-block btn-primary bgcb" onclick="printDiv('printable')">Print bon</button>
            <button type="button" class="btn btn-lg btn-block btn-primary bgcr">Verwijder</button>
          </div>
        </div>
          </div>

    <?php } ?>
  • How to print Header

    How to print "Name" and "ID" using foreach loop?How to print particular column details?

    Have tried to catch hold of the key

    $student[0]="Subject";
$student[1]=" Marks<br>";

$student["Subject"]="English ";
$student["Marks"]=56;
foreach($student as $item)
echo $item;

$arr=array("first"=>array("Name"=>"ABC","ID"=>45),
   "second"=>array("Name"=>"XYZ","ID"=>56)
  );

foreach($arr as $element=>$key)
               {

                                    echo"<br>$element"
  foreach($key as $header)
  echo" $header";
                                  }

    Output-

    Subject Marks
English 56
first ABC 45
second XYZ 56
  • how to render files efficiently after ajax request

    For a filesystem, I use an ajax request to rename a directory or file.

    Scanning files in a directory:

    $files = array_diff( scandir($dir), array(".", "..", "tmp") );

    Part of the php code:

    if( isset($_POST['new_name']) ){        

// code for renaming goes here
    echo $_POST['old_name'] . 'renamed to ' . $_POST['new_name'];
exit;
}

    For renaming a directory or file, show filename, date, extension and so on..., I use a foreach and the structure looks like below:

    <div class="echo"><div>
<div class="dynamic-content">

foreach($files as $file) {

?>
 <!-- Rename-->     
<td class="td-rename">
  <h4>Rename File/Folder</h4>
  Current name: <b><?php echo basename($dir.'/'.$file); ?></b><br />
  <form class="rafform" method="post">
    <input type="hidden" class="old_name" name="old_name" value="<?php echo $dir . '/' . $file; ?>" />                                      
    <input  type="text" class="new_name form-control" name="new_name" placeholder="only a-z, A-Z, 0-9, -, _" value="" />
    <input type="submit" class="submitmodal rename btn " value="Rename" />                      
  </form>
</td>

<!-- below are coming more `td's` like:-->
<td class="td-filename">
…………
</td>    
<td class="td-date">
…………
</td>
<td class="td-extension">
…………
</td>
and so on...
<?php } ?> // end foreach
</div> <!-- end dynamic content-->

    My ajax request looks like this:

    $(document).on('submit' , ".rafform" , (function(e) {

e.preventDefault();

$.ajax({
url: "",
type: "post",
data:  new FormData(this),
cache: false,               
contentType: false,
processData: false,             
beforeSend: function () {
    window.location.hash='close'; /* show spinner and disappear upload modal */                 
    },
success: function(data) {

    $('.dynamic-content').load('index.php .dynamic-content > *');
    $('.echo').append(data);
    $('.uploadspinner').hide();                 
    $(".echolist").delay(5000).fadeOut(500);

},


});

}));

    So after each request: the echo from PHP is put in the div with class echo and to see the changes immediately, I do a load() of the same page index.php with only the content in the div with class dynamic-content. Because in this div, the files are rendered. The user can see immediately that the file is renamed.

    But now I notice, doing it this way, when a directory has a lot of subdirectories and files, rendering the files is getting slower and slower.

    Is there a faster way to render the files after an change (rename per example)? For me it is important that every change is immediately visible for the user! And if so, what will be the structure I have to use?

  • MATLAB: Use Fullfile to Load Multiple MAT Files

    I am trying to load multiple 3 MAT files using the fullfile function into the MATLAB workspace.

    I have grouped the 3 MAT files together by applying curly braces inside the fullfile function. However I'm getting an error, "Unable to read file 'f.mat.'"

    How do I load the multiple MAT files when using the fullfile function?

    apples.green = 12
apples.red = 12

grapes.red = 24
grapes.green = 26

peaches.red = 2
peaches.green = 2

folder = 'C:\Documents\MATLAB';

save(fullfile(folder, 'apples.mat'), '-struct', 'apples')
save(fullfile(folder, 'grapes.mat'), '-struct', 'apples')
save(fullfile(folder, 'peaches.mat'), '-struct', 'apples')

f = (fullfile(folder, {'egiTime9.mat'; 'egiLat9.mat'; 'egiPosition9.mat'}))
load('f.mat')
  • What’s the best way of saving/loading game data within an up to date object graph?

    I’m looking for some advice and best practices in handling serialization/deserialization of objects for use in an ARPG game I’m looking to write at some stage. Specifically, this question relates to saving data and re-loading that data with the correct information. This isn't game engine specific.

    Scenario: I have a class that presents a player (Player). Within that class, there is a property that stores the character’s role playing class (CharacterClass). The CharacterClass class describes a name and some minimum and maximum values for character attributes.

    public class Player
{
       public string Name { get; set; }

       public long Experience { get; set; }

       public CharacterClass CharacterClass { get; set; }

       ...
}

public class CharacterClass
{
       public string Name { get; set; }

       public MinMaxValue Strength { get; set; }

       public MinMaxValue Dexterity { get; set; }

       ...
}

    When I save this information via XML or JSON serialization, I’m saving the object graph/state as it is at the time. I can then load this at the game start-up to restore part of the player’s saved game.

    {  
   "Name":"Arthur",
   "Experience":0,
   "CharacterClass":{  
      "Name":"Mage",
      "Strength":{  
         "Min":10,
         "Max":80
      },
      "Dexterity":{  
         "Min":15,
         "Max":90
      }
   }
}

    The problem: What if properties within CharacterClass changes? Suppose the name changes or the character class attribute values change. The data for the CharacterClass class will be loaded from a file at game start-up separately but the disconnected data from the player save game file no longer contains an up-to-date version of the object.

    This same concept applies to a lot of ‘Game Objects’ that have connected classes as properties. Another example could include player equipment with affixes, suffixes, rarity, etc. Each one of these is either class or list of classes. If all these values are serialized, they may not represent the current data held in the master data store separate from the player save game data.

    Another concern discounting the data state is the size. Serializing all connected objects in the parent object saved would likely take up a massive amount of space.

    Potential solution: I could mark the CharacterClass property inside the Player class as ignored so it isn’t serialized and add a reference identifier string on the CharacterClass class that is placed inside the Player class like so:

    public string CharacterClassId { get; set; }

[IgnoreDataMember]
public CharacterClass CharacterClass { get; set; }

    During object initialization I could look-up the reference string in a store of CharacterClass (e.g. in memory list) and re-connect the object to the Player object. This would be an up to date version of the object. The resulting JSON would look like:

    {  
   "Name":"Arthur",
   "Experience":0,
   "CharacterClassId":"MageClass001"
}

    My concern with this solution is the amount of manual work required to re-connect disconnected objects during initialization.

    Questions:

    1. Is this solution viable?
    2. Is there a better way of doing this?
    3. Does anyone know how this is handled as an industry standard and could they point me to any relevant documentation?
  • ValueError: Not enough values to unpack when using pickle

    I tried to look at others questions but could not fin my answer. I do not understand why I have this error : 

     File "lexicon_based.py", line 50, in <module>
    for word, (pos, neu, neg) in zip(pickle.load(fd)):
ValueError: not enough values to unpack (expected 2, got 1)

    The part of the code where the error seems to come : 

    with open("dict_pickle", "rb") as fd:
    dico_lexique = {}
    for word, (pos, neu, neg) in zip(pickle.load(fd)):
        dico_lexique[word] = Sentiment(int(pos), int(neu), int(neg))

    Code to create the object " dict_pickle", the initial file has at least 400000 lines :

    with codecs.open('lexiconSentiment.txt', 'r', 'Cp1252', errors = 'ignore') as text_file:
    text_file =(text_file.read())
    #print(text_file)

dico_lexique =  ({i.split(";")[1]:i.split(";")[2:] for i in text_file.split("\n") if i}) # Spliting the text content and creating a dictionary
#print(dico_lexique)
#print(type(dico_lexique))

pickle_out = open("dict_pickle", "wb")
pickle.dump(dico_lexique, pickle_out)
pickle_out.close()

    how the dictionary file looks before using pickle :

    0;***;21;127;0
1;vraiment;407;156;37
2;oiseau-à-berceau;102;259;0
3;Stoph;95;308;37
4;Conscience;372;144;35
5;rançonnement;0;635;433
6;provenir;304;227;47
7;féliciteur;285;54;1
8;traversée;360;167;38
9;avant toute chose;241;108;34
10;Porcellis;52;276;0
11;Lasker-Schüler;146;284;0
12;discréditer;0;47;866
13;adjuration;300;44;40
14;Besnier-Boeck-Schaumann;0;39;315