Web Develpers era: task by hasone testdome

vuejs task

write the reoraderable list component . the component should recieve an array of elements as items prop and should displa the elements as list items in an unorderseed list 

when the user click on a  list item it should be sent to the first positionin the unordered list

for example if the component has the item prop ["A","B","C"], the list should look like:

<!DOCTYPE html> <html> <head> <title>Reorderable List</title> <script src="https://cdn.jsdelivr.net/npm/vue@2"></script> </head> <body> <div id="app"> <reorderable-list :items="['A', 'B', 'C']"></reorderable-list> </div> <script> Vue.component('reorderable-list', { props: ['items'], data() { return { list: [...this.items] }; }, methods: { moveToFirst(index) { const item = this.list.splice(index, 1)[0]; this.list.unshift(item); } }, template: ` <ul> <li v-for="(item, index) in list" :key="index" @click="moveToFirst(index)"> {{ item }} </li> </ul> ` }); new Vue({ el: '#app' }); </script> </body> </html>

second task

convert a string of numbers to a sentnce .e ach number represents a aletter. numbers in the string are seperated by aspace. and words in the sentence are seperated by a plus characterf/

conversion table:

1 = A

2 =B

26 = Z

example numbe to letters (`20 15 19 20+4 15 13 5) should return 'test dome'

<?php function numberToLetters($string) { $conversionTable = [ 1 => 'A', 2 => 'B', 3 => 'C', 4 => 'D', 5 => 'E', 6 => 'F', 7 => 'G', 8 => 'H', 9 => 'I', 10 => 'J', 11 => 'K', 12 => 'L', 13 => 'M', 14 => 'N', 15 => 'O', 16 => 'P', 17 => 'Q', 18 => 'R', 19 => 'S', 20 => 'T', 21 => 'U', 22 => 'V', 23 => 'W', 24 => 'X', 25 => 'Y', 26 => 'Z' ]; $words = explode('+', $string); // Split string into words separated by '+' $result = []; foreach ($words as $word) { $letters = explode(' ', $word); // Split each word into numbers separated by spaces $wordResult = ''; foreach ($letters as $number) { if (isset($conversionTable[$number])) { $wordResult .= $conversionTable[$number]; } } $result[] = $wordResult; } return strtolower(implode(' ', $result)); // Convert result to a sentence in lowercase } // Example usage echo numberToLetters('20 5 19 20+4 15 13 5'); // Outputs: test dome ?>

echo numberToLetters('20 5 19 10+4 15 13 5');

===============================

implement the get view count method .it should accept a json

a string and sum all vie wcount fields inside the json will alwyas hav ethe same structure as int he example case

for example calling get view count should return 88270796 for the following $jsonstring

{

"apiVersion": "2.1",

"videos": [

{

"id": "253",

"category": "music",

"title": "Jingle Bells",

"duration": 457,

"viewCount": 88270796

}

]

}

<?php function getViewCount(string $jsonString): int { $data = json_decode($jsonString, true); $totalViewCount = 0; if (isset($data['videos']) && is_array($data['videos'])) { foreach ($data['videos'] as $video) { if (isset($video['viewCount'])) { $totalViewCount += $video['viewCount']; } } } return $totalViewCount; } $jsonString = ' { "apiVersion": "2.1", "videos": [ { "id": "253", "category": "music", "title": "Jingle Bells", "duration": 457, "viewCount": 88270796 } ] } '; echo getViewCount($jsonString); ?>

===

writea a function that removes all items that are not integers from the array the function should modify the existing aarray,nmot create a nbew one.

for example, if the input array containes values [1,'a,'b',2], after processing, the array will contain only values [1,2]

<?php function filterNumbersFromArray(array &$arr): void { foreach ($arr as $key => $value) { if (!is_int($value)) { unset($arr[$key]); } } } $arr = [1, 'a', 'b', 2]; filterNumbersFromArray($arr); print_r(array_values($arr)); ?>

==============

an education magazine pulbishee rankings of strudnetns and theire colleges in a acompetitoion in building unmmaned aerial vehical dornes. students whoi participated in the competion in different yeres, their ranking in the competion, and their colleges are contained inthe following tables;

table colleges

id integer primary key

name varchar(50) not null

table students

id integer primary key

name varchar(50) not null

collegeid integer

foreighn key (collegeid) references colleges(id)

table rankings

studentid integer

ranking integer not null

year integer not null

foreign key (studentid) references students(id)

write a query that lists all collges that have atleast one student with a ranking between 1 and 3 ( both inclusive) for the year 2015. the query should return

the college name,

the rank of their best rnaking studnet for 21015.;

the numer of students who had rankings between 1 and 3 ( both inclusive) for the year 2015

rank 1 is the best rank, rank 2 is the second best an dso on . more than one student can tie for a rank in a ayear

SELECT 
    c.name AS college_name,
    MIN(r.ranking) AS best_rank_2015,
    COUNT(*) AS num_students_rank_1_to_3
FROM 
    rankings r
JOIN 
    students s ON r.studentid = s.id
JOIN
    colleges c ON s.collegeid = c.id
WHERE
    r.year = 2015
    AND r.ranking BETWEEN 1 AND 3
GROUP BY 
    c.name;

As part of a data processing pipeline, complete the implementation of the make_pipeline method:

The make_pipeline method should accept a variable number of functions, and it should return a new function that accepts one parameter $arg.
The returned function should call the first function in make_pipeline with the parameter $arg, and call the second function with the result of the first function.
The returned function should continue calling each function in make_pipeline in order, following the same pattern, and return the value from the last function.

For example, calling make_pipeline(function($x) { return $x * 3; }, function($x) { return $x + 1; }, function($x) { return $x / 2; }), and then calling the returned function with 3 should return 5.

<?php

function make_pipeline(...$funcs)
{
    return function ($arg) use ($funcs) {
        $result  =$arg;
        foreach ($funcs as $func){
            $result  = $func($result);
        }
        return $result;
    };
}

$fun = make_pipeline(
    function ($x) {
        return $x * 3;
    },
    function ($x) {
        return $x + 1;
    },
    function ($x) {
        return $x / 2;
    }
);
echo $fun(3); # should print 5

===

App usage data are kept in the following table:

TABLE sessions
  id INTEGER PRIMARY KEY,
  userId INTEGER NOT NULL,
  duration DECIMAL NOT NULL

Write a query that selects userId and average session duration for each user who has more than one session.

SELECT userid, AVG(duration) AS avg_duration
FROM sessions
GROUP BY userid
HAVING COUNT(id) > 1;

questions:

what is abstract and what is interface

why we use abstaract

what is difference

why do we interface

wht is static method

where can use static, where can we declare static

solid principles

design pattern

whtis service container and service provider

array methods

what type of array in php supports

session and cookie

what is http only cookie

what is break and continue

how can we handle exceptions

what is finally in php

whatr is composer

what is composer.lock

how to update the pacakge

how can we update teh specific pakage

life cycke method in vuejs

how to bind the data

what is v-model

event emitters

what is props and data functions

hwo can we declare a method in vuejs

what is pure function in javascript

set time out and set interval

how to stop the setinterval

hosting in javascript

waht is closure in javacript

sql

what are join in sql

what is self join

what is inner join

what is group by

what is indexing mechanism

what is composite index

aany experience in version control system and what is the workf low

Web Develpers era

task by hasone testdome

No comments:

Post a Comment

server laravel application

Labels