thiscodeWorks - Saving, organizing & sharing the best of code online

C Program To Sum of Upper Triangular Matrix

#include <stdio.h>

int main()
{
    int m,n;                 //Matrix Size Declaration
    printf("Enter the number of rows and column: \n");
    scanf("%d %d",&m,&n);   //Matrix Size Initialization
    int arr[10][10];        //Matrix Size Declaration
    printf("\nEnter the elements of the matrix: \n");
    for(int i=0;i<m;i++)    //Matrix Initialization
    {
        for(int j=0;j<n;j++)
        {
            scanf("%d",&arr[i][j]);
        }
    }
    printf("\nThe elements in the matrix are: \n");
    for(int i=0;i<m;i++)     //Print the matrix
    {
        for(int j=0;j<n;j++)
        {
            printf("%d ",arr[i][j]);
        }
        printf("\n");
    }
    if(m==n)               //If number of rows and columns equal
    {
       int upsum=0;
       for(int i=0;i<m;i++)
       {
          for(int j=0;j<n;j++)
          {
               if(i<=j)          //Traverse only in the upper triangle
               upsum=upsum+arr[i][j];    //Add the elements 
          }
        }
        //Print the sum of upper triangular elements
        printf("\nThe sum of upper triangular matrix is %d",upsum);
    }
    else
    {                   //Not possible to declare upper triangular elements 
        printf("Not Possible to display lower triangular elements sum");
    }
    return 0;
}

C Program To Print The X Star Pattern

@Yuktha139

#include <stdio.h>

int main()
{
int i, j, N;
int count;

printf("Enter no. Of Rows To Print X Pattern: ");
scanf("%d", &N);

count = N * 2 - 1;

for(i=1; i<=count; i++)
{
for(j=1; j<=count; j++)
{
if(j==i || (j==count - i + 1))
{
printf("*");
}
else
{
printf(" ");
}
}

printf("\n");
}

return 0;
}

Embed ordering system background to white

@hollyhenaghan

#flipdish-menu{
background:#fff!important;
}

How to enable Python type checking in VSCode

@vikassnwl

In your settings.json file, add a new line with the following setting:

{
  "python.analysis.typeCheckingMode": "basic"
}

Link CSS and JavaScript In HTML folder

@preduxas

<!DOCTYPE html>
<html lang="en" dir="ltr">
  <head>
    <meta charset="utf-8">
    <title>Calculator</title>
    <link href="Calculator with Js\style.css" rel="stylesheet">
    <script src="Calculator with JS\script.js" defer></script>

iiiuiuui

@qqignatqq

<?php
// Файлы phpmailer
require 'phpmailer/PHPMailer.php';
require 'phpmailer/SMTP.php';
require 'phpmailer/Exception.php';

// Переменные, которые отправляет пользователь
$name = $_POST['name'];
$email = $_POST['email'];
$text = $_POST['text'];
$file = $_FILES['myfile'];

// Формирование самого письма
$title = "Заголовок письма";
$body = "
<h2>Новое письмо</h2>
<b>Имя:</b> $name<br>
<b>Почта:</b> $email<br><br>
<b>Сообщение:</b><br>$text
";

// Настройки PHPMailer
$mail = new PHPMailer\PHPMailer\PHPMailer();
try {
    $mail->isSMTP();   
    $mail->CharSet = "UTF-8";
    $mail->SMTPAuth   = true;
    //$mail->SMTPDebug = 2;
    $mail->Debugoutput = function($str, $level) {$GLOBALS['status'][] = $str;};

    // Настройки вашей почты
    $mail->Host       = 'smtp.yandex.ru'; // SMTP сервера вашей почты
    $mail->Username   = 'your_login'; // Логин на почте
    $mail->Password   = 'password'; // Пароль на почте
    $mail->SMTPSecure = 'ssl';
    $mail->Port       = 465;
    $mail->setFrom('mail@yandex.ru', 'Имя отправителя'); // Адрес самой почты и имя отправителя

    // Получатель письма
    $mail->addAddress('youremail@yandex.ru');  
    $mail->addAddress('youremail@gmail.com'); // Ещё один, если нужен

    // Прикрипление файлов к письму
if (!empty($file['name'][0])) {
    for ($ct = 0; $ct < count($file['tmp_name']); $ct++) {
        $uploadfile = tempnam(sys_get_temp_dir(), sha1($file['name'][$ct]));
        $filename = $file['name'][$ct];
        if (move_uploaded_file($file['tmp_name'][$ct], $uploadfile)) {
            $mail->addAttachment($uploadfile, $filename);
            $rfile[] = "Файл $filename прикреплён";
        } else {
            $rfile[] = "Не удалось прикрепить файл $filename";
        }
    }   
}
// Отправка сообщения
$mail->isHTML(true);
$mail->Subject = $title;
$mail->Body = $body;    

// Проверяем отравленность сообщения
if ($mail->send()) {$result = "success";} 
else {$result = "error";}

} catch (Exception $e) {
    $result = "error";
    $status = "Сообщение не было отправлено. Причина ошибки: {$mail->ErrorInfo}";
}

// Отображение результата
echo json_encode(["result" => $result, "resultfile" => $rfile, "status" => $status]);

C++ Tryit Editor v1.0

@zkilo404

#include<iostream>
#include<conio.h>
using namespace std;

class PQue
{
private:
	int PQ[5][5];
	int front[5];
	int rear[5];

public:
	PQue()
	{
		for (int i = 0; i < 5; i++)
		{
			front[i] = rear[i] = -1;
			for (int j = 0; j < 5; j++)
			{
				PQ[i][j] = 0;
			}
		}
	}
	void insert(int priority, int value)
	{
		if (front[priority] == -1 && rear[priority] == 5 - 1)
		{
			cout << "Overflow !!! " << endl;
		}
		else
		{
			PQ[priority][++rear[priority]] = value;
		}
	}
	int remove(int priority)
	{
		if (front[priority] == rear[priority])
		{
			cout << "Underflow !!! " << endl;
			return -1;
		}
		else
		{
			return PQ[priority][++front[priority]];
		}
	}
	void removeAll()
	{
		for (int i = 0; i < 5; i++)
		{
			for (int j = 0; j < 5; j++)
			{
				cout << remove(i) << endl;
			}
		}
	}
};
int main()
{
	PQue A;
	
	A.insert(1, 7);
	A.insert(1, 8);
	A.insert(1, 2);
	A.insert(1, 6);
	A.insert(1, 4);
	for (int i = 0; i < 5; i++)
	{
		cout << A.remove(1) << endl;
	}

	_getch();
	return 0;
}

TS

@ryanvv

https://obaranovskyi.medium.com/top-5-techniques-in-typescript-to-bring-your-code-to-the-next-level-6f20be543b39undefined

TS factory include / selector

@ryanvv

enum TeamStatus {
    Lead = 1,
    Manager = 2,
    Developer = 3
}

interface User {
  firstName: string;
  lastName: string;
  status: UserStatus;
  teamStatus: TeamStatus;
}


function roleCheck<D, T>(selector: (data: D) => T, roles: T[]): (value: D) => boolean {
    return (value: D) => roles.includes(selector(value));
}

const MANAGER_OR_LEAD = [
    TeamStatus.Lead,
    TeamStatus.Manager
]

const isManagerOrLead = roleCheck((user: User) => user.teamStatus, MANAGER_OR_LEAD);

Encapsulate code changes

@ryanvv

async function makeUserAction(fn: Function): Promise<void> {
  LoadingService.startLoading();
  await fn();
  LoadingService.stopLoading();
  UserGrid.reloadData();
}

async function createUser2(user: User): Promise<void> {
  makeUserAction(() => userHttpClient.createUser(user));
}

async function updateUser2(user: User): Promise<void> {
  makeUserAction(() => userHttpClient.updateUser(user));
}

Simple Accordion

@rstringa

https://codepen.io/Cosmo96/pen/VwKWdJW

python - How do you run the Tornado web server locally? - Stack Overflow

@ericblancosf

import tornado.ioloop
import tornado.web

class MainHandler(tornado.web.RequestHandler):
    def get(self):
        self.write("Hello, world")

application = tornado.web.Application([
    (r"/", MainHandler),
])

if __name__ == "__main__":
    application.listen(8000)
    tornado.ioloop.IOLoop.instance().start()

python - How do you run the Tornado web server locally? - Stack Overflow

@ericblancosf

application = tornado.web.Application([
    (r'/blah', BlahHandler),
    ], **settings)

# Create an HTTP server listening on localhost, port 8080.
http_server = tornado.httpserver.HTTPServer(application)
http_server.listen(8080, address='127.0.0.1')

gitignore - Why doesn't Git ignore my specified file? - Stack Overflow

git rm --cached sites/default/settings.php

Html Marquee Tag | change marquee speed, behavior, Scrollamount, Scrolldelay

@saeed

<marquee onmouseover="stop()" onmouseout="start()">This marquee will stop on mouseover and restart on mouseout.</marquee>

code for interactive grid to get data

@ahsankhan007

var htmldb_delete_message='"DELETE_CONFIRM_MSG


(function($){
    function update(model){
        var amt = model.getFieldKey("QTY1"),
            custAmt = model.getFieldKey("RATE"),
            total = 0;
        model.forEach(function(record, index, id){
           var v_amt = record[amt],
               v_custAmt = record[custAmt],
               meta = model.getRecordMetadata(id);
           var all_v_amt = Number(v_amt.replace(/,/g, ''));
           var all_v_custAmt = Number(v_custAmt.replace(/,/g, ''));  
                
           if(!isNaN(all_v_amt, all_v_custAmt) && !meta.deleted && !meta.agg){
              total += all_v_amt * all_v_custAmt;
           }
        });
        var all_total = total.toFixed(2); 
        console.log('>>', all_total);
        $s('P11201_GROSS_TOTAL', all_total);
        $s('P11201_GROSS_TOTAL_PAY', all_total);
        $s('P11201_NET', all_total);
        $s('P11201_NET_PAY', all_total);
}
$(function(){
        $("#invDtl").on("interactivegridviewmodelcreate", function(event, ui) {
            var sid,
            model = ui.model;
            if ( ui.viewId === "grid" ){
                sid = model.subscribe({
                    onChange: function(type, change){
                        if(type === "set"){
                            if(change.field === "QTY1"){
                                update(model);
                            }else if(change.field === "RATE"){
                                update(model);
                            }
                        }else if(type !== "move" && type !== "metaChange"){
                            update(model);
                        }
                    },
                    progressView: $("#P11201_GROSS_TOTAL")
                });
                update(model);
                model.fetchAll(function() {});
            }
        });
    });
})(apex.jQuery);

Bullet point listan rivivälin muokkaaminen

@tarusalokangas

/// bullet point riviväli
.sqs-block-content li {
line-height: 1em;
}

Pop Up Module Transparent

@hollyhenaghan

div[role=presentation] div:not(#\20):not(#\20):not(#\20).MuiPaper-root{
    background:white!important;
}

Buttonit samankokoisiksi

@tarusalokangas

/* Small Button Styling */
.sqs-block-button-element--small {
 width: 80% !important;
}

/* Medium Button Styling */
.sqs-block-button-element--medium {
 width: 80% !important;
}

/* Large Button Styling */
.sqs-block-button-element--large {
 width: 80% !important;
}

groupcontroller

@vvnezapnopwnz

const { globalLink } = require('../app');
const db = require('../db');

exports.createGroupPage = async (req, res, next) => {
  res.status(200).render('./createPages/group', {
    globalLink,
  });
};

exports.createGroup = async (req, res, next) => {
  const groupData = req.body;

  db.oneOrNone(`INSERT INTO groups(name, class_number)
        VALUES('${groupData.name}', ${Number(groupData.class_number)})` + 'RETURNING group_id')
    .then(({ group_id }) => res.status(200).redirect(`${globalLink}/groups/${group_id}`));
};



exports.getGroup = async (req, res, next) => {

  return db.task(t => {
    const groupId = req.params.id;
    let group = {

    };

    return t.oneOrNone(`SELECT * from groups where group_id = ${groupId}`)
    .then((groupData) => {
      group.group_info = groupData;

      return t.manyOrNone(`select * from group_subjects a
      join subjects b
      on a.subject_id = b.id
      where a.group_id = ${groupId}`)
    })
    .then((group_subjects) => {
      group.subjects = group_subjects;

      return t.manyOrNone(`select a.group_id, d.name as subject_name,
      a.student_id, b.name as student_name
      from group_students a
      join students b
      on a.student_id = b.student_id
      join student_subjects c
      on b.student_id = c.student_id
      join subjects d
      on c.subject_id = d.id
      where a.group_id = ${groupId} and active = true`)
    }).then((group_students) => {
      group.students = group_students;

      group.group_students_by_subjects = group.subjects.map((subject) => {

       subject.subject_students = group.students.filter((student) => student.subject_name == subject.name);
       return subject;
      });

      return t.manyOrNone(`SELECT a.review_id,  a.posting_date, c.name,
      count(b.attendance) AS marked_attendance,
      count(*) filter (where b.attendance) as attendance,
      count(b.activity) AS marked_activity,
      count(*) filter (where b.activity) as activity,
      count(b.homework) AS marked_homework,
      count(*) filter (where b.homework) as homework
      from group_reviews a
      JOIN student_records b
      ON a.review_id = b.review_id
      JOIN subjects c ON a.subject_id = c.id
      WHERE a.group_id = ${groupId}
      GROUP BY a.review_id, c.name`)
    })
    .then((group_reviews) => {
      group.reviews = group_reviews;

      return t.manyOrNone(`select distinct format, group_id from group_custom_tests
      where group_id = ${groupId}`);
    })
    .then((testFormatsData) => {

      return t.tx((tt) => {

        const queries = testFormatsData.map((format) => {
          return tt.manyOrNone(`select * from group_custom_tests
          where format = '${format.format}' and group_id = ${groupId}`)
          .then((formatTestsData) => {
            format.tests = formatTestsData;
            return format;
          })

        });
        return tt.batch(queries);


      })
    })
    .then((data) => console.log(data))

    // .then((tests) => {

    //   return t.tx((tt => {

    //     const queries = tests.map((test) => {
    //       return tt.manyOrNone(`select  b.student_id,
    //       d.name as student_name,
    //       b.subject_id, c.name as subject_name,
    //       b.max_points, b.points, b.test_date
    //       from group_custom_tests a
    //       join custom_tests_results b
    //       on a.id = b.custom_test_id
    //       join subjects c
    //       on b.subject_id = c.id
    //       join students d
    //       on b.student_id = d.student_id
    //       where a.id = ${test.id}`)
    //       .then((resultsData) => {
            
    //         test.results = resultsData;
    //         return test;
    //       })
    //     });
    //     return t.batch(queries);
    //   }));
    // }).then((data) => console.log(data))
    .then(() => res.status(200).render('./pages/groupPage', {
      // tests: complexTests,
      group_students_by_subjects: group.group_students_by_subjects,
      group: group.group_info,
      students: group.students,
      subjects: group.subjects,
      reviews: group.reviews,
      globalLink,
    }));
  })
  .catch((error) => {
    console.log('ERROR:', error);

    res.status(500).json({
      error,
    });
  });




  // db.task(t => {
  //   const groupId = req.params.id;
  //   let group;
  //   let students;
  //   let subjects;
  //   let complexTests;
  //   let reviews;

  //   return t.one(`SELECT * from groups WHERE group_id = '${groupId}'`)
  //   .then((groupData) => group = groupData)
  //   .then(() => t.manyOrNone(`SELECT * from group_students a
  //   JOIN students b ON 
  //   a.student_id = b.student_id
  //   WHERE a.group_id = ${groupId} AND b.active = true`))
  //   .then((groupStudentsData) => students = groupStudentsData)
  //   .then(() => t.manyOrNone(`SELECT * from group_subjects a
  //       JOIN subjects b
  //       ON a.subject_id = b.id 
  //       where a.group_id = ${groupId}`)
  //   .then((groupSubjectsData) => subjects = groupSubjectsData))
  //   .then(() => t.query(`SELECT a.review_id,  a.posting_date, c.name,
  //   count(b.attendance) AS marked_attendance,
  //   count(*) filter (where b.attendance) as attendance,
  //   count(b.activity) AS marked_activity,
  //   count(*) filter (where b.activity) as activity,
  //   count(b.homework) AS marked_homework,
  //   count(*) filter (where b.homework) as homework
  //   from group_reviews a
  //   JOIN student_records b
  //   ON a.review_id = b.review_id
  //   JOIN subjects c ON a.subject_id = c.id
  //   WHERE a.group_id = ${groupId}
  //   GROUP BY a.review_id, c.name`))
  //   .then((reviewsData) => reviews = reviewsData)
  //   .then(() => t.query(`select distinct a.id, a.format,
  //   a.group_id,
	//   avg(b.max_points) as avg_max_points,
	//   avg(b.points) as avg_points,
	//   count(distinct b.student_id)
  //   from group_custom_tests a
  //   join custom_tests_results b
  //   on a.id = b.custom_test_id
  //   where a.group_id = ${groupId}
	//   GROUP BY a.id`))
  //   .then((complexTestsData) => {

  //     complexTests = complexTestsData.map((complexTest) => {
  //       complexTest.percent = Math.round(complexTest.avg_points / complexTest.avg_max_points * 100);
  //       return complexTest;
  //     });
    
  //   })
  //   .then(() => {
  //     t.tx((tt) => {
  //       const queries = complexTests.map((test) => tt.manyOrNone(`select distinct b.name
  //       from custom_tests_results a
  //       join subjects b on a.subject_id = b.id
  //       where a.custom_test_id = ${test.id}`).then((testSubjectsData) => {
  //         test.test_subjects = testSubjectsData;
  //       }));
  //       return tt.batch(queries);
  //     })
  //   })
  //     .then(() => res.status(200).render('./pages/groupPage', {
  //         tests: complexTests,
  //         complexTests,
  //         group,
  //         students,
  //         subjects,
  //         reviews,
  //         globalLink,
  //       }));
  //   })
  //   .catch((error) => {
  //     console.log('ERROR:', error);

  //     res.status(500).json({
  //       error,
  //     });
  //   });




};



exports.addStudentToGroupPage = async (req, res, next) => {

  db.task(t => {

    const groupId = req.params.id;
    let group;

    return t.oneOrNone(`SELECT * from groups WHERE group_id = ${groupId}`)
    .then((groupData) => group = groupData)
    .then(() => t.manyOrNone(`SELECT a.student_id, a.name, a.class_number
     from students a
    FULL JOIN group_students b
    ON a.student_id = b.student_id
          WHERE 
        a.class_number = ${group.class_number} AND b.group_id <> ${groupId}
        OR b.group_id IS NULL AND a.class_number = ${group.class_number}`)
      .then((possibleNewStudents) => res.status(200).render('./updatePages/addStudent', {
        group,
        possibleNewStudents,
        globalLink,
      }))
    )
      .catch((error) => res.status(500).json({
        error
      }))

  });
};





exports.addStudentToGroup = async (req, res, next) => {
  const groupId = req.params.id;
  const { student } = req.body;
  console.log(student);
  db.oneOrNone(`SELECT * from students WHERE student_id = ${student}`)
    .then(({ student_id }) => db.query(`INSERT INTO group_students(student_id, group_id) VALUES(${student_id}, ${groupId})`))
    .then(() => res.redirect(`${globalLink}/groups/${groupId}/`));
};

exports.removeStudentFromGroupPage = async (req, res, next) => {
  const groupId = req.params.id;

  let group;
  let groupStudentsIds;
  db.one(`SELECT * from groups WHERE group_id = ${groupId}`).then((groupData) => {
    group = groupData;
    return db.manyOrNone(`SELECT * from group_students WHERE group_id = ${groupId}`);
  })
    .then((groupStudents) => {
      groupStudentsIds = groupStudents.map((student) => student.student_id);

      groupStudentsIds.reduce((acc, student_id) => {
        const newAcc = acc.then((contents) => db.manyOrNone(`SELECT * from students WHERE student_id = ${student_id}`)
          .then((data) => contents.concat(data)));
        return newAcc;
      }, Promise.resolve([]))
        .then((students) => {
          res.status(200).render('./removePages/removeStudent', {
            group,
            students,
            globalLink,
          });
        });
    });
};

exports.removeStudentFromGroup = async (req, res, next) => {
  const groupId = req.params.id;
  const studentId = req.body.student;

  db.any(`DELETE FROM group_students WHERE group_id = ${groupId} AND student_id = ${studentId}`)
    .then(() => res.redirect(`${globalLink}/groups/${groupId}/`));
};

// subjects

exports.addSubjectToGroupPage = async (req, res, next) => {
  const groupId = req.params.id;
  let group;
  let groupSubjectsIds;
  let allSubjects;
  db.one(`SELECT * FROM groups WHERE group_id = ${groupId}`)
    .then((groupData) => {
      group = groupData;
    }).then(() => db.manyOrNone('SELECT * from subjects'))
    .then((subjects) => {
      allSubjects = subjects;
    })
    .then(() => db.manyOrNone(`SELECT * from group_subjects WHERE group_id = ${groupId}`)
      .then((groupSubjects) => {
        groupSubjectsIds = groupSubjects.map((subject) => subject.subject_id);
      }))
    .then(() => allSubjects.filter((subject) => {
      if (groupSubjectsIds.includes(subject.id)) {
        return;
      }
      return subject;
    }))
    .then((availableSubjects) => res.status(200).render('./updatePages/addSubject', {
      group,
      availableSubjects,
      globalLink,
    }));
};

exports.addSubjectToGroup = async (req, res, next) => {
  const groupId = req.params.id;
  const subjectId = req.body.subject;
  let group;

  db.one(`SELECT * FROM groups WHERE group_id = ${groupId}`)
    .then((groupData) => {
      group = groupData;
    })
    .then(() => db.one(`SELECT * from subjects WHERE id = ${subjectId}`)
      .then((subject) => {
        console.log(subject);
        db.query(`INSERT INTO group_subjects(group_id, subject_id) VALUES (${groupId}, ${subject.id})`);
      }))
    .then(() => res.redirect(`${globalLink}/groups/${groupId}`));
};

exports.removeSubjectFromGroupPage = async (req, res, next) => {
  const groupId = req.params.id;

  let group;
  db.one(`SELECT * from groups WHERE group_id = ${groupId}`).then((groupData) => {
    group = groupData;
    return db.manyOrNone(`SELECT * from group_subjects a
        JOIN subjects b
        ON a.subject_id = b.id
        WHERE group_id = ${groupId}`);
  })
    .then((subjects) => res.status(200).render('./removePages/removeSubject', {
      group,
      subjects,
      globalLink,
    }));
};

exports.removeSubjectFromGroup = async (req, res, next) => {
  const groupId = req.params.id;
  const subjectId = req.body.subject;

  db.any(`DELETE FROM group_subjects WHERE group_id = ${groupId} AND subject_id = ${subjectId}`)
    .then(() => res.redirect(`${globalLink}/groups/${groupId}/`));
};



exports.removeGroupPage = async (req, res, next) => {

  db.task(t => {

    return t.manyOrNone(`SELECT * from groups where active`)
    .then((groups) => res.status(200).render('./removePages/removeGroup', {
      groups,
      globalLink,
    }))
  })


};


exports.removeGroup = async (req, res, next) => {

  db.task(t => {
    const groupId = req.body.group_id;
    return t.query(`UPDATE groups SET active = false WHERE group_id = ${groupId}`)
           .then(() => res.redirect(`${globalLink}/users/profile/`))

  })
  
}

groupPage.ejs

@vvnezapnopwnz

<!DOCTYPE html>
<html>
<head>
  <%- include ("../partials/header.ejs") %>
</head>

<body>
  
  <%- include ("../partials/nav.ejs") %>

<div class="container">
    <div class="row my-3 group__block">
      <div class="col">
        <div class="group__info d-flex flex-column justify-content-start">
          <h4 class="btn btn-success">
             Группа: <%= group.name %>
          </h4>
          <h4 class="btn btn-success">
              Класс:
              <%= group.class_number %>
          </h4>
      </div>
      </div>
    </div>
    <div class="row d-flex group__block my-3">
        <div class="group__info">
          <h4 class="students_content_title text-center">
            Состав группы по предметам
          </h4>
          <div class="students__content">
            <div class="table-responsive-lg">
              <table class="table table-striped table-hover table-bordered border-primary">
                <tbody>
                  <tr>
                    <% group_students_by_subjects.forEach(function(subject) { %>
                      <td>
                        <b><%= subject.name %> :</b>
                      </td>
                      <% subject.subject_students.forEach(function(student) { %> 
                        <td>
                          <a href=<%= `${globalLink}/students/${student.student_id}/` %> class="btn btn-warning my-2">
                            <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-person" viewBox="0 0 16 16">
                              <path d="M8 8a3 3 0 1 0 0-6 3 3 0 0 0 0 6zm2-3a2 2 0 1 1-4 0 2 2 0 0 1 4 0zm4 8c0 1-1 1-1 1H3s-1 0-1-1 1-4 6-4 6 3 6 4zm-1-.004c-.001-.246-.154-.986-.832-1.664C11.516 10.68 10.289 10 8 10c-2.29 0-3.516.68-4.168 1.332-.678.678-.83 1.418-.832 1.664h10z"/>
                            </svg>
                            <strong><%= student.student_name %></strong>
                          </a>
                        </td>
                      <% }); %>
                  </tr>
                    <% }); %>
                </tbody>
              </table>
            </div>
          </div>
        </div>

        
<script>
  const transposeTable = (tbody, newContainerType = "tbody") => {
  const rows = Array.from(tbody.querySelectorAll("tr"))
  const newTbody = document.createElement(newContainerType)

  for (let rowIdx = 0; rowIdx < rows.length; rowIdx++) {
    const row = rows[rowIdx]
    const cells = Array.from(row.querySelectorAll("td, th"))

    for (let cellIdx = 0; cellIdx < cells.length; cellIdx++ ) {
      const cell = cells[cellIdx]
      // const newRow = newRows[cellIdx] || document.createElement("tr")
      const newRow = newTbody.children[cellIdx] || document.createElement("tr")
      if (!newTbody.children[cellIdx]) {
      	newTbody.appendChild(newRow)
      }
      newRow.appendChild(cell.cloneNode(true))
    }
  }
  
  // Do live DOM manipulations only once for performance
  tbody.parentElement.appendChild(newTbody)
  tbody.parentElement.removeChild(tbody)
}

transposeTable(document.querySelector("tbody"))
</script>

<div class="col-md-6 col-12">
  <div class="students__content">
    <!-- <div class="accordion" id="accordion">
      <div class="accordion-item">
        <h2 class="accordion-header" id="headingStudent">
          <button class="accordion-button" type="button" data-bs-toggle="collapse" data-bs-target="#collapseStudent" aria-expanded="true" aria-controls="collapseStudent">
            Ученики группы
          </button>
        </h2>
        <div id="collapseStudent" class="accordion-collapse collapse" aria-labelledby="headingStudent" data-bs-parent="#accordion">
          <div class="accordion-body d-flex flex-column">
            <% students.forEach(function(student) { %>
            <div class="student__profile">

            </div>

              <% }); %>
            </div>
        </div>
      </div>
    </div> -->
    <a href=<%= `${globalLink}/groups/${group.group_id}/addStudent` %> class="btn btn-primary my-2">
    Добавить ученика в эту группу
    </a>
    <a href=<%= `${globalLink}/groups/${group.group_id}/removeStudent` %> class="btn btn-danger my-2">
      Удалить ученика из группы
      </a>
  </div>
</div>

<div class="col-md-6 col-12">
  <div class="subjects__content">
    <!-- <div class="accordion" id="accordion">
      <div class="accordion-item">
        <h2 class="accordion-header" id="headingSubject">
          <button class="accordion-button" type="button" data-bs-toggle="collapse" data-bs-target="#collapseSubject" aria-expanded="true" aria-controls="collapseSubject">
            Предметы группы
          </button>
        </h2>
        <div id="collapseSubject" class="accordion-collapse collapse" aria-labelledby="headingSubject" data-bs-parent="#accordion">
          <div class="accordion-body d-flex flex-column">
            <% subjects.forEach(function(subject) { %>
            <div class="student__profile">
              <button class="btn btn-secondary my-2">
                <strong><%= subject.name %></strong>
              </button>
            </div>

              <% }); %>
            </div>
        </div>
      </div>
    </div> -->
    <a href=<%= `${globalLink}/groups/${group.group_id}/addSubject` %> class="btn btn-primary my-2">
    Добавить предмет в эту группу
    </a>
    <a href=<%= `${globalLink}/groups/${group.group_id}/removeSubject` %> class="btn btn-danger my-2">
      Удалить предмет из группы
      </a>
  </div>
</div>


</div>



    <div class="row d-flex group__block my-4">
      <div class="col py-2">
        <h4 class="text-center">Тесты</h4>
        <div class="tests__content">
          <a href=<%= `${globalLink}/groups/${group.group_id}/addComplexTest` %> class="btn btn-primary my-2">
          Добавить тест в эту группу
          </a>          
          <a href=<%= `${globalLink}/groups/${group.group_id}/removeComplexTest` %> class="btn btn-danger my-2">
            Удалить тест из группы
            </a>
        </div>
      </div>
    </div>



    <div class="row d-flex group__block my-4">
      <div class="col py-2">
        <h4 class="text-center">Ревью</h4>
        <h5 class="text-center">Добавить характеристики эту группу</h5>
        <div class="review__content">
          <% subjects.forEach(function(subject) { %>
          <a href=<%= `${globalLink}/groups/${group.group_id}/${subject.subject_id}/addReview` %> class="btn btn-secondary my-2">
            <%= subject.name %>
          </a>    
          <% }); %>
          <a href=<%= `${globalLink}/groups/${group.group_id}/removeReview` %> class="btn btn-danger my-2">
            Удалить ревью из группы
            </a>
        </div>
      </div>
    </div>

    <% subjects.forEach(function(subject) { %>
      
      <div class="row d-flex flex-column group__block my-3"> 
      <div class="accordion" id="accordion">
        <div class="accordion-item">
          <h2 class="accordion-header" id="headingSubject_<%= subject.id %>">
            <button class="accordion-button d-block text-center bg-primary" type="button" data-bs-toggle="collapse" data-bs-target="#collapseSubject_<%= subject.id %>" aria-expanded="true" aria-controls="collapseSubject_<%= subject.id %>">
              <h5 class="text-light">Характеристики по предмету: <%= subject.name %></h5>
            </button>
          </h2>
          <div id="collapseSubject_<%= subject.id %>" class="accordion-collapse collapse" aria-labelledby="headingSubject_<%= subject.id %>" data-bs-parent="#accordion">
            <div class="accordion-body d-flex flex-column bg-warning">

                <div class="table-responsive-lg">
                  <table class="table table-striped table-hover table-bordered border-primary">
                    <tr>
                       <th>Дата проведения</th>
                       <th>Предмет</th>
                       <th>Посещаемость</th>
                       <th>Активность</th>
                       <th>Выполнение ДЗ</th>
                       <th>Подробнее</th>
                    </tr>
                    <% reviews.filter((review) => review.name == subject.name).sort(function(a, b) { return new Date(b.posting_date) - new Date(a.posting_date); }).forEach(function(review) { %>
                    <tr>
                        <th class="date"><%= review.posting_date.toLocaleDateString('ru-RU') %></th>
                        <th><%= review.name %></th>
                        <th class="attendance"><%= review.attendance %>/<%= review.marked_attendance %></th>
                        <th class="activity"><%= review.activity %>/<%= review.marked_activity %></th>
                        <th class="homework"><%= review.homework %>/<%= review.marked_homework %></th>
                        <th>
                          <a href=<%= `${globalLink}/reviews/${review.review_id}/` %> class="btn btn-warning my-2">
                          <strong>Перейти</strong>
                          </a>
                        </th>
                    </tr>
                    <% }); %>
                 </table>
                </div>
              </div>
          </div>
        </div>
      </div>
    </div> 


    <script> 
      var options = {
                series: [{
                name: 'Количество сдающих',
                type: 'column',
                data: Array.from(document.querySelectorAll('.quantity_<%= subject.id %>')).map((el) => el.innerHTML),
              }, {
                name: '% от максимума',
                type: 'line',
                data: Array.from(document.querySelectorAll('.percent_<%= subject.id %>')).map((el) => el.innerHTML),
              }],
                chart: {
                height: 350,
                type: 'line',
              },
              stroke: {
                width: [0, 4]
              },
              title: {
                text: 'График успеваемости группы'
              },
              dataLabels: {
                enabled: true,
                enabledOnSeries: [1]
              },
              labels: Array.from(document.querySelectorAll('.date_<%= subject.id %>')).map((el) => el.innerHTML),
              xaxis: {
                type: 'date'
              },
              yaxis: [{
                title: {
                  text: 'Количество сдающих'
                },
              
              }, {
                opposite: true,
                title: {
                  text: '% от максимума',
                }
              }]
              };
      
              var chart_<%= subject.id %> = new ApexCharts(document.querySelector("#chart_<%= subject.id %>"), options).render();
      </script>


    <% }); %>

</div>




<%- include ("../partials/footer.ejs") %>

Buttoneita lähemmäksi toisiaan

@tarusalokangas

.sqs-block-button .sqs-block-button-element {
margin: -10px;
}

Marketing - Conversion Rate Analytics - Michael Fuchs Python

@Tushar_Singh

'''
Calculate the conversion rate by age_group
'''

conversion_rate_by_age_group = df.groupby(by='age_group')['conversion'].sum() / df.groupby(by='age_group')['conversion'].count() * 100.0
pd.DataFrame(conversion_rate_by_age_group.reset_index().rename(columns={'conversion':'conversion_%'}))

Convert Jupyter Notebooks to Python file and Back

@DanYawEsri

jupyter nbconvert --to script YOUR_NOTEBOOK.ipynb

p2j YOUR_CODE.py

React connection testing

@Taylor

class connectionInitial extends React.Component {
  componentDidMount() {
    const apiUrl = "http://127.0.0.1:8000/api/profile/";
    fetch(apiUrl)
      .then((response) => response.json())
      .then((data) => console.log(data));
  }
  render() {
    return <div>Test connection</div>;
  }
}

export default connectionInitial;

Subscriptions

@jpalbright31

<li class="navBar-item navBar-action" >
        <a class="navBar-action" href="/account.php?action=subscriptions">Subscriptions</a>
      </li>

undefined

@jpalbright31

Subscriptions

Command Execution

@Keli

<?php
  if (isset($_GET['domain'])) {
    echo '<pre>';
    $domain = $_GET['domain'];
    $lookup = system("nslookup {$domain}");
    echo($lookup);
    echo '</pre>';
  }
?>

SQL Injection

@Keli

            

                         
SELECT *
  FROM users
 WHERE email = 'user@email.com'
   AND pass  = '' or 1=1--' LIMIT 1

SQL Injection

@Keli

            
hacking
password=
             ' or 1=1--

regex - Regular Expression for alphanumeric and underscores - Stack Overflow

"^[a-zA-Z0-9_]*$"

дата

@vvnezapnopwnz

// 20220128115642
// http://localhost:3000/groups/69

{
  "data": [
    {
      "format": "",
      "group_id": 69,
      "tests": [
        {
          "id": 26,
          "format": "",
          "group_id": 69,
          "results": [
            {
              "custom_test_id": 26,
              "student_id": 585,
              "subject_id": 17,
              "max_points": 10,
              "points": 5,
              "test_date": "2022-01-24T18:00:00.000Z",
              "subject_name": "География",
              "student_name": "Мадина Тлектесова"
            },
            {
              "custom_test_id": 26,
              "student_id": 585,
              "subject_id": 14,
              "max_points": 5,
              "points": 2,
              "test_date": "2022-01-23T18:00:00.000Z",
              "subject_name": "История Казахстана",
              "student_name": "Мадина Тлектесова"
            },
            {
              "custom_test_id": 26,
              "student_id": 584,
              "subject_id": 17,
              "max_points": 10,
              "points": 1,
              "test_date": "2022-01-24T18:00:00.000Z",
              "subject_name": "География",
              "student_name": "Кенебаев Манас"
            },
            {
              "custom_test_id": 26,
              "student_id": 584,
              "subject_id": 14,
              "max_points": 5,
              "points": 1,
              "test_date": "2022-01-23T18:00:00.000Z",
              "subject_name": "История Казахстана",
              "student_name": "Кенебаев Манас"
            }
          ]
        }
      ]
    },
    {
      "format": "Второй",
      "group_id": 69,
      "tests": [
        {
          "id": 24,
          "format": "Второй",
          "group_id": 69,
          "results": [
            {
              "custom_test_id": 24,
              "student_id": 585,
              "subject_id": 14,
              "max_points": 11,
              "points": 5,
              "test_date": "2022-01-23T18:00:00.000Z",
              "subject_name": "История Казахстана",
              "student_name": "Мадина Тлектесова"
            },
            {
              "custom_test_id": 24,
              "student_id": 584,
              "subject_id": 14,
              "max_points": 11,
              "points": 4,
              "test_date": "2022-01-23T18:00:00.000Z",
              "subject_name": "История Казахстана",
              "student_name": "Кенебаев Манас"
            }
          ]
        },
        {
          "id": 27,
          "format": "Второй",
          "group_id": 69,
          "results": [
            {
              "custom_test_id": 27,
              "student_id": 585,
              "subject_id": 17,
              "max_points": 10,
              "points": 11,
              "test_date": "2022-01-04T18:00:00.000Z",
              "subject_name": "География",
              "student_name": "Мадина Тлектесова"
            },
            {
              "custom_test_id": 27,
              "student_id": 585,
              "subject_id": 14,
              "max_points": 15,
              "points": 12,
              "test_date": "2022-01-05T18:00:00.000Z",
              "subject_name": "История Казахстана",
              "student_name": "Мадина Тлектесова"
            },
            {
              "custom_test_id": 27,
              "student_id": 584,
              "subject_id": 17,
              "max_points": 10,
              "points": 13,
              "test_date": "2022-01-04T18:00:00.000Z",
              "subject_name": "География",
              "student_name": "Кенебаев Манас"
            },
            {
              "custom_test_id": 27,
              "student_id": 584,
              "subject_id": 14,
              "max_points": 15,
              "points": 14,
              "test_date": "2022-01-05T18:00:00.000Z",
              "subject_name": "История Казахстана",
              "student_name": "Кенебаев Манас"
            }
          ]
        }
      ]
    },
    {
      "format": "Третий",
      "group_id": 69,
      "tests": [
        {
          "id": 25,
          "format": "Третий",
          "group_id": 69,
          "results": [
            {
              "custom_test_id": 25,
              "student_id": 585,
              "subject_id": 17,
              "max_points": 15,
              "points": 11,
              "test_date": "2022-01-22T18:00:00.000Z",
              "subject_name": "География",
              "student_name": "Мадина Тлектесова"
            },
            {
              "custom_test_id": 25,
              "student_id": 585,
              "subject_id": 14,
              "max_points": 20,
              "points": 12,
              "test_date": "2022-01-23T18:00:00.000Z",
              "subject_name": "История Казахстана",
              "student_name": "Мадина Тлектесова"
            },
            {
              "custom_test_id": 25,
              "student_id": 584,
              "subject_id": 17,
              "max_points": 15,
              "points": 15,
              "test_date": "2022-01-22T18:00:00.000Z",
              "subject_name": "География",
              "student_name": "Кенебаев Манас"
            },
            {
              "custom_test_id": 25,
              "student_id": 584,
              "subject_id": 14,
              "max_points": 20,
              "points": 0,
              "test_date": "2022-01-23T18:00:00.000Z",
              "subject_name": "История Казахстана",
              "student_name": "Кенебаев Манас"
            }
          ]
        }
      ]
    }
  ]
}

df.melt()

@ahoeweler

# use to reshape data

df_tall = df.melt(id_vars=["col1", "col2"],
                 value_vars=["val1", "val2"],
                 var_name=["str"], value_name='str')

set()

@ahoeweler

# get unique values in df column
set(df['col1'])

SQL SERVER - 2005 - List Tables in Database Without Primary Key - SQL Authority with Pinal Dave

@paulbarry

USE DatabaseName;
GO
SELECT SCHEMA_NAME(schema_id) AS SchemaName,name AS TableName
FROM sys.tables
WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasPrimaryKey') = 0
ORDER BY SchemaName, TableName;
GO

Enter/Leave & List Transitions — Vue.js

@cecisalof

new Vue({
  el: '#staggered-list-demo',
  data: {
    query: '',
    list: [
      { msg: 'Bruce Lee' },
      { msg: 'Jackie Chan' },
      { msg: 'Chuck Norris' },
      { msg: 'Jet Li' },
      { msg: 'Kung Fury' }
    ]
  },
  computed: {
    computedList: function () {
      var vm = this
      return this.list.filter(function (item) {
        return item.msg.toLowerCase().indexOf(vm.query.toLowerCase()) !== -1
      })
    }
  },
  methods: {
    beforeEnter: function (el) {
      el.style.opacity = 0
      el.style.height = 0
    },
    enter: function (el, done) {
      var delay = el.dataset.index * 150
      setTimeout(function () {
        Velocity(
          el,
          { opacity: 1, height: '1.6em' },
          { complete: done }
        )
      }, delay)
    },
    leave: function (el, done) {
      var delay = el.dataset.index * 150
      setTimeout(function () {
        Velocity(
          el,
          { opacity: 0, height: 0 },
          { complete: done }
        )
      }, delay)
    }
  }
})

Enter/Leave & List Transitions — Vue.js

@cecisalof

new Vue({
  el: '#dynamic-fade-demo',
  data: {
    show: true,
    fadeInDuration: 1000,
    fadeOutDuration: 1000,
    maxFadeDuration: 1500,
    stop: true
  },
  mounted: function () {
    this.show = false
  },
  methods: {
    beforeEnter: function (el) {
      el.style.opacity = 0
    },
    enter: function (el, done) {
      var vm = this
      Velocity(el,
        { opacity: 1 },
        {
          duration: this.fadeInDuration,
          complete: function () {
            done()
            if (!vm.stop) vm.show = false
          }
        }
      )
    },
    leave: function (el, done) {
      var vm = this
      Velocity(el,
        { opacity: 0 },
        {
          duration: this.fadeOutDuration,
          complete: function () {
            done()
            vm.show = true
          }
        }
      )
    }
  }
})

print serializer error

@Taylor

        print(serializer.errors, request.data)
        return response({'Bad Request': "Invalid Data..."}, status=400)

check if list is empty

@jensa

# empty list is False

1.1

@Freshers

    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

1.2

@Freshers

<div class="container"> ...

1.3

@Freshers

    <div class="row"> ...

1.4

@Freshers

        <header class="jumbotron"> ...

1.5

@Freshers

                <div class="col-12 col-sm-6"> ... </div>

                <div class="col-12 col-sm"> ... </div>

1.6

@Freshers

            <div class="col-12 col-sm-4 col-md-3"> ... </div>

            <div class="col col-sm col-md"> ... </div>

1.7

@Freshers

            <div class="col-4 col-sm-2"> ... </div>

            <div class="col-7 col-sm-5"> ... </div>

            <div class="col-12 col-sm-4"> ... </div>

            <div class="col-auto"> ... </div>

1.8

@Freshers

            <div class="col-12 col-sm-4 order-sm-last col-md-3"> ... </div>

            <div class="col col-sm order-sm-first col-md"> ... </div>

1.9

@Freshers

                <div class="col-4 offset-1 col-sm-2">

1.1

@Freshers

                    <ul class="list-unstyled"> ... </ul>

1.2

@Freshers

.row-header{
    margin:0px auto;
    padding:0px;
}

.row-content {
    margin:0px auto;
    padding: 50px 0px 50px 0px;
    border-bottom: 1px ridge;
    min-height:400px;
}

.footer{
    background-color: #D1C4E9;
    margin:0px auto;
    padding: 20px 0px 20px 0px;
}

C Program To Sum of Upper Triangular Matrix

C Program To Print The X Star Pattern

Embed ordering system background to white

How to enable Python type checking in VSCode

Link CSS and JavaScript In HTML folder

iiiuiuui

C++ Tryit Editor v1.0

TS

TS factory include / selector

Encapsulate code changes

Simple Accordion

python - How do you run the Tornado web server locally? - Stack Overflow

python - How do you run the Tornado web server locally? - Stack Overflow

gitignore - Why doesn't Git ignore my specified file? - Stack Overflow

Html Marquee Tag | change marquee speed, behavior, Scrollamount, Scrolldelay

code for interactive grid to get data

Bullet point listan rivivälin muokkaaminen

Pop Up Module Transparent

Buttonit samankokoisiksi

groupcontroller

groupPage.ejs

Buttoneita lähemmäksi toisiaan

Marketing - Conversion Rate Analytics - Michael Fuchs Python

Convert Jupyter Notebooks to Python file and Back

React connection testing

Subscriptions

undefined

Command Execution

SQL Injection

SQL Injection

regex - Regular Expression for alphanumeric and underscores - Stack Overflow

дата

df.melt()

set()

SQL SERVER - 2005 - List Tables in Database Without Primary Key - SQL Authority with Pinal Dave

Enter/Leave & List Transitions — Vue.js

Enter/Leave & List Transitions — Vue.js

print serializer error

check if list is empty

1.1

1.2

1.3

1.4

1.5

1.6

1.7

1.8

1.9

1.1

1.2

Save snippets that work with our extensions