How to generate random number with string and todays date

Does it matter if there is a gap?

Can you not use the Auto incrementing database row ID as the count?

@snapey thank you for you response.

i cant understand. the gap is for just to show the code.

and i cant understand "Auto incrementing database row ID as the count"

can u slightly explain please

Apart from that, there are big issues with your code.

// needs to be descending not ascending to get the latest entry
 $pur_id=PurchaseOrder:: select('id')->orderBy('created_at','asc')->first();

        if($pur_id==null)
         {
             $pur_id='POID1';
         }

         else
         {

//what is this line doing?
             $pur_id->id;

 //transforming pur_id from a Purchase Order record to an integer (did you give up thinking of names)
           $pur_id =$pur_id->id+1;

         
          $pur_id= 'POID'.$pur_id;

         }

         dd($pur_id);

Don't do anything until you are ready to store the Purchase order record

Then just store it.... hey- its got a unique number now.

Anytime you DISPLAY the purchase order, add the text POID to it. You can do this with an accessor on your model.

You probably also ought to pad with leading zeros.

public function getPOIDAttribute()
{
    return 'POID' . str_pad($this->id,5,'0',STR_PAD_LEFT);
}

@snapey thank you for your clear explanation.

Now i erased

all my if and else codings.

just added the below code in my model

public function getPOIDAttribute()
{
    return 'POID' . str_pad($this->id,5,'0',STR_PAD_LEFT);
}

this is my controller create method

 return view('Purchase.add-purchase-order-list')

and this is my add purchase order blade file

<div class="col-md-6"><label class="control-label">Purchase Order
                                            ID <span class="asterisk">*</span></label>
                                        <div class="">
                                            <input type="text" name="pur_order_num" id="pur_order_num"
                                                class="form-control" value="{{ $pur_id }}" required readonly />
                                        </div>
                                    </div>

Actually i have a separate column for purchase order number. these are my columns

id
login_user_id
pur_order_num
supplier_id
order_date
order_time
expec_date
expec_time
created_at
updated_at

now what should id do it to display in my blade file.?

@snapey Kindly please explain this

Since you have created a separate column for the PO number, then you have no choice but a two-step process, one to find the next number and one to write it to the column.

Do you really need that? Can you not just use the row id in the table?

The gotcha to this is that there can be gaps in the IDs if say a PO is in draft state and is then deleted. This leaves a gap which is not good from an auditing point of view.

If you use a separate number column, then you can find the highest and then add one to create the next number. However, beware again. If your site is heavily used, could two people create a purchase order at the same time and get the same number?

If it were just for my own use (as below) this is what I do;

            $salesOrder = SalesOrder::create([
                                'customer_id' => $customer->id,
                                'status' => 'New',
                                'type' => $type,
                                'salesorder' => SalesOrder::max('salesorder') +1,
                                ]);
        

salesorder column is the same as your pur_order_num

I set its value to be the result of a query to read the current max number + 1

Then, I decorate this plain number in the views as per previous examples

i cant understand "Auto incrementing database row ID as the count"

I'd suggest learning some basic MySql before attempting to write an application.

https://dev.mysql.com/doc/refman/8.0/en/

One I've used in the past: http://www.mysqltutorial.org/

@jlrdw bit unfair pulling him up for me not explaining myself properly.

Sorry for any misunderstanding.

$a = date('m-d-Y').substr(fmod(microtime(true), 1), 1);
$b = str_replace("-","",$a);
$c = 'PO-' . str_replace(".","-",$b);

PO-03312019-52710294723511