Blancer.com Tutorials and projects

I have an application that uses filament 3.2 and in this application I have a resource called “Students”, within this resource I am calling a “TablesActionsExportBulkAction” that calls a custom exporter.

The problem is that my resource comes from the “Students” model and what I need to export is an entity called “Courses” which is another table and has a one to many relationship with students, so a course can have many students and a student can only belong to one course.

                TablesActionsExportBulkAction::make('export_courses')
                ->label('Courses export')
                ->icon('heroicon-o-document-arrow-down')
                ->color('success')
                ->modifyQueryUsing(function (Builder $query)
                {
                    $initalQuery = $query->pluck('id')->toArray();
                    $newQuery = Courses::query()
                        ->whereIn('student_id', $initalQuery)
                        ->with(['student', 'user']);
                    return $newQuery;
                })
                ->exporter(CoursesExporter::class),

But by default exporter takes the “Students” model that comes from the resource, and if I try to change it inside the exporter it doesn’t work:

protected static ?string $model = Courses::class;

I also tried to change the query inside the exporter using the “modifyQuery” method but it doesn’t work either, it gets an error when I try to export:

    public static function modifyQuery(Builder $query): Builder
{
    $initalQuery = $query->pluck('id')->toArray();
    $newQuery = Courses::query()
        ->whereIn('student_id', $initalQuery)
        ->with(['student', 'user']);
    return $newQuery;
}

Is there a way to do this natively with filament? Or maybe there’s a way to do this with a custom action or something?
I thank those who know and can respond!!

I’m using filament 3.2, php 8.2 and laravel 11.45.0

I’m struggling to figure out how to add ldap authentication to a webapp that I am writing to manage entries in the LDAP server itself.

I want users to be able to log into the webapp with their LDAP credentials and most importantly, bind with their credentials for subsequent LDAP queries.

The part that is tripping me up the most is this:

You’re supposed to bind when needed, and unbind when you are done. So while I can create a $_SESSION["username"] object, I’ve seen no examples of a $_SESSION["password"] object for subsequent LDAP bind calls. That being said, how do I incorporate start_session() and use ldap_bind (Which requires the password) correctly if not by creating a $_SESSION["password"] object?

Example class I am working on:

<?php
session_start();

class LdapAuthenticator {
    private $ldapConnection;
    private string $ldapUri;

    public function __construct(string $uri) {
        $this->ldapUri = $uri;
        $ldap_error_message = ldap_error($this->ldapConnection);
        if($this->ldapConnection === false) {
            throw new Exception($ldap_error_message);
        }
    }

    public function connect(): bool {
        $this->ldapConnection = ldap_connect($this->ldapUri);
        if ($this->ldapConnection) {
            ldap_set_option($this->ldapConnection, LDAP_OPT_PROTOCOL_VERSION, 3);
            ldap_set_option($this->ldapConnection, LDAP_OPT_REFERRALS, 0);
            return true;
        }
        return false;
    }

    public function bind(string $bind_dn, string $bind_pw): bool {
        if (!isset($this->ldapConnection)) {
            throw new Exception("LDAP connection not established. Call connect() first.");
        }
        $ldap_error_message = ldap_error($this->ldapConnection);
        if (!empty($ldap_error_message) && $ldap_error_message !== "Success") {
            if(ldap_get_option($this->ldapConnection, LDAP_OPT_DIAGNOSTIC_MESSAGE, $extended_error)) {
                throw new Exception("$ldap_error_message - $extended_error");
            } else {
                throw new Exception("$ldap_error_message");
            }
        }
        return ldap_bind($this->ldapConnection, $bind_dn, $bind_pw);
    }
                
    public function authenticate(string $username, string $password) {
        // Attempt to bind with user credentials
        if ($this->bind($username, $password) "uid={$username},{$this->baseDn}", $password) {
            $_SESSION['ldap_username'] = $username;
            // Optionally retrieve and store other user details
            return true;
        }
        return false;
    }

    public function isLoggedIn() {
        return isset($_SESSION['ldap_username']);
    }

    public function close(): void {
        if (isset($this->ldapConnection)) {
            ldap_unbind($this->ldapConnection);
        }
    }

    public function getError(): string {
        if (isset($this->ldapConnection)) {
            return ldap_error($this->ldapConnection);
        }
        return "No LDAP connection.";
    }

    public function search(string $filter, string $settings) {
        $search_result = ldap_search($this->ldapConnection, $settings, $filter);

        $ldap_error_message = ldap_error($this->ldapConnection);
        if (!empty($ldap_error_message) && $ldap_error_message !== "Success") {
            if(ldap_get_option($this->ldapConnection, LDAP_OPT_DIAGNOSTIC_MESSAGE, $extended_error)) {
                throw new Exception("$ldap_error_message - $extended_error");
            } else {
                throw new Exception("$ldap_error_message");
            }
        }
                return ldap_get_entries($this->ldapConnection, $search_result);
    }
    
}    
?>

Example page code I am trying to piece together:

<?
try {
    $host = "ldaps://ldap.example.com";
    $baseDn = "dc=example,dc=com";
    $ldap = new LdapAuthenticator($host);

    if ($ldap->connect()) {
        if (!$ldap->bind($_POST["username"], $_POST['password'])) {
            $htmlerror = $ldap->getError();
        } else {
            $htmlerror = $ldap->getError();
            // Proceed with other LDAP operations (search, modify, etc.)
            $entries = $ldap->search("(&(objectClass=nsPerson)(objectClass=posixAccount))", $baseDn);
        }
        $ldap->close();
    } else {
        echo "Failed to connect to LDAP server.n";
    }
} catch (Exception $e) {
    echo "Error: " . $e->getMessage() . "n";
}

if (isset($_POST['username']) && isset($_POST['password'])) {
    if ($ldapSession->authenticate($_POST['username'], $_POST['password'])) {
        header("Location: protected_page.php");
        exit();
    } else {
        echo "Invalid credentials.";
    }
}

if ($ldapSession->isLoggedIn()) {
    echo "Welcome, " . $_SESSION['ldap_username'] . "!";
} else {
    // Display login form
}
?>

I am working on a Shopware 6 project and I want to change the product listing behavior on category pages (and search results).

Requirement:
Regardless of which sorting option a customer selects (price ascending, relevance, name, etc.), all out-of-stock products should always be shown at the end of the product listing.

What I’ve tried so far:

Subscribed to ProductListingCriteriaEvent and added an extra sorting:

$criteria->addSorting(new FieldSorting(‘stock’, FieldSorting::DESCENDING));

I am trying to break a table row (tr) into two pages if the content doesn’t fill the page,

Now it is breaking the whole into the next page which results in blank space in the first page above the footer

I am using the WriteHTML to generate pdf content

 foreach ($product_details as $prod_det) {
            $rate = format_currency($prod_det->qpd_rate);
            $amount = format_currency($prod_det->qpd_amount);
            $disc = number_format($prod_det->qpd_discount, 2);

            $pdf_data .= '
            <tr nobr="false">
                <td align="center" width="8%" style="padding: 2px; vertical-align: top;">' . $k . '</td>
                <td align="left" width="45%" style="padding: 2px;" vertical-align: top;>' . $prod_det->product_details . '</td>
                <td align="center" style="padding: 2px; vertical-align: top;" >' . $prod_det->qpd_quantity . '</td>
                <td align="center" style="padding: 2px; vertical-align: top;" >' . $prod_det->qpd_unit . '</td>
                <td align="right" style="padding: 2px; vertical-align: top;" >' . $rate . '</td>
                <td align="center" style="padding: 2px; color:red; vertical-align: top;" ><i>' . $disc . '</i></td>
                <td align="right" style="padding: 2px; vertical-align: top">' . $amount . '</td>
            </tr>
            ';
            $k++;
        }


 $mpdf = new MpdfMpdf([
            'margin_top' => 68,
            'margin_bottom' => 0,
            'margin_left' => 5,
            'margin_right' => 5,
            'defaultfooterline' => 0,
            'setAutoTopMargin'   => 'stretch',
            'setAutoBottomMargin'   => 'stretch',
            'keep_table_proportions' => false,
        ]);

 $mpdf->simpleTables = true;
        $mpdf->use_kwt = true;  // Keep-with-table
        $mpdf->packTableData = true;  // Better table handling
        $mpdf->shrink_tables_to_fit = 0;  // Don't shrink tables

        $mpdf->SetAutoPageBreak(true);

        $mpdf->SetTitle($title);


 $main_table = '<style>
                th, td { padding: 4px; font-size: 12px; }
                p { font-size: 12px; margin-bottom: 13px; } 
                table {
                page-break-inside: auto;
                }
                tr {
                    page-break-inside: auto;
                    page-break-after: auto;
                }
                td {
                    page-break-inside: auto;
                }
            </style>
            <table width="100%" style="page-break-inside:auto;border-collapse: collapse; margin-top: 10px;border-top:1px solid;line-height:18px;" autosize="1">
                <thead>
                    <tr>
                        <th align="center" width="8%" style="border-bottom:1px solid;">Item No</th>
                        <th align="center" width="45%" style="border-bottom:1px solid;">Description</th>
                        <th align="center" style="border-bottom:1px solid;">Qty</th>
                        <th align="center" style="border-bottom:1px solid;">Unit</th>
                        <th align="center" style="border-bottom:1px solid;">Rate</th>
                        <th align="center" style="border-bottom:1px solid;">Disc%</th>
                        <th align="center" style="border-bottom:1px solid;">Amount</th>
                    </tr>
                </thead>
                <tbody>
                ' . $pdf_data . '
                </tbody>
            </table>
            
            ';

$mpdf->WriteHTML($main_table);

//Other code

tried using page-break-inside: auto style inside table,tr,tbody, putting the row inside a whole tbody, in a whole table

See the blank space after the 9th row, the 10th is pushed to the next page, I want to take the space available and then push the remaining content to the next page

I’m throwing a message in a bottle for those who are fairly proficient with Cakephp 3.8. I admit I’m a little rusty after a few years of hiatus from development

I’ll explain my problem:
I have a basic module that allows user registration and login. So far, so good. My problem comes at the login stage, as I’m using a custom hash of the $password+$key type. The $key is automatically generated during registration and then stored in the users table with the other information.

I’d like to know if there is a way to retrieve this value without using manual checks in order to keep my code perfectly clean and functional.

Currently, I can enter any password, and $user returns true as long as the email address exists in the table.

src/Controller/Users/Usercontroller.php

public function register() {
     $userTable = TableRegistry::getTableLocator()->get('Users');
     $user = $this->Users->newEntity($this->request->getData(), ['validate' => 'UserStep1']);
     $user->type = $this->request->getSession()->read('account-type');
     $user->salt = sha1(md5($this->request->getSession()->read('salt')));
     $user->password = $hash->hash($this->request->getData('password'),$this->request->getSession()->read('salt'));

     if ($userTable->save($user)) {
     return true;
     }
}


public function login() {
        if($this->request->is('post')) {
            $user = $this->Auth->identify();
            if($user) {
                $this->Auth->setUser($user);
                $this->redirect($this->redirect($this->Auth->redirectUrl()));
                $this->Flash->response('Connecté', [
                    'key'   => 'response',
                    'params'    => [
                        'status'    => 'success'
                    ]
                ]);
            } else {
                $this->Flash->response('Identifiant ou mot de passe incorrect', [
                    'key'   => 'response',
                    'params'    => [
                        'status'    => 'error'
                    ]
                ]);
            }
        }
    }

src/Auth/CustomPasswordHasher.php

namespace Appauth;

use CakeAuthAbstractPasswordHasher;

class CustomPasswordHasher extends AbstractPasswordHasher {

    public function hash($password, $securestring = null) {
        $encode=  sha1(md5('stringmasked'). md5(sha1($password)).sha1(sha1(md5($securestring))));

        return $encode;
    }
    public function check($password, $salt)
    {
        $encode = sha1(md5('stringmasked').md5(sha1($password)).sha1(($salt)));

        return $encode;
    }
}

src/Controller/AppController.php

$this->loadComponent('Auth', [
            'authenticate'  => [
                'Form'  => [
                    'fields'    => ['username'  => 'email'],
                    'passwordHasher'    => ['className' => 'Custom']
                ]
            ]
        ]);
        $this->Auth->allow();

I admit that I’m a bit stuck on this problem, I don’t really know where the problem comes from

Thanks